Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.4
    • Fix Version/s: 2.4, 2.3.5
    • Component/s: None
    • Labels:
      None

      Description

      When creating a lesson, there's no limit in the UI for loong lesson names. So if the teacher goes crazy and puts over 255 characters, then LAMS throws an exception and the lesson is not started (and the user doesn't get any messages):

      Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [org.lamsfoundation.lams.lesson.Lesson]; uncategorized SQLException for SQL [insert into lams_lesson (version, description, name, create_date_time, start_date_time, end_date_time, schedule_start_date_time, schedule_end_date_time, lesson_state_id, previous_state_id, learner_exportport_avail, learner_presence_avail, learner_im_avail, live_edit_enabled, locked_for_edit, marks_released, user_id, learning_design_id, class_grouping_id, organisation_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [01004]; error code [0]; Data truncation: Data too long for column 'name' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'name' at row 1

      So trim the lesson name (in java -no flash) when the LAMS creates a lesson to 254 characters

        Activity

        Hide
        dronych Andrey Balan added a comment -
        fixed
        Show
        dronych Andrey Balan added a comment - fixed
        Hide
        ernieg Ernie Ghiglione added a comment -
        Tested and closed in 2.3.4 and 2.4
        Show
        ernieg Ernie Ghiglione added a comment - Tested and closed in 2.3.4 and 2.4
        Hide
        ernieg Ernie Ghiglione added a comment -
        reclosing shortly
        Show
        ernieg Ernie Ghiglione added a comment - reclosing shortly

          People

          • Assignee:
            dronych Andrey Balan
            Reporter:
            ernieg Ernie Ghiglione
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development