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.
- has a non-specific relationship to
-
MDLQA-450 Register a site
- Passed