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

error in sakai_1_5-2_0_mysql_conversion.sql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 2.0
    • Fix Version/s: None
    • Labels:
      None

      Description

      Line 75 is invalid for mySQL.
      UPDATE SAKAI_SITE SET MODIFIEDON=TO_TIMESTAMP('20031126034522061','YYYYMMDDHHMISSFF3') WHERE SITE_ID = '!gateway';

      should be this (using more standard sql date/time syntax):
      UPDATE SAKAI_SITE SET MODIFIEDON='2003-11-26 3:45:22' WHERE SITE_ID = '!gateway';

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  Unassigned Unassigned
                  Reporter:
                  mikersmart Mike De Simone (Inactive)
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration