user warning: 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 ')' at line 1 query: activity_cron /* Miraploy : activity_cron */ DELETE FROM site_activity WHERE created < 1226952712) in /home/webadmin/html/sites/all/modules/activity/activity.module on line 427.

Hi, I'm getting this error on cron run.

Comments

jaydub’s picture

jaydub commented
Status: Active » Fixed

damn I missed that fix in the d6 branch. It's committed to CVS now and will appear in the next dev snapshot. In the meantime you can simply remove the parenthesis from the end of the query:

is:
DELETE FROM {activity} WHERE created < %d)

should be:
DELETE FROM {activity} WHERE created < %d

Flying Drupalist’s picture

Flying Drupalist commented

:) Thanks a lot.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.