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

Postem username field is too short causing write errors on mysql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0
    • Component/s: Post'Em
    • Labels:
    • 10 status:
      Resolved
    • Conversion Script Required:
      Yes

      Description

      The username field in SAKAI_POSTEM_STUDENT is varchar(36).

      If you have a Sakai user with an eid longer than 36 characters (e.g. a guest user with a very long email address), then uploading a spreadsheet containing that username causes a mysql write failure:

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

      The field should be redefined to be varchar(255) in StudentGradesImpl.hbm.xml and a conversion script included.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  jonespm Matthew Jones
                  Reporter:
                  smarquard Stephen Marquard
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration