Ran this mod before in the earlier v3.7 versions and it worked fine.
Re-installed it with v3.7.4 and the usergroups don't change, this error message is received some hours later when the cron job runs.
Quote:
Database error in vBulletin 3.7.4:
Invalid SQL:
UPDATE forum_user
SET usergroupid = 16
WHERE usergroupid IN(02,)
AND lastactivity < 1219107463;
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 ')
AND lastactivity < 1219107463' at line 3
Error Number : 1064
Request Date : Monday, November 17th 2008 @ 12:57:43 AM
Error Date : Monday, November 17th 2008 @ 12:57:43 AM
Script : http://www.xxxxx.org/cron.php?rand=1226883462
Referrer : http://www.xxxxx.org/f29/jenny-mccarthy-726/
IP Address : 92.237.xxx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :
|