|
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
|