Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-38216

Limit on the size of HTML text on Lessons and unhelpful error (Mysql)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.9.0
    • Fix Version/s: 2.9.0
    • Component/s: Lessons
    • Previous Issue Keys:
      LSNBLDR-195

      Description

      In Mysql, lesson_builder_items (html) is created as type text which is limited to ~21K in UTF-8. With HTML formatting and tables we have hit this limit a few times resulting in the error "Unable to save or update item. Error was: java.sql.BatchUpdateException: Data truncation: Data too long for column 'html' at row 1. "

      I'd either convert this to mediumtext (can you just specify this in the hbm.xml?) or do something to handle this error with a better message.

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                • Assignee:
                  hedrick Charles Hedrick
                  Reporter:
                  jonespm Matthew Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Integration