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

Polls fails on Oracle migrated database

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.0, 10.7, 11.0, 12.0
    • Fix Version/s: 10.8 [Tentative], 11.0
    • Component/s: Polls
    • Labels:
    • Environment:
      Oracle
    • 11 status:
      Resolved
    • 10 status:
      Resolved
    • Conversion Script Required:
      Yes

      Description

      When navigate to polls tool Exception is displayed.

      It just happens if the database that is used is old and updated by upgrade scripts. There is a field that has to be clob that is a varchar. There wasn't a conversion script to make that conversion when the change came to the code.
      It must be added to conversion scripts:

      ALTER TABLE poll_poll ADD (tmpdetails CLOB);
      UPDATE poll_poll SET tmpdetails=poll_details;
      ALTER TABLE poll_poll DROP COLUMN poll_details;
      ALTER TABLE poll_poll RENAME COLUMN tmpdetails TO poll_details;

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  • Assignee:
                    vacercon Valerio Cerni
                    Reporter:
                    vacercon Valerio Cerni
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Git Integration