dhis2-devs team mailing list archive

Thread
Date

[Bug 1497910] [NEW] DHIS2 won't start with MySQL

To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
From: Rémi Czternasty <rcz@xxxxxxxxxxxxxx>
Date: Mon, 21 Sep 2015 09:23:51 -0000
Reply-to: Bug 1497910 <1497910@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

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