** Changed in: mahara
Status: Fix Committed => Fix Released
--
You received this bug notification because you are a member of Mahara
Reviewers, 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
_______________________________________________
Mailing list: https://launchpad.net/~mahara-core
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-core
More help : https://help.launchpad.net/ListHelp
