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 -
        Hide
        dronych Andrey Balan added a comment -
        fixed
        Show
        dronych Andrey Balan added a comment - fixed
        dronych Andrey Balan made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        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
        ernieg Ernie Ghiglione made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Hide
        ernieg Ernie Ghiglione added a comment -
        reclosing shortly
        Show
        ernieg Ernie Ghiglione added a comment - reclosing shortly
        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