[
https://issues.apache.org/jira/browse/CONNECTORS-887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13897071#comment-13897071
]
Karl Wright commented on CONNECTORS-887:
----------------------------------------
r1566761 (trunk)
> 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.5
> Environment: MySQL database
> Reporter: Florian Schmedding
> Assignee: Karl Wright
> Priority: Minor
> Labels: database, easyfix
> Fix For: ManifoldCF 1.5.1, ManifoldCF 1.6
>
>
> 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)
