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

Error when specifying the title of the content page over 255 characters

XMLWordPrintable

    • MOODLE_402_STABLE, MOODLE_403_STABLE
    • MOODLE_402_STABLE, MOODLE_403_STABLE
    • MDL-80488-403
    • Hide
      1. Log in as admin
      2. Create a course
      3. Add a Lesson activity to the course
      4. In new activity, press Add a content page
      5. Set Page title to the following:

        Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor me
        

      6. Confirm the text cuts off at 255 characters:

        Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor 
        

      7. Add text to Content 1 > Description
      8. Press Save page
      9. Confirm there is no Error writing to database exception
      10. Confirm page was created successfully
      Show
      Log in as admin Create a course Add a Lesson activity to the course In new activity, press Add a content page Set Page title to the following: Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor me Confirm the text cuts off at 255 characters: Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor Add text to Content 1 > Description Press Save page Confirm there is no Error writing to database exception Confirm page was created successfully

      If try add title to content page more than 255 characters we will stumble upon a mistake:

      Debug info: Data too long for column 'title' at row 1
      UPDATE mdl_lesson_pages SET qtype = ?,title = ?,lessonid = ?,timemodified = ?,contents = ?,contentsformat = ? WHERE id=?
      [array (
      0 => 2,
      1 => 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor me',
      2 => '1',
      3 => 1703501550,
      4 => 'is it correct?<br>',
      5 => '1',
      6 => '1',
      )]
      Error code: dmlwriteexception Stack trace:

      • line 497 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
      • line 1604 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
      • line 1636 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->update_record_raw()
      • line 178 of /mod/lesson/pagetypes/truefalse.php: call to mysqli_native_moodle_database->update_record()
      • line 179 of /mod/lesson/editpage.php: call to lesson_page_type_truefalse->update()

      Because we don't have a handler for the form on the javascript side.

            pholden Paul Holden
            fidan Synbulatov Fidan
            Glyn (Mathew) May Glyn (Mathew) May
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Kim Jared Lucas Kim Jared Lucas
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 2 minutes
                1h 2m

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