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

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.1.0beta1
    • Component/s: Upgrading
    • Labels:
      None
    • Environment:

      RHEL 6.4
      PHP: 5.3.3
      Mysql: 5.1.61

      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

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              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