-
Bug
-
Resolution: Fixed
-
Minor
-
2.9.3
-
MOODLE_29_STABLE
-
MOODLE_29_STABLE, MOODLE_30_STABLE
-
MDL-52928-master -
- Add a number of contacts
- Send a message to your own user (you may have to fudge this because it's not part of the UI)
- View your list of recent conversations (with debugdeveloper enabled)
1-28-16
Getting what appears to be a repeating error(s) in messaging area, in recent conversations.
Below these errors it shows some older messages starting at 1-16-16. Our site is not live yet but has been in development since early last summer. It has debugging turned on, and messaging turned on but rarely used so far. M v2.9.3 on a shared server. Using "More" theme, no changes made to core moodle or theme. No other known issues related. No related plugins, and no plugins have been updated from the list I attached. Files attached: screenshot and plugin list. Let me know if you need additional info.
Here is the error message(s) that display at the top in: Messages / Recent Conversations:
Did you remember to make the first column something unique in your call to get_records? Duplicate value '3-3' found in column 'concat(message.useridfrom, '-', message.useridto)'.
line 1089 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
line 769 of /message/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 848 of /message/lib.php: call to message_get_recent_conversations()
line 341 of /message/index.php: call to message_print_recent_conversations()
Did you remember to make the first column something unique in your call to get_records? Duplicate value '3-3' found in column 'concat(message.useridfrom, '-', message.useridto)'.
line 1089 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
line 769 of /message/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 848 of /message/lib.php: call to message_get_recent_conversations()
line 341 of /message/index.php: call to message_print_recent_conversations()
Did you remember to make the first column something unique in your call to get_records? Duplicate value '3-3' found in column 'concat(message.useridfrom, '-', message.useridto)'.
line 1089 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
line 769 of /message/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 848 of /message/lib.php: call to message_get_recent_conversations()
line 341 of /message/index.php: call to message_print_recent_conversations()
Did you remember to make the first column something unique in your call to get_records? Duplicate value '3-3' found in column 'concat(message.useridfrom, '-', message.useridto)'.
line 1089 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
line 769 of /message/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 848 of /message/lib.php: call to message_get_recent_conversations()
line 341 of /message/index.php: call to message_print_recent_conversations()
Did you remember to make the first column something unique in your call to get_records? Duplicate value '3-3' found in column 'concat(message.useridfrom, '-', message.useridto)'.
line 1089 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
line 769 of /message/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 848 of /message/lib.php: call to message_get_recent_conversations()
line 341 of /message/index.php: call to message_print_recent_conversations()
Did you remember to make the first column something unique in your call to get_records? Duplicate value '3-3' found in column 'concat(message.useridfrom, '-', message.useridto)'.
line 1089 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
line 769 of /message/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 848 of /message/lib.php: call to message_get_recent_conversations()
line 341 of /message/index.php: call to message_print_recent_conversations()
Did you remember to make the first column something unique in your call to get_records? Duplicate value '3-3' found in column 'concat(message.useridfrom, '-', message.useridto)'.
line 1089 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
line 769 of /message/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 848 of /message/lib.php: call to message_get_recent_conversations()
line 341 of /message/index.php: call to message_print_recent_conversations()
Did you remember to make the first column something unique in your call to get_records? Duplicate value '3-3' found in column 'concat(message.useridfrom, '-', message.useridto)'.
line 1089 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
line 769 of /message/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 848 of /message/lib.php: call to message_get_recent_conversations()
line 341 of /message/index.php: call to message_print_recent_conversations()
Did you remember to make the first column something unique in your call to get_records? Duplicate value '3-3' found in column 'concat(message.useridfrom, '-', message.useridto)'.
line 1089 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
line 769 of /message/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 848 of /message/lib.php: call to message_get_recent_conversations()
line 341 of /message/index.php: call to message_print_recent_conversations()
Did you remember to make the first column something unique in your call to get_records? Duplicate value '3-3' found in column 'concat(message.useridfrom, '-', message.useridto)'.
line 1089 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
line 769 of /message/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 848 of /message/lib.php: call to message_get_recent_conversations()
line 341 of /message/index.php: call to message_print_recent_conversations()
- has a non-specific relationship to
-
MDL-48108 Slow messages query
- Closed