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 DESC LIMIT 0, 20 ... for kindness a help. Thank you
|