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

Errors on community hub after registering first server

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 2.0
    • 2.0
    • Hub
    • None
    • PostgreSQL
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE

      I am running a local moodle 2.0 server and 2.0 hub server. I just registered the moodle site with the hub and now get the folowing error on the home page.

      Debug info: ERROR: syntax error at or near "ratingaverage"
      LINE 2: ... SELECT itemid, AVG(rating) ratingaver...
      ^
      SELECT c.* , r.ratingaverage, r.ratingcount FROM vle_20101224_sr2_mdl_hub_course_directory c LEFT JOIN (
      SELECT itemid, AVG(rating) ratingaverage, COUNT(id) ratingcount
      FROM vle_20101224_sr2_mdl_rating GROUP BY itemid
      ) r ON r.itemid = c.id WHERE privacy = $1 AND enrollable = 1 AND deleted = 0 ORDER BY timemodified DESC LIMIT 10 OFFSET 0
      [array (
      0 => 1,
      )]
      Stack trace:
      line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 229 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
      line 669 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
      line 562 of /local/hub/lib.php: call to pgsql_native_moodle_database->get_records_sql()
      line 1550 of /local/hub/lib.php: call to local_hub->get_courses()
      line 74 of /index.php: call to local_hub->display_homepage()

      I also get the following error in admin > hub > manage courses

      Error reading from database

      More information about this error

      Debug info: ERROR: syntax error at or near "ratingaverage"
      LINE 2: ... SELECT itemid, AVG(rating) ratingaver...
      ^
      SELECT c.* , r.ratingaverage, r.ratingcount FROM vle_20101224_sr2_mdl_hub_course_directory c LEFT JOIN (
      SELECT itemid, AVG(rating) ratingaverage, COUNT(id) ratingcount
      FROM vle_20101224_sr2_mdl_rating GROUP BY itemid
      ) r ON r.itemid = c.id WHERE privacy = $1 AND timemodified > $2 AND deleted = 0 ORDER BY timemodified DESC LIMIT 10 OFFSET 0
      [array (
      0 => 0,
      1 => 1286810092,
      )]
      Stack trace:
      line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 229 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
      line 669 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
      line 562 of /local/hub/lib.php: call to pgsql_native_moodle_database->get_records_sql()
      line 188 of /local/hub/admin/managecourses.php: call to local_hub->get_courses()

      and the following is from admin > hub > manage sites
      Debug info: ERROR: invalid input syntax for integer: ""
      SELECT * FROM vle_20101224_sr2_mdl_hub_site_directory WHERE id = $1
      [array (
      0 => '',
      )]
      Stack trace:
      line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 229 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
      line 669 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
      line 1243 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
      line 1215 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
      line 1195 of /lib/dml/moodle_database.php: call to moodle_database->get_record_select()
      line 169 of /local/hub/lib.php: call to moodle_database->get_record()
      line 110 of /local/hub/admin/managesites.php: call to local_hub->get_site()

      I'm running the latest head install of moodle 2.0. set up the hubg according to http://docs.moodle.org/en/Hub_administration. I didn't set up smtp becuase I don't have a server available.

      This is the only server registered with the hub.

            jerome Jérôme Mouneyrac
            colchambers Colin Chambers (Inactive)
            Nobody Nobody (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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