QUESTION
------------------------------------------------------
When I go to the "My Campaign" I get this error message. So far everything else seems to work fine.ennis
Error Occured in executing Query: 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 '(total_paused , TIMEDIFF( now( ),pause_date )) , pause_dat
SQL: update `campaigns` SET total_paused = ADDTIME(total_paused , TIMEDIFF( now( ),pause_date )) , pause_date = '2007-06-13 11:48:36' WHERE status = 'P'
ANSWER
------------------------------------------------------
This is cause by an old version of mysql. Adspy pro needs mysql 4.1 or later which was released in 2004. Please ask your host to upgrade your account to a newer version and it will work perfectly.




