document details

Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (dtd.document_type = d.document_type OR dtd.d...' at line 20
SELECT d.document_type, d.qub_location, d.ucd_location, d.noteworthy, d.paddi_id, dtd.detail_cd, dtd.detail_description, dtd.help, dtd.copyable, dt.detail_data FROM (documents d, document_type_details dtd) LEFT JOIN document_details dt ON (d.document_id = dt.document_id AND dtd.detail_cd = dt.detail_cd) WHERE d.document_id = AND (dtd.document_type = d.document_type OR dtd.document_type = 'default') ORDER BY dtd.ordering
There has been an error, cannot query database, please try again later.




Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND a.architect_id = da.architect_id' at line 6
SELECT da.architect_id, a.name FROM document_architects da, architect a WHERE da.document_id = AND a.architect_id = da.architect_id
There has been an error, cannot query database, please try again later.

Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND sl.structure_id = sd.structure_id AND sl.stru...' at line 15
SELECT sd.structure_id, sd.structure_location_id, CONCAT_WS(' - ',s.structure_name,sa.structure_name,sb.structure_name) AS structure_name, sa.structure_name AS parent_name, sl.location FROM (structure_documents sd, structure_location sl) LEFT JOIN structure s ON (s.structure_id = sd.structure_id) LEFT JOIN structure sa ON (s.parent_id = sa.structure_id) LEFT JOIN structure sb ON (sa.parent_id = sb.structure_id) WHERE sd.document_id = AND sl.structure_id = sd.structure_id AND sl.structure_location_id = sd.structure_location_id
There has been an error, cannot query database, please try again later.