Details
-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
3.10.1, 4.0.1
-
None
-
Operating System: RHEL5
PHP Version: (please be specific, like '4.4.3' or '5.1.5') 4.4.8
Database and version: postgresql 8.3
Browser (and version):
Description
Error: error executing query: SELECT DISTINCT ot.node_id, ot.path_identification_string, oname.name, ca.contentclass_id
FROM ezcontentobject_tree as ot, ezcontentclass_attribute as ca,
ezcontentobject_attribute as oa, ezcontentobject_name as oname
WHERE ot.parent_node_id='' AND ot.contentobject_is_published='1'
AND oa.language_code='eng-GB' AND oa.sort_key_string='2'
AND ( ( ca.contentclass_id='25' AND ca.identifier='type' )
OR ( ca.contentclass_id='6' AND ca.identifier='type' ) ) AND ca.version=0
AND oname.contentobject_id=ot.contentobject_id AND oname.contentobject_id=ot.contentobject_id
AND oname.content_version=ot.contentobject_version AND oname.content_translation=oa.language_code
AND ot.contentobject_id=oa.contentobject_id AND ot.contentobject_version=oa.version
AND ca.id=oa.contentclassattribute_id
ORDER BY ot.priority ERROR: invalid input syntax for integer: ""
Steps to reproduce
when creating new pages
Attachments
Issue Links
- duplicates
-
EZP-14615 Database errors in search engine logic using PHP 5.2.9
- Closed