vfremaux / moodle-availability_coursetime Goto Github PK

$plugin->dependencies = array('block_use_stats' => '*');

Error reading from database

More information about this error

Debug info: ERROR: column "ue.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 3: ue.id,
^

SELECT
ue.id,
MIN(timestart) as timestart
FROM
mdl_enrol e,
mdl_user_enrolments ue
WHERE

e.id = ue.enrolid AND
(ue.timeend = 0 OR ue.timeend > 1475234392)
AND userid = 2 

[array (
)]
Error code: dmlreadexception
Stack trace:
line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 785 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 1480 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
line 120 of /blocks/use_stats/locallib.php: call to moodle_database->get_record_sql()
line 83 of /availability/condition/coursetime/classes/condition.php: call to use_stats_extract_logs()
line 84 of /availability/classes/condition.php: call to availability_coursetime\condition->is_available()
line 265 of /availability/classes/tree.php: call to core_availability\condition->check_available()
line 197 of /availability/classes/info.php: call to core_availability\tree->check_available()
line 2647 of /lib/modinfolib.php: call to core_availability\info->is_available()
line 2610 of /lib/modinfolib.php: call to section_info->get_available()
line 1809 of /lib/modinfolib.php: call to section_info->__get()
line 1290 of /lib/modinfolib.php: call to cm_info->obtain_dynamic_data()
line 1162 of /lib/modinfolib.php: call to cm_info->get_name()
line 1885 of /lib/navigationlib.php: call to cm_info->__get()
line 1924 of /lib/navigationlib.php: call to global_navigation->generate_sections_and_activities()
line 465 of /course/format/lib.php: call to global_navigation->load_generic_course_sections()
line 165 of /course/format/topics/lib.php: call to format_base->extend_course_navigation()
line 1839 of /lib/navigationlib.php: call to format_topics->extend_course_navigation()
line 1204 of /lib/navigationlib.php: call to global_navigation->load_course_sections()
line 3425 of /lib/navigationlib.php: call to global_navigation->initialise()
line 718 of /lib/pagelib.php: call to settings_navigation->__construct()
line 768 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()
line 84 of /course/renderer.php: call to moodle_page->__get()
line 61 of /course/renderer.php: call to core_course_renderer->add_modchoosertoggle()
line 415 of /lib/outputfactories.php: call to core_course_renderer->__construct()
line 1833 of /lib/outputlib.php: call to theme_overridden_renderer_factory->get_renderer()
line 812 of /lib/pagelib.php: call to theme_config->get_renderer()
line 52 of /course/format/renderer.php: call to moodle_page->get_renderer()
line 45 of /course/format/topics/renderer.php: call to format_section_renderer_base->__construct()
line 415 of /lib/outputfactories.php: call to format_topics_renderer->__construct()
line 1833 of /lib/outputlib.php: call to theme_overridden_renderer_factory->get_renderer()
line 812 of /lib/pagelib.php: call to theme_config->get_renderer()
line 134 of /course/view.php: call to moodle_page->get_renderer()