Error when deleting old notifications in mysql

Bug #686178 reported by Richard Mansfield
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
High
Richard Mansfield

Bug Description

Cron job to delete old notifications produces an sql error in mysql.

 [WAR] 86 (lib/errors.php:743) Failed to get a recordset: mysql error: [1064: 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 'read = 1
 [WAR] 86 (lib/errors.php:743) AND type IN(
 [WAR] 86 (lib/errors.php:743) SELECT id FROM "mactivity_type' at line 2] in EXECUTE("DELETE FROM "mnotification_internal_activity" WHERE
 [WAR] 86 (lib/errors.php:743) ctime < '2010-06-08 08:45:22'
 [WAR] 86 (lib/errors.php:743) AND read = 1
 [WAR] 86 (lib/errors.php:743) AND type IN(
 [WAR] 86 (lib/errors.php:743) SELECT id FROM "mactivity_type"
 [WAR] 86 (lib/errors.php:743) WHERE name IN ('feedback'))")
 [WAR] 86 (lib/errors.php:743) Command was: DELETE FROM "mnotification_internal_activity" WHERE
 [WAR] 86 (lib/errors.php:743) ctime < ?
 [WAR] 86 (lib/errors.php:743) AND read = 1
 [WAR] 86 (lib/errors.php:743) AND type IN(
 [WAR] 86 (lib/errors.php:743) SELECT id FROM "mactivity_type"
 [WAR] 86 (lib/errors.php:743) WHERE name IN ('feedback')) and values was (2010-06-08 08:45:22)

Changed in mahara:
status: New → Fix Committed
importance: Undecided → High
assignee: nobody → Richard Mansfield (richard-mansfield)
milestone: none → 1.4.0
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.