-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
3.11.13, 4.0.6, 4.1.1
-
MOODLE_311_STABLE, MOODLE_400_STABLE, MOODLE_401_STABLE
Background: I just update my moodle version to the last available branch MOODLE_401_STABLE
$version = 2022112801.06;
$release = '4.1.1+ (Build: 20230224)';
$branch = '401';
In my config.php I have:
$CFG->debug = E_ALL | E_STRICT;
$CFG->debugdisplay = true;
define('MDL_PERFDB', true);
$CFG->debugpageinfo = true;
Yes, I am using the last weekly release but I am quite sure this issue is older.
Issue description
Log in as admin
Create a course
Enrol some student to this new course
Manually create 3 groups with few students in the just created course
Add a chat to the course
Set the "Common module settings -> Group mode" of the borning chat to "Separate groups"
Save and display
Choose from the "Separate groups" drop down menu "All partecipants" (already selected)
Step1:
Push the "Use more accessible interface"
A pop up window will open and all seems to be fine
Step2:
Choose from the "Separate groups" drop down menu the first group you have in list
Push again the "Use more accessible interface"
A pop up window will open with the following error message:
Did you remember to make the first column something unique in your call to get_records? Duplicate value '2' found in column 'id'. |
line 1287 of /lib/dml/mysqli_native_moodle_database.php: call to debugging() |
line 530 of /mod/chat/lib.php: call to mysqli_native_moodle_database->get_records_sql() |
line 85 of /mod/chat/gui_basic/index.php: call to chat_get_users() |
Step3:
Choose again from the "Separate groups" drop down menu "All partecipants"
In the main window I get:
Did you remember to make the first column something unique in your call to get_records? Duplicate value '2' found in column 'id'. |
line 1287 of /lib/dml/mysqli_native_moodle_database.php: call to debugging() |
line 530 of /mod/chat/lib.php: call to mysqli_native_moodle_database->get_records_sql() |
line 1310 of /mod/chat/lib.php: call to chat_get_users() |
line 2427 of /lib/navigationlib.php: call to chat_extend_navigation() |
line 1584 of /lib/navigationlib.php: call to global_navigation->load_activity() |
line 4295 of /lib/navigationlib.php: call to global_navigation->initialise() |
line 832 of /lib/pagelib.php: call to settings_navigation->__construct() |
line 962 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav() |
line 225 of /lib/classes/navigation/views/secondary.php: call to moodle_page->__get() |
line 890 of /lib/pagelib.php: call to core\navigation\views\secondary->initialise() |
line 962 of /lib/pagelib.php: call to moodle_page->magic_get_secondarynav() |
line 70 of /theme/boost/layout/drawers.php: call to moodle_page->__get() |
line 1477 of /lib/outputrenderers.php: call to include() |
line 1403 of /lib/outputrenderers.php: call to core_renderer->render_page_layout() |
line 1973 of /lib/setuplib.php: call to core_renderer->header() |
line 102 of /mod/chat/view.php: call to bootstrap_renderer->__call() |
at the beginning of the page and
Did you remember to make the first column something unique in your call to get_records? Duplicate value '2' found in column 'id'. |
line 1287 of /lib/dml/mysqli_native_moodle_database.php: call to debugging() |
line 530 of /mod/chat/lib.php: call to mysqli_native_moodle_database->get_records_sql() |
line 160 of /mod/chat/view.php: call to chat_get_users() |
just after the "Separate groups" drop down menu.