Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-26977

2.9 Oracle conversion script has an error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.9.0
    • Fix Version/s: 2.9.0
    • Component/s: Profile
    • Labels:
      None
    • Previous Issue Keys:
      PRFL-776

      Description

      This sql:
      PRFL-612 add avatar image url column to uploaded and external image records
      alter table PROFILE_IMAGES_T add RESOURCE_AVATAR varchar2(4000) not null;

      Gives this error:
      >[Error] Script lines: 701-703 ----------------------
      ORA-01758: table must be empty to add mandatory (NOT NULL) column
      Script line 703, statement line 2, column 13 

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                steve.swinsburg Steve Swinsburg
                Reporter:
                chmaurer@iupui.edu Chris Maurer
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration