AnsweredAssumed Answered

Error upgrading mysql from 5.2 to 5.3

Question asked by rilisema on Mar 17, 2011
Latest reply on Jun 7, 2011 by frederikheremans1
Hi,

when I upgrade my database from version 5.2 to 5.3 the following error occurs:


     [java] SEVERE: problem during schema upgrade, statement 'alter table ACT_HI_TASKINST add PRIORITY_ integer
     [java] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'PRIORITY_'

After this error I dropped the activiti database tables (ant db.drop) and tried to create the tables again.
To my surprise, the same error occurs!

This was in my development environment.
In my production environment I don't want to drop the activiti tables, I don't want to loose my process data!

greetings,
Richard

Outcomes