I have just installed drupal 4.5.0 with the Events and the Remindme modules. Remindme is
configured to send reminders every day. There are no events posted yet.
Now I get once per day the following error message in the drupal error log:
user 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 'na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') GROU query: SELECT r.nid, r.timestamp, u.uid AS user, u.name, u.mail, n.title, n.body, e.start FROM remindme_node r INNER JOIN node n ON r.nid = n.nid INNER JOIN node_access na ON (na.nid = 0 OR na.nid = n.nid) INNER JOIN users u ON r.uid = u.uid INNER JOIN event e ON e.nid = r.nid WHERE n.status = 1 AND r.timestamp > 0 AND 1106675220 + r.timestamp > e.start na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') GROUP BY user, n.nid in /XXXXXX/includes/database.mysql.inc on line 125.
Looks like the SQL in the cron hook is erroneous, but I'm not an SQL guru.
The installed MySQL version is 4.0.22
Comments
Comment #1
killes@www.drop.org commentedThanks, fixed.
Comment #2
signal11 commentedThanks, fixed.
Where? What is the fix?
Comment #3
Aress commentedI got the same error. I installed the CVS version and now it works.
Aress
Comment #4
(not verified) commented