Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-66561

Forum mailings and maintenance jobs fails with error writing to database

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 3.7.1
    • Forum
    • MOODLE_37_STABLE

      See discussion https://moodle.org/mod/forum/discuss.php?d=389904

      Forum posts get send by email multiple times.

      Debugging the cron job reveals:

      Adhoc task failed: mod_forum\task\send_user_notifications,Fout bij het schrijven van de databank
       Debug info:
       Column count doesn't match value count at row 1
       INSERT INTO mdl_task_log (type,component,classname,userid,timestart,timeend,dbreads,dbwrites,result,output) VALUES(?,?,?,?,?,?,?,?,?,?)
       [array (
       0 => 1,
       1 => 'mod_forum',
       2 => 'mod_forum\\task
      send_user_notifications',
       3 => '2',
       4 => 1567165746.225472,
       5 => 1567165746.357841,
       6 => 22,
       7 => 2,
       8 => 0,
       9 => 'Execute adhoc task: mod_forum\\task
      send_user_notifications
      

      I notice that the first column (id) is not in the list. The table has 11 columns and here are 10 fields.

            Unassigned Unassigned
            koen Koen Roggemans
            Votes:
            13 Vote for this issue
            Watchers:
            21 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.