Note:? Here is additional information:
**OK, this is what I found out.? ? We had a plugin installed on the site called 'Miserable Users'? and one of the admins tried to add an user to that particliar addin as he was causing trouble.
The IP address showing up in the database error is the ip address that the admin was trying add to miserable users.? ? ? But if memory serves me the system asked for userid rather than IP.? ? That is all I have to go on for now.
We currently run Vbulletin 3.7.2 at? <[url removed, login to view]>? and after the first of the year is started having database issues.? ? Here is a sampling of one of errors:
Database error in vBulletin 3.7.2:
? ? ? SELECT MIN(postid) AS postid
? ? ? FROM post
? ? ? WHERE threadid = 145124
? ? ? ? AND visible = 1
? ? ? ? AND dateline > 1231199902
? ? ? ? AND userid NOT IN (35548,,[url removed, login to view])
? ? ? LIMIT 1;
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 '[url removed, login to view])
? ? ? LIMIT 1' at line 6
Error Number? : 1064
Request Date? : Monday, January 5th 2009 @ 04:02:30 PM
Error Date? ? ? : Monday, January 5th 2009 @ 04:02:30 PM
Script? ? ? ? ? ? ? : <[url removed, login to view]>
Referrer? ? ? ? ? : <[url removed, login to view]>
IP Address? ? ? :
Username? ? ? ? ? :
Classname? ? ? ? : vB_Database
MySQL Version : [url removed, login to view]
Currently Mods are able to post, but users can not.