Forums / General / Records of database
Anekdoten <<>>
Wednesday 03 August 2005 4:24:15 am
The records of database are not shown ... the error produced is the following:
Query error: 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 'AND a0.version = ezcontentobj. Query: SELECT ezcontentobject.*, ezcontentobject_tree.*, ezcontentclass.name as class_name, ezcontentclass.identifier as class_identifier , ezcontentobject_name.name as name, ezcontentobject_name.real_translation FROM ezcontentobject_tree, ezcontentobject,ezcontentclass , ezcontentobject_name , ezcontentobject_attribute a0 WHERE path_string like '/1/2/167/192/225/%' and depth <= 5 and a0.contentobject_id = ezcontentobject.id AND a0.contentclassattribute_id = AND a0.version = ezcontentobject_name.content_version AND a0.language_code = ezcontentobject_name.real_translation AND ezcontentclass.version=0 AND node_id != 225 AND ezcontentobject_tree.contentobject_id = ezcontentobject.id AND ezcontentclass.id = ezcontentobject.contentclass_id AND ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and ezcontentobject_name.content_translation = 'ita-IT' AND ezcontentobject_tree.is_invisible = 0 ORDER BY a0.sort_key_int DESC, modified_subnode DESCLIMIT 0, 20
... for kindness a help. Thank you