dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #31107
[Bug 1333405] [NEW] resource table generation fails in latest 2.15 with MySQL
Public bug reported:
Bad SQL grammar when generating _dataelementgroupsetstructure.
Example of error:
Process failed: StatementCallback; bad SQL grammar [insert into _dataelementgroupsetstructure select d.dataelementid as dataelementid, d.name as dataelementname, (select deg.name from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid and degm.dataelementid = d.dataelementid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 1 limit 1) as `Elimination data element groups`, (select deg.uid from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid and degm.dataelementid = d.dataelementid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 1 limit 1) as `XqQQJskFbuC`, (select deg.name from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid and degm.dataelementid = d.dataelementid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 2 limit 1) as `Main data element groups`, (select deg.uid from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid and degm.dataelementid = d.dataelementid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 2 limit 1) as `QdPVttZAghq` from dataelement d]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'd.dataelementid' in 'on clause'
** 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/1333405
Title:
resource table generation fails in latest 2.15 with MySQL
Status in DHIS 2:
New
Bug description:
Bad SQL grammar when generating _dataelementgroupsetstructure.
Example of error:
Process failed: StatementCallback; bad SQL grammar [insert into _dataelementgroupsetstructure select d.dataelementid as dataelementid, d.name as dataelementname, (select deg.name from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid and degm.dataelementid = d.dataelementid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 1 limit 1) as `Elimination data element groups`, (select deg.uid from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid and degm.dataelementid = d.dataelementid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 1 limit 1) as `XqQQJskFbuC`, (select deg.name from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid and degm.dataelementid = d.dataelementid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 2 limit 1) as `Main data element groups`, (select deg.uid from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid and degm.dataelementid = d.dataelementid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 2 limit 1) as `QdPVttZAghq` from dataelement d]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'd.dataelementid' in 'on clause'
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1333405/+subscriptions
Follow ups
References