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)