[CONNECTORS-887] Database schema not updated properly

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: ManifoldCF 1.5
• Fix Version/s: ManifoldCF 1.5.1, ManifoldCF 1.6
• Component/s: Framework core
• Labels: database easyfix

Environment

MySQL database

• Assignee: Karl Wright
• Reporter: Florian Schmedding
• Created: 10/Feb/14 16:50
• Updated: 11/Feb/14 08:23
• Resolved: 10/Feb/14 21:55

Description

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.