dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

** Changed in: dhis2
    Milestone: None => 2.16

** Changed in: dhis2
     Assignee: (unassigned) => Lars Helge Øverland (larshelge)

** Changed in: dhis2
   Importance: Undecided => High

-- 
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