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

(cron) External blog entries tries to insert NULL into column 'created'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Blog
    • Labels:
      None
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      From moodle.org cron:

      Fetching external blog entries...Default exception handler: Error writing to database Debug: Column 'created' cannot be null
      INSERT INTO post (userid,module,content,uniquehash,publishstate,format,subject,summary,created,lastmodified) VALUES(?,?,?,?,?,?,?,?,?,?)
      [array (
      0 => '195XXX',
      1 => 'blog_external',
      2 => '1',
      3 => 'http://YYYYYYYYY.ZZZ/YYYYY,
      4 => 'site',
      5 => '1',
      6 => 'This entry has been removed for privacy.',
      7 => 'This entry has been removed for privacy',
      8 => NULL,
      9 => NULL,
      )]

      • line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 816 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 858 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
      • line 211 of /blog/lib.php: call to mysqli_native_moodle_database->insert_record()
      • line 457 of /lib/cronlib.php: call to blog_sync_external_entries()
      • line 61 of /admin/cli/cron.php: call to cron_run()

      !!! Error writing to database !!!

        Attachments

          Activity

            People

            Assignee:
            andyjdavis Andrew Davis
            Reporter:
            jtomkinson Jordan Tomkinson
            Tester:
            Nobody
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              24/Nov/10