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

          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