Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-6102

Additional info field of profile not stored above 255 characters

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.2.1, 2.2.2, 2.2.3
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      debian linux / jdk1.5.0 / tomcat5.5.17 / mysql5 / mysql-connector-java-3.1.13-bin.jar

      Description

      The additional info field of the profile larger than 255 chars is not updated into the db since it is stored in the NOTES field:

      NOTES varchar(255)

      Mysql than throws:

      Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'NOTES' at row 1

      As a consequence, the profile as a whole is not serialized but remains in the http session, with all subsequent consequences.

      Either change the field type to TEXT or raise a proper warning at UI level.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  Unassigned Unassigned
                  Reporter:
                  roland Roland Groen
                  Votes:
                  3 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration