Execute SQL Query Problem
 

Automatic Query
Helpful, predefined queries for mass updating the settings of users and posts. Once a query is executed it can not be reversed.

On - Display Reputation

"Error"
Query (On - Display Reputation)
UPDATE user SET options = options + 1024 WHERE NOT (options & 1024)

then click continue

An error occurred while attempting to execute your query. The following information was returned.
error number: 1065
error desc: Query was empty

I looked at the user table and could not find where the display reputation is, so I manually cannot even edit it, anybody got any clues on where it is so I can turn everyone on? lol, I mean turn the feature on for everyone :D

Pretty sure that was a bug that I saw fixed at vB.com, either way just run the query it showed manually:

[sql]UPDATE user SET options = options + 1024 WHERE NOT (options & 1024)[/sql]

thanks, sorry bout the wrong forum thing

just so ya know, I get this same error running the query seperate from the ACP

An error occurred while attempting to execute your query. The following information was returned.
error number: 1065
error desc: Query was empty

altho I can run the code from phpmyadmin just fine, maybe the ACP query is mussed up

http://www.vbulletin.com/forum/showt...930#post597930
http://www.vbulletin.com/forum/bugs....iew&bugid=1956

I assume its to do with that bug :)

thanks, you are all over it :D

I appreciate your help :)