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

(ezupgrade) upgrade consistencie check's gives warnings in ezp 4.2.0 and 4.1.x upgrade to ezp 4.5

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Medium Medium
    • Resolution: Unresolved
    • Affects Version/s: 4.1.4, 4.2.0
    • Fix Version/s: QA tracked issues
    • Labels:
      None
    • Environment:

      Operating System: Debian 5
      PHP Version: 5.2.17
      Database and version: mysql 5.1
      Browser (and version): firefox 3.6

      Description

      Installing a clean ezp version in one of the mentioned versions generates the following error:

      This Message if using php52
      To synchronize your database with the distribution setup, run the following SQL commands:
      DROP TABLE ezm_block;
      DROP TABLE ezm_pool;

      After upgrading to version to 4.5 and all of the ezflow extensions:

      ALTER TABLE ezinfocollection ADD INDEX ezinfocollection_co_id_created ( contentobject_id, created );
      ALTER TABLE ezkeyword_attribute_link ADD INDEX ezkeyword_attr_link_oaid ( objectattribute_id );
      ALTER TABLE ezm_pool ADD INDEX ezm_pool_block_id_ts_hidden ( block_id, ts_hidden );
      DROP TABLE ezstarrating;
      DROP TABLE ezstarrating_data;
      ALTER TABLE ezm_pool ADD INDEX ezm_pool_block_id_ts_hidden ( block_id, ts_hidden );

      Steps to reproduce

      1 . Install a clean 4.1.x or 4.2 version with ezflow
      2 . Verify upgrade check tool messages for database consistence
      3 . Upgrade using the ezupgrade tool
      4 . Verify upgrade check tool messages for database consistence

        Issue Links

          Activity

          Hide
          João Pingo added a comment -

          After some retests this are the issues of the upgrade check by version:

          Versions: 4.2.0, 4.1.4, 4.1.2, 4.1.1:

          ALTER TABLE ezm_pool ADD INDEX ezm_pool__block_id__ts_hidden ( block_id, ts_hidden );
          

          Version 4.1.3:

          ALTER TABLE ezinfocollection ADD INDEX ezinfocollection_co_id_created ( contentobject_id, created );ALTER TABLE ezkeyword_attribute_link ADD INDEX ezkeyword_attr_link_oaid ( objectattribute_id );
          

          Version 4.1.0:

          ALTER TABLE ezinfocollection ADD INDEX ezinfocollection_co_id_created ( contentobject_id, created );
          ALTER TABLE ezkeyword_attribute_link ADD INDEX ezkeyword_attr_link_oaid ( objectattribute_id );
          ALTER TABLE ezworkflow_event CHANGE COLUMN data_text1 data_text1 varchar(255) DEFAULT NULL;
          ALTER TABLE ezworkflow_event CHANGE COLUMN data_text2 data_text2 varchar(255) DEFAULT NULL;
          ALTER TABLE ezworkflow_event CHANGE COLUMN data_text3 data_text3 varchar(255) DEFAULT NULL;
          ALTER TABLE ezworkflow_event CHANGE COLUMN data_text4 data_text4 varchar(255) DEFAULT NULL;
          

          Show
          João Pingo added a comment - After some retests this are the issues of the upgrade check by version: Versions: 4.2.0, 4.1.4, 4.1.2, 4.1.1: ALTER TABLE ezm_pool ADD INDEX ezm_pool__block_id__ts_hidden ( block_id, ts_hidden ); Version 4.1.3: ALTER TABLE ezinfocollection ADD INDEX ezinfocollection_co_id_created ( contentobject_id, created );ALTER TABLE ezkeyword_attribute_link ADD INDEX ezkeyword_attr_link_oaid ( objectattribute_id ); Version 4.1.0: ALTER TABLE ezinfocollection ADD INDEX ezinfocollection_co_id_created ( contentobject_id, created ); ALTER TABLE ezkeyword_attribute_link ADD INDEX ezkeyword_attr_link_oaid ( objectattribute_id ); ALTER TABLE ezworkflow_event CHANGE COLUMN data_text1 data_text1 varchar(255) DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_text2 data_text2 varchar(255) DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_text3 data_text3 varchar(255) DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_text4 data_text4 varchar(255) DEFAULT NULL;
          Hide
          João Pingo added a comment -

          Same issues upgrade to 4.7.0 plus the following lines are presented in 4.1.x versions

          DROP TABLE ezstarrating;
          DROP TABLE ezstarrating_data;

          Show
          João Pingo added a comment - Same issues upgrade to 4.7.0 plus the following lines are presented in 4.1.x versions DROP TABLE ezstarrating; DROP TABLE ezstarrating_data;

            People

            • Assignee:
              Bertrand Dunogier
              Reporter:
              João Pingo
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: