Details
-
Bug
-
Resolution: Duplicate
-
High
-
4.5.0alpha
-
None
Description
Gi,
When we remove the main node of an article, after adding a new location, a dba error is raised:
Fatal error: Call to a member function attribute() on a non-object in /data1/www/apache2php52/ezporacle/.run/kernel/classes/ezcontentobjecttreenode.php on line 2824 Fatal error: eZ Publish did not finish its request The execution of eZ Publish was abruptly ended, the debug output is present below.
And the information on the debug is:
Error: eZOracleDB Feb 23 2011 11:42:22
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 ( 2 ) 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 ( 2 ) 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 ) )
Error: eZContentObject::fetchByNodeID Feb 23 2011 11:42:22
A problem occured while fetching objects with following NodeIDs : 2
Steps to reproduce
- Create a "news" folder - Access the "news" folder - Create an article "article1" - Add a new location (might be home folder) for the "article1" - Delete "article1" (uncheck the send to trash)
The error is raised after deleting "article1"
Attachments
Issue Links
- relates to
-
EZP-18041 Oracle : query error when creating folders
- Closed