manifoldcf-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Florian Schmedding (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CONNECTORS-887) Database schema not updated properly
Date Mon, 10 Feb 2014 16:50:21 GMT
Florian Schmedding created CONNECTORS-887:
---------------------------------------------

             Summary: Database schema not updated properly
                 Key: CONNECTORS-887
                 URL: https://issues.apache.org/jira/browse/CONNECTORS-887
             Project: ManifoldCF
          Issue Type: Bug
          Components: Framework core
    Affects Versions: ManifoldCF 1.6
         Environment: MySQL database
            Reporter: Florian Schmedding
            Priority: Minor


When running Manifold 1.6 the first time with an database schema from Manifold 1.3 the schema
is not updated properly. The SQL-command 

"ALTER TABLE authconnections MODIFY groupname VARCHAR(32) NOT NULL REFERENCES authgroups(groupname)
ON DELETE RESTRICT"

fails. It should instead add the column:

"ALTER TABLE authconnections ADD groupname VARCHAR(32) NOT NULL REFERENCES authgroups(groupname)
ON DELETE RESTRICT"

The next startup after executing the corrected SQL-statement succeeds.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message