help get error when....

[Troy J.]

i get this error when i try to change a users post count


Database error in vBulletin Control Panel 2.2.6:

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

mysql error number: 1064

Date: Saturday 13th of July 2002 10:29:02 AM
Script: http://www.straightgaming.com/vbulletin/vbulletin/admin/user.php
Referer: http://www.straightgaming.com/vbulletin/admin/user.php?action=edit&userid=10

[FWC]

See if you have the following line in your admin/user.php file: $user=$DB_site->query_first("SELECT *,FROM_UNIXTIME(joindate) AS If you do, change it to: $user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS That might help.

[Troy J.]

thx that worked

[FWC]

You're welcome. :)

[Boofo]

Boy, does that code ever look familiar! I might be easier to do a prepared message for this one, FWC. :)

Originally posted by FWC
See if you have the following line in your admin/user.php file: $user=$DB_site->query_first("SELECT *,FROM_UNIXTIME(joindate) AS If you do, change it to: $user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS That might help.

[FWC]

Originally posted by Boofo
Boy, does that code ever look familiar! I might be easier to do a prepared message for this one, FWC. :)

Yeah, there a few errors that keep popping up a lot since PHP 4.2.1 came out. :)