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

mod_page "Data too long for column 'intro'" error upgrading 1.9 -> 2.2

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 2.2.4
    • Installation
    • None
    • MOODLE_22_STABLE

      Upgrading a copy of our prod. site from 1.9.18+ to 2.2.4+ (wanting to go to 2.3.x)
      Upgrade process stalls with following errors:

      ++ Success ++
      -->mod_page
      Default exception handler: Error writing to database Debug: Data too long for column 'intro' at row 1
      INSERT INTO mdl_page (course,name,intro,introformat,content,contentformat,revision,timemodified,legacyfiles,display,disp
      layoptions) VALUES(?,?,?,?,?,?,?,?,?,?,?)
      [array (
      0 => '2991',
      1 => 'Wortschatz',
      2 => '<p align="center" class="MsoNormal" style="text-align: center; line-height: normal; margin: 0in 0in 10pt"><b sty
      <LARGE AMOUNTS OF DATA REMOVED>

      3 => '1',
      4 => '^M
      ',
      5 => 2,
      6 => 1,
      7 => 1347042854,
      8 => 0,
      9 => 5,
      10 => 'a:2:

      {s:12:"printheading";i:0;s:10:"printintro";i:0;}

      ',
      )]

      • line 397 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 973 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1015 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
      • line 288 of /mod/resource/db/upgradelib.php: call to mysqli_native_moodle_database->insert_record()
      • line 125 of /mod/page/db/upgradelib.php: call to resource_migrate_to_module()
      • line 67 of /mod/page/db/upgradelib.php: call to page_20_migrate_candidate()
      • line 39 of /mod/page/db/install.php: call to page_20_migrate()
      • line 518 of /lib/upgradelib.php: call to xmldb_page_install()
      • line 271 of /lib/upgradelib.php: call to upgrade_plugins_modules()
      • line 1437 of /lib/upgradelib.php: call to upgrade_plugins()
      • line 155 of /admin/cli/upgrade.php: call to upgrade_noncore()

      From reading other bugs, this appears to have happened in mod_forum as well, and seems to be resolved buy changing the 'intro' field from 'text' to 'longtext'

      Any suggestions ?

      Johan
      Thunderbird School of Global Management
      learning.thunderbird.edu

            moodle.com Moodle HQ
            johanr Johan Reinalda (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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