Database error

[TitanJeff]

I got this today while trying to edit someone's signature:

Invalid SQL: SELECT userid
FROM user
WHERE username='KeViN32285'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

I'd like to learn how to deal with these problems by learning more about how it works. Can anyone refer me to a document/thread which discusses database errors for BEGINNERS?

Thanks!

[Cary]

You need to upgrade your version of vBulletin to 2.2.9 or 2.3.0

If you are already running one of those versions, let me know.

[TitanJeff]

You need to upgrade your version of vBulletin to 2.2.9 or 2.3.0

If you are already running one of those versions, let me know.

I hadn't upgraded because a friend had installed some hacks for me and I didn't feel comfortable doing them myself. Would upgrading correct this problem? Thanks.

[Steve Machol]

It should but to be sure you should have posted the complete error message.

[TitanJeff]

It should but to be sure you should have posted the complete error message.

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT userid
FROM user
WHERE username='KeViN32285'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

Date: Sunday 02nd of March 2003 11:45:19 AM
Script: http://www.gotitans.com/goForum/goForum/admin/user.php
Referer: http://www.gotitans.com/goForum/admi...dit&userid=891


That's the entire message. Thanks.

[Steve Machol]

Yes, upgrading should fix this problem.

[Jake Bunce]

http://www.vbulletin.com/forum/showthread.php?threadid=50098