Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-19604

/content/browse gives SQL error in old admin

    Details

      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

        Activity

        Hide
        François Helly added a comment - - edited

        Affects 4.7, community 2012.8, community 2013.1, 5.0, 5.1

        In file ezpublish-legacy/kernel/common/ezcontentstructuretreeoperator.php line 180 :

        diff

        -                             ezcontentobject_tree.contentobject_is_published = 1 
        +                             ezcontentobject_tree.contentobject_is_published = 1 AND 
        

        Show
        François Helly added a comment - - edited Affects 4.7, community 2012.8, community 2013.1, 5.0, 5.1 In file ezpublish-legacy/kernel/common/ezcontentstructuretreeoperator.php line 180 : diff - ezcontentobject_tree.contentobject_is_published = 1 + ezcontentobject_tree.contentobject_is_published = 1 AND

          People

          • Assignee:
            unknown
            Reporter:
            Vidar Langseid
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: