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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 2.2.3
    • Module: HotPot
    • None
    • MOODLE_22_STABLE

      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",

            moodle.com Moodle HQ
            amrigo Angelo Rigo (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.