dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Hi Tom,

I'm copying this to the  dhis2-users team and mailing list; you can
sign up here: https://launchpad.net/~dhis2-users

I just did a clean install of version 2.7 against Mysql, and I seem to
be able to enter data without getting the error you got.
"Caused by (com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException):
Table 'dhis2.minmaxdataelement' doesn't exist"

However, I see that there is no table called "minmaxdataelement" in
MySql (149 tables total), whereas it is there when I do the same in
Postgres (150 tables). This does indicate that there is a problem with
the data generation for MySql.

I have reported this as a bug, https://bugs.launchpad.net/dhis2/+bug/985800

I hope this will be fixed for the upcoming 2.8 release. While you wait
for that, you could probably run the following SQL query to add the
missing table:

CREATE TABLE minmaxdataelement
(
  minmaxdataelementid int(11) NOT NULL,
  sourceid int(11),
  dataelementid int(11),
  categoryoptioncomboid int(11),
  `minvalue` int(11) NOT NULL,
  `maxvalue` int(11) NOT NULL,
  generated bool NOT NULL
)

Knut