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

        Boris created issue -
        David Johnson made changes -
        Field Original Value New Value
        Fix Version/s 3.1.1 [ 10282 ]
        Hide
        David Johnson added a comment -

        Fix ed in 3.1 branch (control.vm) and in 4.0 (macros.vm).

        Show
        David Johnson added a comment - Fix ed in 3.1 branch (control.vm) and in 4.0 (macros.vm).
        David Johnson made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 4.0 [ 10270 ]
        Resolution Fixed [ 1 ]
        David Johnson made changes -
        Assignee Roller Unassigned [ roller_unassigned ] David Johnson [ djohnson ]
        Henri Yandell made changes -
        Project Import Fri Mar 27 23:38:16 PDT 2009 [ 1238222296558 ]
        Mark Thomas made changes -
        Workflow jira [ 12458962 ] Default workflow, editable Closed status [ 12623039 ]
        Hide
        Glen Mazza added a comment -

        Closing all resolved/fixed issues of already released versions of Roller.

        Show
        Glen Mazza added a comment - Closing all resolved/fixed issues of already released versions of Roller.
        Glen Mazza made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Glen Mazza made changes -
        Component/s Installation & Configuration [ 12312743 ]
        Component/s Configuration & Settings [ 12312745 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        119d 5h 59m 1 David Johnson 01/Jul/07 04:26
        Resolved Resolved Closed Closed
        2015d 17h 20m 1 Glen Mazza 05/Jan/13 20:46

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development