Public bug reported:
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).
** Affects: dhis2
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1497910
Title:
DHIS2 won't start with MySQL
Status in DHIS:
New
Bug description:
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).
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1497910/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
