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

Missing column 'whatgrade' in prefix_scorm table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.9.1
    • 1.8.7, 1.9.3
    • SCORM
    • None
    • Any
    • MOODLE_19_STABLE
    • MOODLE_18_STABLE, MOODLE_19_STABLE

    Description

      I noticed that I could not change the "Attempts grading" setting while creating or updating a SCORM/AICC module in a course: no matter what option I choose when I next look at the form it still says "Highest Attempt".
      I did some searching and found out that the correct column ("whatgrade") does not exist in the table definition!

      When I run the following query the problem is solved:

      ALTER TABLE `mdl_scorm` ADD `whatgrade` TINYINT NOT NULL DEFAULT '0' AFTER `maxattempt`

      I checked /mod/scorm/db/install.xml and also could not find the column defintion. Can someone with CVS access please fix install.xml and check whether this is a solution for some problems?

      Thanks in advance,

      Hans

      Attachments

        Issue Links

          Activity

            People

              piers Piers Harding
              hansdezwart Hans de Zwart
              Dan Marsden Dan Marsden
              Dan Marsden, Matteo Scaramuccia, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                15/Oct/08