I have a few databasejoin elements that use the {tablename___elementname} placeholder in the WHERE condition.
For example this is the WHERE/ORDER clause I am using...
WHERE {thistable}.id IN ({fb_reports___valid_facility_types}) ORDER BY listorder
The {tablename___elementname} is an element in the same table/list/form containing the databasejoin element (fb_reports). This is not a joined table with any repeat groups either.
Since I updated from Github this morning these elements produce errors - and {tablename___elementname} is now always empty. For example, now I am getting this error (when using the example above)...
If difficulties persist, please contact the System Administrator of this site and report the error below.
For example this is the WHERE/ORDER clause I am using...
WHERE {thistable}.id IN ({fb_reports___valid_facility_types}) ORDER BY listorder
The {tablename___elementname} is an element in the same table/list/form containing the databasejoin element (fb_reports). This is not a joined table with any repeat groups either.
Since I updated from Github this morning these elements produce errors - and {tablename___elementname} is now always empty. For example, now I am getting this error (when using the example above)...
If difficulties persist, please contact the System Administrator of this site and report the error below.
1064 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 ')' at line 4 SQL=SELECT `fb_reports_repeat_included_reports`.id AS id,`fb_reports_repeat_included_reports`.parent_id, `fb_reports_repeat_included_reports`.`included_reports` AS value, `fb_facility_types`.`facility_type` AS text FROM `fb_reports_repeat_included_reports` LEFT JOIN fb_facility_types ON `fb_facility_types`.`id` = `fb_reports_repeat_included_reports`.`included_reports` WHERE fb_reports_repeat_included_reports.id IN ()