Records of database

Author Message

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.