i got this error kindly check it
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT userid, username, usergroupid, birthday, showbirthday, posts, timezoneoffset,
DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL ((timezoneoffset - 4)*60) MINUTE), '%D of %M') AS BDisplay,
(DATE_FORMAT(DATE_SUB(UTC_TIMESTAMP(), INTERVAL (timezoneoffset - 4) HOUR), '%Y') - SUBSTRING(birthday,7,4)) AS UserAge
FROM 1l_user
WHERE birthday LIKE DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL ((timezoneoffset - 4)*60) MINUTE), '%m-%d%%')
AND showbirthday > '1'
AND usergroupid NOT IN ()
AND userid NOT IN (SELECT 1l_ap_birthday.userid FROM 1l_ap_birthday);
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 userid NOT IN (SELECT 1l_ap_birthday.userid FROM 1l_ap_birthday)' at line 7
Error Number : 1064
Request Date : Monday, April 8th 2013 @ 09:18:07 PM
Error Date : Monday, April 8th 2013 @ 09:18:08 PM
Script : http://www.XXXXXX.com/XXXXX/cronadmin.php?do=runcron&cronid=70
Referrer : http://www.XXXXXX.com/XXX/cronadmin.php?do=modify
IP Address : 103.22.201.159
Username : _Mike74
Classname : vB_Database
MySQL Version : 5.5.21-log