Uploaded image for project: 'Coopr'
  1. Coopr
  2. COOPR-703

MySQL upgrade SQL script doesn't work

    XMLWordPrintableJSON

    Details

    • Rank:
      1|hzyncf:

      Description

      When trying to run the upgrade script, we get this error.

      # mysql -p coopr < /opt/coopr/server/sql/upgrade-tables-pre0.9.9-to-0.9.9.sql
      Enter password:
      ERROR 1064 (42000) at line 19: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS(SELECT * FROM sys.columns WHERE Name = N'version' AND OBJECT_ID = ' at line 1
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alvin Alvin Wang
                Reporter:
                chris Chris Gianelloni
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: