ERROR: column "show_all_courses" does not exist

[caiadogithub]

Moodle 3.11.7 PostgreSQL 12 PHP 7.4 Ubuntu 20.04

Plugin v3.11-r2 (2022081800)

---

ERROR: column "show_all_courses" does not exist LINE 1: ...o, introformat, displaytype, links, timemodified, show_all_c... ^ SELECT id, course, name, intro, introformat, displaytype, links, timemodified, show_all_courses, opentype, cards_by_line FROM mdl_courselinks WHERE id = $1 [array ( 0 => '2', )] Error code: dmlreadexception

line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 291 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
line 338 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_slave_query_end()
line 1017 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 1671 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
line 1643 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
line 1622 of /lib/dml/moodle_database.php: call to moodle_database->get_record_select()
line 129 of /mod/courselinks/lib.php: call to moodle_database->get_record()
line 884 of /lib/modinfolib.php: call to courselinks_get_coursemodule_info()
line 709 of /lib/modinfolib.php: call to course_modinfo::get_array_of_activities()
line 486 of /lib/modinfolib.php: call to course_modinfo::inner_build_course_cache()
line 441 of /lib/modinfolib.php: call to course_modinfo->__construct()
line 2549 of /lib/modinfolib.php: call to course_modinfo::instance()
line 138 of /competency/classes/api.php: call to get_fast_modinfo()
line 1028 of /competency/classes/api.php: call to core_competency\api::validate_course_module()
line 205 of /admin/tool/lp/lib.php: call to core_competency\api::list_course_module_competencies_in_course_module()
line 202 of /course/modlib.php: call to tool_lp_coursemodule_edit_post_actions()
line 391 of /course/modlib.php: call to plugin_extend_coursemodule_edit_post_actions()
line 184 of /course/modlib.php: call to edit_module_post_actions()
line 170 of /course/modedit.php: call to add_moduleinfo()

[andurif]

Hello @caiadogithub ,

Thanks for your comment. Indeed there was a mistake in the v3.11-r2 plugin release. I forgot to report new database fields in the install.xml file. There was no error if you updated the plugin but there is one if you installed the plugin for the first time. This is fixed in the last release.

Feel free to tell us if you still have problems or do other suggestion.

Cheers. Anthony

[caiadogithub]