content fails when user logged in

Next topic

Author	Message
Matthew Carroll	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
Matthew Carroll	Sunday 21 May 2006 10:12:04 am Hmmm, looks like the issue was caused by multiple locations for the same user meaning the same access permissions were assigned twice to the user. The site is running the latest svn 3.6, so I'll see if I can reproduce on 3.8 later. Strange bug. http://carroll.org.uk

Author

Message

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

Matthew Carroll

Sunday 21 May 2006 10:12:04 am

Hmmm, looks like the issue was caused by multiple locations for the same user meaning the same access permissions were assigned twice to the user. The site is running the latest svn 3.6, so I'll see if I can reproduce on 3.8 later. Strange bug.

http://carroll.org.uk