Database error each night it runs

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.

Quote · 22 Nov 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.