PDA

View Full Version : mysql error can anyone help?


VBUsers
05-16-2006, 05:08 AM
i get this error. its from the vb favorites hack i beleive.

Database error in vBulletin 3.5.3:

Invalid SQL:

DELETE FROM smora_favorites as favorites
WHERE userid = 6784
OR (entry_type = 'user' AND entry_id = 6784);

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'as favorites
WHERE userid = 6784
OR (entry_type = 'user' AN
Error Number : 1064
Date : Monday, May 15th 2006 @ 07:58:46 AM
Script : http://www.thenextelforums.com
Referrer : http://www.thenextelforums.com
IP Address : 0000000000
Username : Caddyman
Classname : vb_database

hambil
05-16-2006, 11:53 AM
i get this error. its from the vb favorites hack i beleive.

Database error in vBulletin 3.5.3:

Invalid SQL:

DELETE FROM smora_favorites as favorites
WHERE userid = 6784
OR (entry_type = 'user' AND entry_id = 6784);

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'as favorites
WHERE userid = 6784
OR (entry_type = 'user' AN
Error Number : 1064
Date : Monday, May 15th 2006 @ 07:58:46 AM
Script : http://www.thenextelforums.com
Referrer : http://www.thenextelforums.com
IP Address : 0000000000
Username : Caddyman
Classname : vb_database

The 'as favorites' isn't necessary and typically not used in a delete. Your version of MySQL may not even support it. Remove the 'as favorites' and you should be okay.

You also might want to post this in the favorites hack thread.

VBUsers
05-25-2006, 07:30 AM
The 'as favorites' isn't necessary and typically not used in a delete. Your version of MySQL may not even support it. Remove the 'as favorites' and you should be okay.

You also might want to post this in the favorites hack thread.


do you mean remove the table or just the words?

hambil
05-25-2006, 10:52 AM
just the words "as favorites"