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

Block Ranking compatability with 2.7.2

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.7.2
    • Fix Version/s: None
    • Component/s: Block: Ranking
    • Labels:
      None
    • Affected Branches:
      MOODLE_27_STABLE

      Description

      We are trying to install the Ranking Block on Moodle 2.7.2 and we are getting the below error. Is the Ranking Block compatable with version 2.7.2? according to the plugin site the version only goes up to Moodle 2.6?
      Table 'i850966_mood1.mdl_user' doesn't exist
      SELECT
      DISTINCT u.id,u.picture,u.firstname,u.lastname,u.firstnamephonetic,u.lastnamephonetic,u.middlename,u.alternatename,u.imagealt,u.email,u.username, concat(u.firstname, ' ',u.lastname) as fullname, r.points
      FROM
      mdl_user u
      INNER JOIN mdl_role_assignments a ON a.userid = u.id
      INNER JOIN mdl_ranking_points r ON r.userid = u.id
      INNER JOIN mdl_context c ON c.id = a.contextid
      WHERE a.contextid = ?
      AND a.userid = u.id
      AND a.roleid = ?
      AND c.instanceid = ?
      AND r.courseid = ?
      ORDER BY r.points DESC
      LIMIT 10
      [array (
      0 => 36,
      1 => 5,
      2 => '4',
      3 => '4',
      )]
      Error code: dmlreadexception
      Stack trace:

      line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 1014 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 71 of /blocks/ranking/lib.php: call to mysqli_native_moodle_database->get_records_sql()
      line 78 of /blocks/ranking/block_ranking.php: call to block_ranking_get_students()
      line 294 of /blocks/moodleblock.class.php: call to block_ranking->get_content()
      line 236 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()
      line 993 of /lib/blocklib.php: call to block_base->get_content_for_output()
      line 1045 of /lib/blocklib.php: call to block_manager->create_block_contents()
      line 361 of /lib/outputrenderers.php: call to block_manager->ensure_content_created()
      line 34 of /theme/essential/layout/includes/header.php: call to core_renderer->standard_head_html()
      line 27 of /theme/essential/layout/columns3.php: call to require_once()
      line 877 of /lib/outputrenderers.php: call to include()
      line 807 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
      line 243 of /course/view.php: call to core_renderer->header()

        Attachments

          Activity

            People

            Assignee:
            willianmano Willian Mano Araujo
            Reporter:
            HopeGames Fred Lewis
            Participants:
            Component watchers:
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: