#009107: error/warnings on content/trash/2

Description:

I removed one object to the trash and when accessing the trash I don't see it and I get this in the debug output:


Error: eZMySQLDB      Oct 03 2006 11:08:48

Query error: Unknown column 'ezcontentclass.name' in 'field list'. Query: SELECT
                        ezcontentobject.*,
                        ezcot.*,
                        ezcontentclass.name as class_name,
                        ezcontentclass.identifier as class_identifier
                        , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation  
FROM
                        ezcontentobject_trash AS ezcot,
                        ezcontentobject,
                        ezcontentclass
                        , ezcontentobject_name 
                        
                   WHERE
                        ezcontentclass.version=0 AND
                        ezcot.contentobject_id = ezcontentobject.id  AND
                        ezcontentclass.id = ezcontentobject.contentclass_id AND
                         ezcot.contentobject_id = ezcontentobject_name.contentobject_id and
                                   ezcot.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 ) 

                        
                        
                         AND 
 ezcontentobject.language_mask & 7 > 0 

                         ORDER BY ezcontentobject_name.name ASC
                        
LIMIT 0, 25


Warning: PHP      Oct 03 2006 11:08:48

array_keys() [<a href='function.array-keys'>function.array-keys</a>]: The first argument should be an array in /srv/ezpublish/sites/eztrunk/kernel/classes/ezcontentobjecttrashnode.php on line 276


Warning: PHP     Oct 03 2006 11:08:48

Invalid argument supplied for foreach() in /srv/ezpublish/sites/eztrunk/kernel/classes/ezcontentobjecttrashnode.php on line 276

Environment:

Version: trunk (pre 3.9alpha1)
PHP Version:
Webserver:
Database:


- Attachments

No attachments for this issue.


- Comments

Tested in trunk (3.9alpha1, rev 17104)

#249776 by Lenara Anafieva on October 9th, 2006 [Permanent Link]

- History
Properties
Type Bug
Priority Medium
Component Misc
Affects Unknown
Fix Version -
Reporter Kristof Coomans
Responsible -
Status 0 Closed
Resolution Works Here
Created October 3rd, 2006
Updated October 9th, 2006
Resolved October 9th, 2006
 
Navigation [Permanent Link]
Previous Issue
Back to Issues List
Next Issue: #013700
  eZImageAliasHandler bug when Exif contains ComponentsConfiguration