DB Exception when updating from 5.2.0 to 7.0.1

Igor Khomenko
Added almost 4 years ago

Got next exception when run Tigase 1st time after upgraded from 5.2.0 to 7.0.1:

2015-04-24 14:03:14.580 [main]             JDBCMsgRepository.checkDB()        SEVERE:   could not alter table msg_history to add missing column by SQL:
alter table msg_history alter column msg_type int NOT NULL
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int NOT NULL' at line 1

Replies (1)

Added by Wojciech Kapcia TigaseTeam almost 4 years ago

Thanks for the report. This was fixed in the master and will be included in the 7.0.2 (it's also available in current stable branch).