Hi,
I've gotten this error the last couple of night at 2:00am when the cron.php runs. Any ideas what is up and how to fix? The site seams to run okay, but don;t know if more damages is being done.
Query:
SELECT `ID` FROM `Profiles` WHERE `Status` = 'Unconfirmed' AND (`Couple`=0 OR `Couple` > `ID`) AND (TO_DAYS(NOW()) - TO_DAYS(`DateReg`)) % = 0
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 '= 0' at line 1
Found error in the file '/home/xxxxxxxx/xxxxxxx.com/periodic/cron.php(120) : eval()'d code' at line 1.
Called 'getAll' function with erroneous argument #0.