SQL Query: Set all users to have Signature Enabled by default!

[fionix]

Can someone provide me with the code for a Manual Query to change all users to 'Show Signature'. I recently enabled this option by default for new registrations via vbulletin settings>options but want to have every one else that is already registered set to show signature.

Thank you very much, your help is much appreciated.

[Lynne]

Admincp > Maintenance > Execute SQL Query > pick On-Display Signatures from the dropdown and run the query.


If you want to do it via phpMyAdmin, then (add a table prefix, if needed):

[COLOR=#262D35][FONT=monospace][SIZE=12px]UPDATE user SET options = options + 1 WHERE NOT (options & 1)[/SIZE][/FONT][/COLOR]

[fionix]

Thank you, but I get the below error when I run the query:
-- The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, XX and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
--
Do I need to ask my host for something?

[fionix]

Thank you, but I get the below error when I run the query:
-- The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, XX and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
--
Do I need to ask my host for something?

Thats when I run it from within the AdminCP

[fionix]

If you want to do it via phpMyAdmin, then (add a table prefix, if needed):  Code:   UPDATE user SET options = options + 1 WHERE NOT (options & 1) 

When I try that, nothing happens... hmmm.

[fionix]

Everything sorted out together with our host.. thank you for your help it works.