mahara-contributors team mailing list archive

[Richard Mansfield <686178@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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)

** Affects: mahara
     Importance: High
     Assignee: Richard Mansfield (richard-mansfield)
         Status: Fix Committed

** Changed in: mahara
       Status: New => Fix Committed

** Changed in: mahara
   Importance: Undecided => High

** Changed in: mahara
     Assignee: (unassigned) => Richard Mansfield (richard-mansfield)

** Changed in: mahara
    Milestone: None => 1.4.0

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/686178

Title:
  Error when deleting old notifications in mysql

Status in Mahara ePortfolio:
  Fix Committed

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)