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

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.1.5, 3.3.1, 3.4.2, 3.5
    • 3.3.6, 3.4.3
    • SCORM
    • MOODLE_31_STABLE, MOODLE_33_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE
    • MOODLE_33_STABLE, MOODLE_34_STABLE
    • master_MDL-59857
    • 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.  

    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

            danmarsden Dan Marsden
            sudawada kenny ferreira
            Mark Johnson Mark Johnson
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Dan Marsden, Matteo Scaramuccia, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              17/May/18