![]() |
Forum Database error 1064 Everyone once in a while I get a VBulletin Database Error in my mailbox: Database error in vBulletin 4.2.0: Invalid SQL: UPDATE user SET rmEmailDate = UNIX_TIMESTAMP() rmEmailCount = 1 WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 60 AND usergroupid IN ('10','11','2') AND rmEmailCount = 0 AND options & 16 AND rmoptout = 0 LIMIT 10;; 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 'rmEmailCount = 1 WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIX' at line 1 Error Number : 1064 Any idea what this can be? Thanks, Dirk |
الساعة الآن 04:25 AM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir