Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-3737

Block progress fires the "Error reading database" message, when monitoring a Hotpot activity.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.2.3
    • Fix Version/s: None
    • Component/s: Module: HotPot
    • Labels:
      None
    • Affected Branches:
      MOODLE_22_STABLE

      Description

      In the file blocks/progress/lib.php inside the get_monitorable_modules method the hotpot collumn, just after the WHERE clause, must be hotpotid instead.

      Steps:
      1. Create a course and a hotpotatoes activity.
      2. Configure the progress bar to start monitoring hotpotatoes activity.
      3. try to enter in the course again. It is expected to see the error messagem "Error reading database"

      Possible fix:

      Locate :

      'attempted' => "SELECT id
      FROM

      {hotpot_attempts}
      WHERE hotpot = :eventid
      AND userid = :userid",
      'finished' => "SELECT id
      FROM {hotpot_attempts}

      WHERE hotpot = :eventid
      AND userid = :userid
      AND timefinish <> 0",

      Change to :

      'attempted' => "SELECT id
      FROM

      {hotpot_attempts}
      WHERE hotpotid = :eventid
      AND userid = :userid",
      'finished' => "SELECT id
      FROM {hotpot_attempts}

      WHERE hotpotid = :eventid
      AND userid = :userid
      AND timefinish <> 0",

        Attachments

          Activity

            People

            • Assignee:
              moodle.com moodle.com
              Reporter:
              amrigo Angelo Rigo
              Participants:
              Component watchers:
              Gordon Bateson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: