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

Polls fails on Oracle migrated database

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.0, 10.7, 11.0, 12.0 [Tentative]
    • 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

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code