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

ORACLE : ezp4.4->ezp4.5 upgrade : SQL error on error when running upgrade scripts regarding ezpublishingqueueprocesses table

    Details

      Description

      Hi

      When running the SQL upgradescripts for oracle I get:

      $ cd extension/ezoracle/update/database/ezpublish/4.5/unstable
      $ sqlpluss
      SQL> @dbupdate-4.4.0-to-4.5.0alpha1.sql
       
      1 row updated.
       
       
      1 row updated.
       
       
      Table created.
       
      SQL> @dbupdate-4.5.0alpha1-to-4.5.0beta1.sql
       
      1 row updated.
       
       
      1 row updated.
       
      CREATE TABLE ezpublishingqueueprocesses (
                   *
      ERROR at line 1:
      ORA-00955: det finnes allerede et objekt med det navnet
       
       
       
      Table created.
       
       
      Index created.
       
       
      Table created.
       
       
      Index created.
       
       
      Table created.
       
       
      Sequence created.
       
       
      Trigger created.
       
       
      Index created.
       
       
      Index created.
       
       
      Table created.
       
       
      Sequence created.
       
       
      Trigger created.
       
       
      Index created.
       
       
      SQL> @dbupdate-4.5.0beta1-to-4.5.0beta2.sql
       
      1 row updated.
       
       
      1 row updated.
      
      

      This is because ezpublishingqueueprocesses is defined in both dbupdate-4.4.0-to-4.5.0alpha1.sql and dbupdate-4.5.0alpha1-to-4.5.0beta1.sql

        Issue Links

          Activity

          Show
          Chen Xiongjie added a comment - Fixed in ezoracle 2.2.0 https://github.com/ezsystems/ezoracle/commit/941714143384f9f258d44c3d7b65632885964552
          Hide
          Geir Arne Waaler added a comment -

          Reported as fixed. I move it to Closed.

          Geir Arne Waaler
          eZ Documentation

          Show
          Geir Arne Waaler added a comment - Reported as fixed. I move it to Closed. Geir Arne Waaler eZ Documentation

            People

            • Assignee:
              Chen Xiongjie
              Reporter:
              Vidar Langseid
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: