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

Problem Updating to 2.0 RC1 :Debug info: Data too long for column 'description' at row 1

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Blocker Blocker
    • None
    • 2.0
    • Administration
    • None
    • OS=openSUSE 11.1
      mysql=5.0.67 SUSE MySQL RPM
      php=5.3.3
      Apache/2.2.10 (Linux/SUSE)
    • MySQL
    • MOODLE_20_STABLE
    • Difficult

      i was trying to update my moodle 1.9.9 (Build: 20100609) to 2.0 RC1. When updating the database following error occurs:

      Upgrading to new version
      You are not logged in. (Login)
      System
      Increasing size of user idnumber field, this may take a while...
      Migrated course files - course 1082/1082.

      0 sec
      100%
      Migrated blog attachments - 202/209.

      0 sec
      96.65%
      Fixing mnet records, this may take a while...
      This upgrade introduces two new navigation blocks that will replace these blocks: Administration, Courses, Activities and Participants. If you had set any special permissions on those blocks you should check to make sure everything is behaving as you want it.

      Error writing to database

      More information about this error

      Debug info: Data too long for column 'description' at row 1
      UPDATE mdl_user SET description = ?,descriptionformat = ? WHERE id=?
      [array (
      0 => 'Mimi<br />
      <br />
      <br />
      <br />
      <br />
      .
      .
      manny equal lines
      .
      .
      <br />
      <br />
      <br /> ',
      1 => '1',
      2 => '7459',
      )]
      Stack trace:

      • line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 922 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 954 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->update_record_raw()
      • line 2403 of /lib/db/upgrade.php: call to mysqli_native_moodle_database->update_record()
      • line 1307 of /lib/upgradelib.php: call to xmldb_main_upgrade()
      • line 253 of /admin/index.php: call to upgrade_core()

      the table mdl_user has 15831 lines.

            moodle.com Moodle HQ
            ludwigroeder Ludwig Röder (Inactive)
            Nobody Nobody (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.