Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-52928

Repeating Error in Messaging / Recent Conversations area

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.9.3
    • Fix Version/s: 2.9.5, 3.0.3
    • Component/s: Messages
    • Labels:

      Description

      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()

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  14/Mar/16