usmf Posted January 11, 2021 Share Posted January 11, 2021 (edited) I've been trying to read through previous posts and the Help Guides, but so far have not found an answer to this. Our forum has had signatures enabled for a long time, but we're considering removing them. When the whole Signature option is toggled to off/disabled, they are hidden -- but the information (text and/or images) in the signatures is not deleted. If the Signatures are again enabled, there is all the same text and image that was there before. Is there a way to delete all content in signatures when disabling them? Thanks! Edited January 16, 2021 by usmf Link to comment Share on other sites More sharing options...
Miss_B Posted January 11, 2021 Share Posted January 11, 2021 1 hour ago, usmf said: I've been trying to read through previous posts and the Help Guides, but so far have not found an answer to this. Our forum has had signatures enabled for a long time, but we're considering removing them. When the whole Signature option is toggled to off/disabled, they are hidden -- but the information (text and/or images) in the signatures is not deleted. If the Signatures are again enabled, there is all the same text and image that was there before. Is there a way to delete all content in signatures when disabling them? Thanks! The signature content is stored in the signature field in the core_members table. To delete them all you can run this sql query in the Sql box of your database in phpmyadmin. UPDATE core_members SET signature = ''; You can delete them for certain groups only as well btw, and not everyone, should you want to keep signatures of your staff members or special/vip groups.cccore_membersore_members Link to comment Share on other sites More sharing options...
Daniel F Posted January 11, 2021 Share Posted January 11, 2021 1 minute ago, Miss_B said: The signature content is stored in the signature field in the core_members table. To delete them all you can run this sql query in the Sql box of your database in phpmyadmin. UPDATE core_members SET signature = ''; You can delete them for certain groups only as well btw, and not everyone, should you want to keep signatures of your staff members or special/vip groups.cccore_membersore_members No, please don't do this! You'll end up with a bunch of attachments which aren't associated to any content (yet) and then they'll probably appear magically again resulting in false bug reports and tickets. Please NEVER update any database column manually! NEVER! Miss_B 1 Link to comment Share on other sites More sharing options...
Miss_B Posted January 11, 2021 Share Posted January 11, 2021 Just now, Daniel F said: No, please don't do this! You'll end up with a bunch of attachments which aren't associated to any content (yet) and then they'll probably appear magically again resulting in false bug reports and tickets. Please NEVER update any database column manually! NEVER! Sorry about that. You are right, I did not think about the unassociated attachments from the deletion which are being handled by core_Signatures value for location_key field. I had the text only in mind. Thank you for pointing that out. Link to comment Share on other sites More sharing options...
usmf Posted January 11, 2021 Author Share Posted January 11, 2021 42 minutes ago, Daniel F said: No, please don't do this! You'll end up with a bunch of attachments which aren't associated to any content (yet) and then they'll probably appear magically again resulting in false bug reports and tickets. Please NEVER update any database column manually! NEVER! Thanks for the advice . . . but now what's the fix? Link to comment Share on other sites More sharing options...
Miss_B Posted January 11, 2021 Share Posted January 11, 2021 2 minutes ago, usmf said: Thanks for the advice . . . but now what's the fix? You can either log in on every member account who has a signature and delete them from their Accounts Settings, or you can request a custom plugin that can do that properly. Link to comment Share on other sites More sharing options...
usmf Posted January 11, 2021 Author Share Posted January 11, 2021 17 minutes ago, Miss_B said: You can either log in on every member account who has a signature and delete them from their Accounts Settings, or you can request a custom plugin that can do that properly. Is that really the only solution on such a detailed software? Logging into more than 70,000 accounts manually is not sounding good. Are the files for signatures not deposited in a certain file that can be cleaned out? Link to comment Share on other sites More sharing options...
Miss_B Posted January 11, 2021 Share Posted January 11, 2021 1 minute ago, usmf said: Is that really the only solution on such a detailed software? Logging into more than 70,000 accounts manually is not sounding good. Are the files for signatures not deposited in a certain file that can be cleaned out? The signature content is stored in the database and not php files. Hence why it will require a custom plugin to delete them properly. Link to comment Share on other sites More sharing options...
usmf Posted January 11, 2021 Author Share Posted January 11, 2021 36 minutes ago, Miss_B said: The signature content is stored in the database and not php files. Hence why it will require a custom plugin to delete them properly. Oh dear. How do you get a custom plugin? Link to comment Share on other sites More sharing options...
Miss_B Posted January 11, 2021 Share Posted January 11, 2021 8 minutes ago, usmf said: Oh dear. How do you get a custom plugin? You can start a topic here with your request. https://invisioncommunity.com/forums/forum/506-customization-requests/ Link to comment Share on other sites More sharing options...
Recommended Posts