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

Database check shows eznode_assignment error after 5.1 upgrade

    XMLWordPrintable

Details

    Description

      After upgrading a ezp5.0 (ezflow) to ezp5.1 the following error is present in upgrade database check

      Mysql:

      The database is not consistent with the distribution database.
      To synchronize your database with the distribution setup, run the following SQL commands:
      ALTER TABLE eznode_assignment CHANGE COLUMN remote_id remote_id varchar(100) NOT NULL DEFAULT '0';
      

      Postgres:

      ALTER TABLE eznode_assignment RENAME COLUMN remote_id TO remote_id_tmp;
      ALTER TABLE eznode_assignment ADD COLUMN remote_id character varying(100);
      ALTER TABLE eznode_assignment ALTER remote_id SET DEFAULT '0'::character varying ;
      ALTER TABLE eznode_assignment ALTER remote_id SET NOT NULL ;
      UPDATE eznode_assignment SET remote_id=remote_id_tmp;
      ALTER TABLE eznode_assignment DROP COLUMN remote_id_tmp;
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            Joao.Pingo-obsolete@ez.no Joao Pingo (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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 - 3 days, 2 hours, 30 minutes
                3d 2h 30m