content fails when user logged in

Wednesday 17 May 2006 9:31:43 am

i'm seeing what may be a bug, but i'm having trouble narrowing it down at all and would appreciate any help / ideas. it seems that when some users are logged in the content fails to be fetched. php gives a warning at this line in ezcontentobjecttreenode.php:

$sqlPartPart[] = 'ezcontentobject.contentclass_id in (' . implode( ', ', $limitationArray[$ident] ) . ')';

...consequently causing lots of errors in the sql queries:

Warning: PHP  	May 17 2006 16:47:53

implode(): Bad arguments. in /home/gv/public_html/ezsvn/kernel/classes/ezcontentobjecttreenode.php on line 1443

Error: eZMySQLDB 	May 17 2006 16:47:53

Query error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ')) OR (ezcontentobject.section_id in (36)) OR (ezcontentobject.. Query: SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.name as class_name,
                       ezcontentclass.identifier as class_identifier
                       
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                   FROM
                      ezcontentobject_tree,
                      ezcontentobject,ezcontentclass
                      , ezcontentobject_name 
                      
                      
                      
                   WHERE
                       path_string like '/1/43/1102/%' and  depth = 3  and  
                      
                      
                      
                      ezcontentclass.version=0 AND
                      
                      ezcontentobject_tree.contentobject_id = ezcontentobject.id  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id AND
                      
                      
                       ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                   ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
                                   ezcontentobject_name.content_translation = 'eng-GB' 
                      AND ezcontentobject_tree.is_invisible = 0
                       AND ((ezcontentobject.section_id in (1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 3, 30, 31, 32, 33, 34, 35, 6, 9)) OR (ezcontentobject.contentclass_id in ()) OR (ezcontentobject.section_id in (36)) OR (ezcontentobject.section_id in (36))) 
                 ORDER BY  path_string ASC

...the really strange thing is that if i clear all caches it works ok for a while, then breaks again later. it seems to be dependent on which user is logged in. if i log in with a different account, or remain anonymous, then it works again, switch back to the other account and it breaks.

any ideas?

thanks
matthew

http://carroll.org.uk