[MDL-59857] SCORM does not accept a minimum requried score of 100 when using oracle db - Moodle Tracker

XML

Word

Printable

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:
https://github.com/danmarsden/moodle
Pull Master Branch:
master_~~MDL-59857~~
Pull Master Diff URL:
https://github.com/moodle/moodle/compare/master...danmarsden:master_MDL-59857
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.

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)

Participants:: Andrew Lyons, CiBoT, Dan Marsden, David Monllaó, Eloy Lafuente (stronk7), kenny ferreira, Mark Johnson

Component watchers:: Dan Marsden, Matteo Scaramuccia, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie