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

        ernieg Ernie Ghiglione created issue -
        dronych Andrey Balan made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        ernieg Ernie Ghiglione made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        ernieg Ernie Ghiglione made changes -
        Resolution Fixed [ 1 ]
        Status Closed [ 6 ] Reopened [ 4 ]
        ernieg Ernie Ghiglione made changes -
        Status Reopened [ 4 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]

          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