Details
-
Bug
-
Resolution: Unresolved
-
High
-
5.0.0-dev
-
None
Description
The content/browse nows gives this sql errors in old admin
Error: eZMySQLiDB Sep 05 2012 11:41:17 Query error (1064): 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 '( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND ' at line 26. Query: SELECT ezcontentobject.*, ezcontentobject_tree.*, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container, ezcontentobject_name.name as name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE ezcontentobject_tree.parent_node_id = 2 and ezcontentclass.version=0 AND ezcontentobject.contentclass_id IN ( 1, 3 ) AND ezcontentobject_tree.contentobject_is_published = 1 ( 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 ORDER BY ezcontentobject_tree.priority ASC Error: PHP: E_USER_ERROR Sep 05 2012 11:41:17 mysqli_query(): Query error (1064): 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 '( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND ' at line 26. Query: SELECT ezcontentobject.*, ezcontentobject_tree.*, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container, ezcontentobject_name.name as name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE ezcontentobject_tree.parent_node_id = 2 and ezcontentclass.version=0 AND ezcontentobject.contentclass_id IN ( 1, 3 ) AND ezcontentobject_tree.contentobject_is_published = 1 ( 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 ORDER BY ezcontentobject_tree.priority ASC in /var/www/apache2php53/ezpublish5/app/ezpublish_testsystem/.run/lib/ezdb/classes/ezmysqlidb.php on line 419 Notice: eZMySQLiDB::query(0.000 ms) query number per page:0 Sep 05 2012 11:41:17 SELECT ezcontentobject.*, ezcontentobject_tree.*, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container, ezcontentobject_name.name as name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE ezcontentobject_tree.parent_node_id = 2 and ezcontentclass.version=0 AND ezcontentobject.contentclass_id IN ( 1, 3 ) AND ezcontentobject_tree.contentobject_is_published = 1 ( 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 ORDER BY ezcontentobject_tree.priority ASC Warning: PHP: E_WARNING Sep 05 2012 11:41:17 Invalid argument supplied for foreach() in /var/www/apache2php53/ezpublish5/app/ezpublish_testsystem/.run/kernel/common/ezcontentstructuretreeoperator.php on line 200
FYI : not able to reproduce in admin2
Steps to reproduce
#1 enable old admin
#2 log in to old admin
#3 clear cache
#4 Click "Booksmarks" in right menu
#5 Click "Add items" button
#6 Click "User accounts" in top menu
#7 The menioned SQL errors will appear on /content/browse/5