Disabling Signature and Deleting Text/Photos Inside

[usmf]

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

[Miss_B]

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

[Daniel F]

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]

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. 

[usmf]

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? 

[Miss_B]

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.

[usmf]

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?

[Miss_B]

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.

[usmf]

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?

[Miss_B]

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/