Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-59857

SCORM does not accept a minimum requried score of 100 when using oracle db

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.1.5, 3.3.1, 3.4.2, 3.5
    • Fix Version/s: 3.3.6, 3.4.3
    • Component/s: SCORM
    • Labels:
    • Testing Instructions:
      Hide

      With activity completion enabled and using Oracle as the database.

      login as a teacher and add a SCORM package to the course,

      set "completion tracking" to "show activity as complete when conditions met"
      set the field "Require minimum score" to "100" and save the package - no errors should occur.

       

      Show
      With activity completion enabled and using Oracle as the database. login as a teacher and add a SCORM package to the course, set "completion tracking" to "show activity as complete when conditions met" set the field "Require minimum score" to "100" and save the package - no errors should occur.  
    • Affected Branches:
      MOODLE_31_STABLE, MOODLE_33_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE
    • Fixed Branches:
      MOODLE_33_STABLE, MOODLE_34_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      master_MDL-59857

      Description

      When using an Oracle DB, it looks like scorm field 'completionscorerequired' is set as type number(2) which cannot accept a score of 100.

      This works with mysql which sets 'completionscorerequired' as type tinyint(2)

       

       

       

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                17/May/18