Moodle

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.6.4
• Fix Version/s: 1.9.5
• Component/s: Forum, General, Workshop
• Labels:

  None

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.

• Assignee:

  David Mudrak

  Reporter:

  David Mudrak

  Participants:

  David Mudrak, Martin Dougiamas, Petr Škoda (skodak)

• Created:

  19/Feb/07 5:42 PM

  Updated:

  04/May/09 5:27 PM

  Resolved:

  04/May/09 5:27 PM