System Error

Database Query Error

ErrorNo: 1064, Message:Database error while executing: 'SELECT xar_dd_itemid , MAX(CASE WHEN xar_dd_propid = 189 THEN xar_dd_value ELSE '' END) AS dd_189
FROM egn_dynamic_data
WHERE xar_dd_propid IN (189)
GROUP BY xar_dd_itemid HAVING dd_189 = '; error description is: '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'.

Explanation:

A database query could not be executed, either because the query could not be understood or because it returned unexpected results.

Click here to raise a bug