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

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 4.7.0-dev
    • Component/s: Upgrading
    • Labels:
      None
    • Environment:

      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

            Assignee:
            pa@ez.no Patrick Allaert
            Reporter:
            pedro.resende Pedro Resende
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: