Apache Roller
  1. Apache Roller
  2. ROL-1363

Migration Oracle database 3.0 to 3.1 partitialy failed

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 3.1
    • Fix Version/s: 3.1.1, 4.0
    • Labels:
      None
    • Environment:
      Oracle

      Description

      There is a bug in oracle db script: 300-to-310-migration.sql

      – The rag_group_subscription table has been simplified and no longer needs a
      – primary key but we don't want to drop the field just yet because that would
      – make it impossible to abort a 3.1 upgrade and return to 3.0.
      alter table rag_group_subscription drop id not null;
      alter table rag_group_subscription drop id not null
      *
      ERROR at line 1:
      ORA-00905: missing keyword

      alter table rag_group_subscription drop primary key;

        Activity

          People

          • Assignee:
            David Johnson
            Reporter:
            Boris
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development