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

Lessons tool gets blocked when adding activities limited to certain groups in instances with oracle db

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.3, 11.0
    • Fix Version/s: 11.0, 12.0
    • Component/s: Lessons
    • Labels:
    • 11 status:
      Resolved
    • 10 status:
      Resolved
    • Conversion Script Required:
      Yes
    • Previous Issue Keys:
      LSNBLDR-600

      Description

      When a instructor tries to add an assignment restricted to groups the lessons tool gets blocked.

      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 lesson_builder_groups ADD (tmpgroups CLOB);
      UPDATE lesson_builder_groups SET tmpgroups=groups;
      ALTER TABLE lesson_builder_groups DROP COLUMN groups;
      ALTER TABLE lesson_builder_groups RENAME COLUMN tmpgroups TO groups;

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  mkelsey Molly Kelsey (Inactive)
                  Reporter:
                  alex@asic.udl.es Alexandre Ballesté
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code