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

(postgres) Upgrading 4.7 to 5.0 in postgres show the following warnings in upgrade check

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: High High
    • Resolution: Won't Fix
    • Affects Version/s: Known Issues Legacy Stack, 5.0
    • Component/s: None
    • Labels:
      None
    • Environment:

      OS: Debian 6
      PHP: PHP 5.3.3
      DB: Postgres 8.4

      Description

      After finishing the upgrade to 5.0 we get the following warnings in upgrade check..

      The database is not consistent with the distribution database.
       
      To synchronize your database with the distribution setup, run the following SQL commands:
       
      DROP INDEX ezgeneral_digest_user_id;
      CREATE UNIQUE INDEX ezgeneral_digest_user_id ON ezgeneral_digest_user_settings USING btree ( user_id );
      DROP TABLE ez_ct_change_entry;
      DROP TABLE ez_ct_change_log;
      

        Issue Links

          Activity

          Hide
          Pedro Resende (Inactive) added a comment -

          Just tested with eZ Demo Content and got the following errors in the database check

          The database is not consistent with the distribution database.
           
          To synchronize your database with the distribution setup, run the following SQL commands:
           
          DROP INDEX ezgeneral_digest_user_id;
          CREATE UNIQUE INDEX ezgeneral_digest_user_id ON ezgeneral_digest_user_settings USING btree ( user_id );
          ALTER TABLE ezcomment RENAME COLUMN session_key TO session_key_tmp;
          ALTER TABLE ezcomment ADD COLUMN session_key character varying(32);
          ALTER TABLE ezcomment ALTER session_key SET DEFAULT NULL ;
          UPDATE ezcomment SET session_key=session_key_tmp;
          ALTER TABLE ezcomment DROP COLUMN session_key_tmp;
           
          DROP TABLE ez_ct_change_entry;
          DROP TABLE ez_ct_change_log;

          Show
          Pedro Resende (Inactive) added a comment - Just tested with eZ Demo Content and got the following errors in the database check The database is not consistent with the distribution database.   To synchronize your database with the distribution setup, run the following SQL commands:   DROP INDEX ezgeneral_digest_user_id; CREATE UNIQUE INDEX ezgeneral_digest_user_id ON ezgeneral_digest_user_settings USING btree ( user_id ); ALTER TABLE ezcomment RENAME COLUMN session_key TO session_key_tmp; ALTER TABLE ezcomment ADD COLUMN session_key character varying(32); ALTER TABLE ezcomment ALTER session_key SET DEFAULT NULL ; UPDATE ezcomment SET session_key=session_key_tmp; ALTER TABLE ezcomment DROP COLUMN session_key_tmp;   DROP TABLE ez_ct_change_entry; DROP TABLE ez_ct_change_log;
          Hide
          Vidar Langseid added a comment -

          FYI : The ez_ct_* tables are ez_network monitor tables and are not handled by the upgrade check.
          This is a known issue

          The other tables needs to be looked into

          Show
          Vidar Langseid added a comment - FYI : The ez_ct_* tables are ez_network monitor tables and are not handled by the upgrade check. This is a known issue The other tables needs to be looked into
          Hide
          Pedro Resende (Inactive) added a comment -

          Vidar: I've used Setup Wizard, since it's an upgrade.

          Show
          Pedro Resende (Inactive) added a comment - Vidar: I've used Setup Wizard, since it's an upgrade.

            People

            • Assignee:
              Unassigned
              Reporter:
              Joao Pingo (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 30 minutes
                30m