mahara-contributors team mailing list archive

[François Marier <francois@xxxxxxxxxx>]

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

-- 
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 Released

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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/686178/+subscriptions