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

    XMLWordPrintable

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

      Attachments

        Activity

          People

            chen chen
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: