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] [Commented] (CONNECTORS-887) Database schema not updated properly
Date Tue, 11 Feb 2014 08:23:19 GMT

    [ https://issues.apache.org/jira/browse/CONNECTORS-887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13897631#comment-13897631
] 

Florian Schmedding commented on CONNECTORS-887:
-----------------------------------------------

Thanks for looking into it, Karl. I had already deleted the logs. The wrong statement was
present in the manifold log and I didn't search for the java exception.

> 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)

Mime
View raw message