Uploaded image for project: 'LAMS Development'
  1. LAMS Development
  2. LDEV-2959

Upgrading to 2.4.1 throws and exception when updating room_name file in lams_presence_chat_msgs

    Details

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

      Description

      In patch02040014.sql, the update of room_name to lesson_id has the following statement:

       UPDATE lams_presence_chat_msgs SET room_name=SUBSTRING_INDEX(room_name, '_', 1);

      However, it seems that previously there instead of _ we used to use a -. Therefore some older room_names don't get updated properly an exceptions are thrown on upgrade:

      java.sql.SQLException: Data truncated for column 'lesson_id' at row 1

        Activity

        Hide
        ernieg Ernie Ghiglione added a comment -
        done
        Show
        ernieg Ernie Ghiglione added a comment - done

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development