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

Database Check Failed after upgrading from Ez Publish 4.6 > 4.7 rc1 with Postgres

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: High High
    • 4.7.0-dev
    • Upgrading
    • None
    • Operating System: Debian 6.0
      PHP Version: PHP 5.3.3-7+squeeze3 with Suhosin-Patch
      Database and version: Posgres 8.4.8
      Browser (and version): Any

    Description

      After making a clean installation of eZ Publish 4.6, in Postgres, and upgrading to eZ Publish 4.7 rc1 I get the following in the Database Consistency Check:

      The database is not consistent with the distribution database.

      To synchronize your database with the distribution setup, run the following SQL commands:

      ALTER TABLE ONLY ezpending_actions ADD CONSTRAINT ezpending_actions_pkey PRIMARY KEY ( id );
      ALTER TABLE ezx_ezpnet_module_branch ADD COLUMN branch_id integer;
      ALTER TABLE ezx_ezpnet_module_branch ALTER branch_id SET DEFAULT 0 ;
      ALTER TABLE ezx_ezpnet_module_branch ALTER branch_id SET NOT NULL ;

      ALTER TABLE ezstarrating RENAME COLUMN rating_average TO rating_average_tmp;
      ALTER TABLE ezstarrating ADD COLUMN rating_average real;
      ALTER TABLE ezstarrating ALTER rating_average SET DEFAULT 0::real ;
      ALTER TABLE ezstarrating ALTER rating_average SET NOT NULL ;
      UPDATE ezstarrating SET rating_average=rating_average_tmp;
      ALTER TABLE ezstarrating DROP COLUMN rating_average_tmp;

      ALTER TABLE ezstarrating_data RENAME COLUMN rating TO rating_tmp;
      ALTER TABLE ezstarrating_data ADD COLUMN rating real;
      ALTER TABLE ezstarrating_data ALTER rating SET DEFAULT 0::real ;
      ALTER TABLE ezstarrating_data ALTER rating SET NOT NULL ;
      UPDATE ezstarrating_data SET rating=rating_tmp;
      ALTER TABLE ezstarrating_data DROP COLUMN rating_tmp;

      Steps to reproduce
      1. Make a clean installation of Ez Publish 4.6
      2. Register in Service Portal
      3. Run Sync_Network cronjob
      4. Run Monitor cronjob
      5. Upgrade to eZ Publish 4.7 rc1
      6. Run Sync_Network cronjob 
      7. Run Monitor cronjob
      8. Make a Database Consistency Check
      
      

      Attachments

        Activity

          People

            e8318ba6-e4ae-477c-9116-36c073bd11a3@accounts.ibexa.co Patrick Allaert
            pedro.resende pedro.resende
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: