Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 2.1.5, 2.2.2, 2.3
-
Component/s: Messages
-
Database:Any
-
Testing Instructions:
-
Affected Branches:MOODLE_21_STABLE, MOODLE_22_STABLE, MOODLE_23_STABLE
-
Fixed Branches:MOODLE_21_STABLE, MOODLE_22_STABLE
-
Pull Master Branch:
MDL-31869_message_search_roles -
Pull Master Diff URL:
Description
If you search for user x and they have multiple roles like student and teacher you will get this error relating to their user id a duplicate in the returning SQL.
Did you remember to make the first column something unique in your call to get_records? Duplicate value '4' found in column 'id'.
line 705 of /lib/dml/pgsql_native_moodle_database.php: call to debugging()
line 1515 of /message/lib.php: call to pgsql_native_moodle_database->get_records_sql()
line 1034 of /message/lib.php: call to message_search_users()
line 653 of /message/lib.php: call to message_print_search_results()
line 300 of /message/index.php: call to message_print_search()