Moodle - CMMEdu
Debug info: ERROR: column c.shared does not exist
LINE 1: ...ory_contextid, c.sortorder AS category_sortorder, c.shared A...
^
HINT: Perhaps you meant to reference the column "c.area".
DECLARE crs3 NO SCROLL CURSOR WITH HOLD FOR SELECT f.*, c.name AS category_name, c.description AS category_description, c.descriptionformat AS category_descriptionformat, c.component AS category_component, c.area AS category_area, c.itemid AS category_itemid, c.contextid AS category_contextid, c.sortorder AS category_sortorder, c.shared AS category_shared, c.id AS category_id, c.timecreated AS category_timecreated
FROM mdl_customfield_category c
LEFT JOIN mdl_customfield_field f ON c.id = f.categoryid AND f.type IN ($1,$2,$3,$4,$5,$6)
WHERE c.component = $7 AND c.area = $8 AND c.itemid = $9
ORDER BY c.sortorder, f.sortorder
[array (
0 => 'checkbox',
1 => 'date',
2 => 'number',
3 => 'select',
4 => 'text',
5 => 'textarea',
6 => 'core_course',
7 => 'course',
8 => 0,
)]
Error code: dmlreadexception
LINE 1: ...ory_contextid, c.sortorder AS category_sortorder, c.shared A...
^
HINT: Perhaps you meant to reference the column "c.area".
DECLARE crs3 NO SCROLL CURSOR WITH HOLD FOR SELECT f.*, c.name AS category_name, c.description AS category_description, c.descriptionformat AS category_descriptionformat, c.component AS category_component, c.area AS category_area, c.itemid AS category_itemid, c.contextid AS category_contextid, c.sortorder AS category_sortorder, c.shared AS category_shared, c.id AS category_id, c.timecreated AS category_timecreated
FROM mdl_customfield_category c
LEFT JOIN mdl_customfield_field f ON c.id = f.categoryid AND f.type IN ($1,$2,$3,$4,$5,$6)
WHERE c.component = $7 AND c.area = $8 AND c.itemid = $9
ORDER BY c.sortorder, f.sortorder
[array (
0 => 'checkbox',
1 => 'date',
2 => 'number',
3 => 'select',
4 => 'text',
5 => 'textarea',
6 => 'core_course',
7 => 'course',
8 => 0,
)]
Error code: dmlreadexception
Stack trace:
- line 497 of /public/lib/dml/moodle_database.php: dml_read_exception thrown
- line 346 of /public/lib/dml/moodle_read_replica_trait.php: call to moodle_database->query_end()
- line 358 of /public/lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_replica_query_end()
- line 919 of /public/lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
- line 392 of /public/customfield/classes/api.php: call to pgsql_native_moodle_database->get_recordset_sql()
- line 534 of /public/customfield/classes/handler.php: call to core_customfield\api::get_categories_with_fields()
- line 858 of /public/customfield/classes/handler.php: call to core_customfield\handler->get_categories_with_fields()
- line 451 of /public/customfield/classes/handler.php: call to core_customfield\handler->get_fields()
- line 1100 of /public/course/classes/category.php: call to core_customfield\handler->get_instances_data()
- line 1895 of /public/course/classes/category.php: call to core_course_category::preload_custom_fields()
- line 1374 of /public/course/renderer.php: call to core_course_category->get_courses()
- line 1651 of /public/course/renderer.php: call to core_course_renderer->frontpage_available_courses()
- line 143 of /public/index.php: call to core_course_renderer->frontpage()