I got an error on my vBulletin 3.6.5 board this morning with has no hacks or
mods installed. (imported from IPB 1.2)
The error is as follows;
Database error in vBulletin 3.6.5:
Invalid SQL:
SELECT username, usergroupid, user.userid, moderator.userid as moduserid
FROM vb_user AS user
LEFT JOIN vb_moderator AS moderator ON(user.userid = moderator.userid)
WHERE user.userid IN(641,,641,,641);
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 '641,,641)' at line 4
Error Number : 1064
Date : Friday, April 27th 2007 @ 04:19:07 PM
Script : http://www.wielerarchieven.be/forum/...userlist=buddy
Referrer :
IP Address : xx.xx.xx.xx
Username : verhaegen
Classname : vB_Database_MySQLi
Where the error happens is pretty obvious, it's in the IN part.
The userid for username verhaegen = 641.
Don't know where to start looking what's the cause of this error. So any help
would be appreciated
mods installed. (imported from IPB 1.2)
The error is as follows;
Database error in vBulletin 3.6.5:
Invalid SQL:
SELECT username, usergroupid, user.userid, moderator.userid as moduserid
FROM vb_user AS user
LEFT JOIN vb_moderator AS moderator ON(user.userid = moderator.userid)
WHERE user.userid IN(641,,641,,641);
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 '641,,641)' at line 4
Error Number : 1064
Date : Friday, April 27th 2007 @ 04:19:07 PM
Script : http://www.wielerarchieven.be/forum/...userlist=buddy
Referrer :
IP Address : xx.xx.xx.xx
Username : verhaegen
Classname : vB_Database_MySQLi
Where the error happens is pretty obvious, it's in the IN part.
The userid for username verhaegen = 641.
Don't know where to start looking what's the cause of this error. So any help
would be appreciated
Comment