PDA

View Full Version : Execute SQL Query Problem


SiXXGuNNZ
01-22-2004, 09:15 PM
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

NTLDR
01-22-2004, 09:35 PM
Pretty sure that was a bug that I saw fixed at vB.com, either way just run the query it showed manually:

UPDATE user SET options = options + 1024 WHERE NOT (options & 1024)

SiXXGuNNZ
01-22-2004, 11:28 PM
Pretty sure that was a bug that I saw fixed at vB.com, either way just run the query it showed manually:

UPDATE user SET options = options + 1024 WHERE NOT (options & 1024)
thanks, sorry bout the wrong forum thing

SiXXGuNNZ
01-23-2004, 01:16 AM
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

NTLDR
01-23-2004, 09:18 AM
http://www.vbulletin.com/forum/showthread.php?p=597930#post597930
http://www.vbulletin.com/forum/bugs.php?do=view&bugid=1956

I assume its to do with that bug :)

SiXXGuNNZ
01-23-2004, 11:20 AM
http://www.vbulletin.com/forum/showthread.php?p=597930#post597930
http://www.vbulletin.com/forum/bugs.php?do=view&bugid=1956

I assume its to do with that bug :)
thanks, you are all over it :D

I appreciate your help :)