-
Bug
-
Resolution: Fixed
-
Minor
-
None
-
2.3.6
-
None
-
MOODLE_23_STABLE
A created "Group choice" can't be opened. Moodle throws a database exception.
Maybe there are differences in syntax for mySQL and PostgreSQL?
(the first line translates to: invalid input syntax for integer:")
"Debug info: FEHLER: ungültige Eingabesyntax für ganze Zahl: »378, 379, 380«
SELECT * FROM mdl_groups_members WHERE userid = $1 AND groupid IN ($2)
[array (
0 => '3227',
1 => '378, 379, 380',
)]
Error code: dmlreadexception
Stack trace:
line 407 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 708 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 1360 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
line 112 of /mod/choicegroup/lib.php: call to moodle_database->get_record_sql()
line 720 of /mod/choicegroup/lib.php: call to choicegroup_get_user_answer()
line 784 of /mod/choicegroup/lib.php: call to choicegroup_get_response_data()
line 3934 of /lib/navigationlib.php: call to choicegroup_extend_settings_navigation()
line 3312 of /lib/navigationlib.php: call to settings_navigation->load_module_settings()
line 716 of /lib/pagelib.php: call to settings_navigation->initialise()
line 732 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()
line 133 of /blocks/settings/block_settings.php: call to moodle_page->__get()
line 281 of /blocks/moodleblock.class.php: call to block_settings->get_content()
line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()
line 937 of /lib/blocklib.php: call to block_base->get_content_for_output()
line 989 of /lib/blocklib.php: call to block_manager->create_block_contents()
line 352 of /lib/blocklib.php: call to block_manager->ensure_content_created()
line 6 of /theme/buwmoodle2/layout/general.php: call to block_manager->region_has_content()
line 771 of /lib/outputrenderers.php: call to include()
line 718 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
line 2225 of /lib/outputrenderers.php: call to core_renderer->header()
line ? of unknownfile: call to core_renderer->fatal_error()
line 1484 of /lib/setuplib.php: call to call_user_func_array()
line 375 of /lib/setuplib.php: call to bootstrap_renderer->__call()
line 375 of /lib/setuplib.php: call to bootstrap_renderer->fatal_error()
line ? of unknownfile: call to default_exception_handler()"
When I do the database call manually in this way, it works: SELECT * FROM mdl_groups_members WHERE userid = 2 AND groupid in (378, 379, 380)