Details
Description
I can see these error messages in my database log file. It seems that at least cron.php is using invalid SQL statement and my database server complains about this:
2007-02-19 10:25:01 CET moodle_cz SELECTERROR: invalid input syntax for integer: ""
2007-02-19 10:25:01 CET moodle_cz SELECTSTATEMENT: SELECT * FROM mdl_workshop_assessments WHERE id = '' LIMIT 1
...
2007-02-19 10:28:25 CET moodle_cz SELECTERROR: invalid input syntax for integer: ""
2007-02-19 10:28:25 CET moodle_cz SELECTSTATEMENT: SELECT * FROM mdl_forum_subscriptions WHERE userid = '' AND forum = '5' LIMIT 1
...
2007-02-19 10:30:01 CET moodle_cz SELECTERROR: invalid input syntax for integer: ""
2007-02-19 10:30:01 CET moodle_cz SELECTSTATEMENT: SELECT * FROM mdl_workshop_assessments WHERE id = '' LIMIT 1
...
2007-02-19 10:35:01 CET moodle_cz SELECTERROR: invalid input syntax for integer: ""
2007-02-19 10:35:01 CET moodle_cz SELECTSTATEMENT: SELECT * FROM mdl_workshop_assessments WHERE id = '' LIMIT 1
Thus Moodle should check if it is providing valid integers before executing the query.
Assigning to me temporarily because Vy-Shane no longer works for Moodle HQ.