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, 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