Hi,
I’m trying to install dhis2 (version 2.20) on a server with MySQL (5.5) but I get the following exception from hibernate :
_ * ERROR 2015-09-08 16:42:31,683 HHH000388: Unsuccessful: create table programrule (programruleid integer not null auto_increment, uid varchar(11), code varchar(50), created datetime, lastUpdated datetime, name varchar(230) not null, description varchar(255), programid integer not null, programstageid integer, condition longtext not null, priority integer, primary key (programruleid)) (SchemaUpdate.java [dhis2-next.tentelemed.com-startStop-1])
- ERROR 2015-09-08 16:42:31,685 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 ‘condition longtext not null, priority integer, primary key (programruleid))’ at line 1 (SchemaUpdate.java [dhis2-next.tentelemed.com-startStop-1])
_The problem is that field “condition” is a reserved MySQL keyword (since Mysql 5.0). So is there any way to get around this problem?
Thank for your answers,
Rémi