Details
-
Bug
-
Resolution: Fixed
-
High
-
4.5.0beta1
-
None
Description
Hi
In ezwebin I try to create folders and are given these SQL errors:
Error (933): ORA-00933: SQL-kommandoen er ikke avsluttet riktig Failed query at offset 99: SELECT co.*, con.name as name, con.real_translation, cot.node_id FROM ezcontentobject AS co JOIN ezcontentobject_tree AS cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version JOIN ezcontentobject_name AS con ON co.id = con.contentobject_id AND co.current_version = con.content_version WHERE cot.node_id IN ( 62 ) AND ( bitand( con.language_id, co.language_mask ) > 0 AND bitand( co.language_mask - bitand( co.language_mask, con.language_id ), 1 ) + bitand( co.language_mask - bitand( co.language_mask, con.language_id ), 2 ) < bitand( con.language_id, 1 ) + bitand( con.language_id, 2 ) ) Start of error: AS co JOIN ezcontentobject_tree AS cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version JOIN ezcontentobject_name AS con ON co.id = con.contentobject_id AND co.current_version = con.content_version WHERE cot.node_id IN ( 62 ) AND ( bitand( con.language_id, co.language_mask ) > 0 AND bitand( co.language_mask - bitand( co.language_mask, con.language_id ), 1 ) + bitand( co.language_mask - bitand( co.language_mask, con.language_id ), 2 ) < bitand( con.language_id, 1 ) + bitand( con.language_id, 2 ) )
btw, ORA-00933: SQL command not properly ended
The folder is however created, and seems to work...
Also, I don't get the error when I create a folder ("vtest" ) below node 2
If if I then create new subfolder below "vtest", I get the error
Attachments
Issue Links
- relates to
-
EZP-18039 (tc-247)(Oracle) removing main node after adding new locations raises a eZOracleDB error
- Closed