[
https://issues.apache.org/jira/browse/CONNECTORS-887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13896765#comment-13896765
]
Karl Wright commented on CONNECTORS-887:
----------------------------------------
Ah, I just noticed that your database is MySQL. I did not notice that earlier.
If you can provide the actual stack trace of the upgrade failure, that would be
great. If not, I will need to look at this later tonight.
> 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)
