Forums / General / eZ Oracle 1.5 - ORA-00920: invalid relational operator

eZ Oracle 1.5 - ORA-00920: invalid relational operator

Author Message

Franz Hübertus

Wednesday 27 February 2008 3:32:31 am

Hi,

we've mirgated a working eZ Publish 3.9.0 installation from MySQL 5 to Oracle and now we get the following error:

[ Feb 27 2008 12:06:47 ] [192.168.XXX.XXX] eZOracleDB:
Error (920): ORA-00920: invalid relational operator

Failed query at offset 283:
SELECT count(*) AS count
FROM ezcontentobject_link
WHERE from_contentobject_id=217 AND
from_contentobject_version=5 AND
to_contentobject_id=219 AND
( relation_type & 8 ) != 0 AND
contentclassattribute_id=188 AND
op_code='0'

Start of error:
& 8 ) != 0 AND
contentclassattribute_id=188 AND
op_code='0'

Seem it doesn't like the bit operation (relation_type & 8). Is there any bugfix / workaround / tip available?

best regards

FranzH