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

Error when accessing logs after migrating databases because we store CONCAT SQL in the log_display table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 2.0, 2.3.1
    • None
    • Administration
    • MOODLE_20_STABLE, MOODLE_23_STABLE
    • Hide

      Manually update the log_display table, to change those rows where it is trying to display fullname, to use the appropriate SQL.

      Show
      Manually update the log_display table, to change those rows where it is trying to display fullname, to use the appropriate SQL.

    Description

      URL: http://<URL>/~user/ltu_moodle_git/course/user.php?user=2&id=1&mode=todaylogs

      Path: Home > My profile > Activity reports > Today's logs

      Error:

      ------------------------------------

      Displaying 13 records

      Error reading from database

      More information about this error
      Debug info: ERROR: function concat(character varying, unknown, character varying) does not exist
      LINE 1: SELECT CONCAT(firstname,' ',lastname) FROM mdl_user WHERE id...
      ^
      HINT: No function matches the given name and argument types. You might need to add explicit type casts.
      SELECT CONCAT(firstname,' ',lastname) FROM mdl_user WHERE id = $1
      [array (
      0 => '2',
      )]
      Stack trace:

      • line 380 of /lib/dml/moodle_database.php: dml_read_exception thrown
      • line 229 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
      • line 668 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
      • line 1218 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
      • line 1293 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
      • line 1272 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
      • line 1251 of /lib/dml/moodle_database.php: call to moodle_database->get_field_select()
      • line 386 of /course/lib.php: call to moodle_database->get_field()
      • line 178 of /course/user.php: call to print_log()

      Attachments

        Issue Links

          Activity

            People

              skodak Petr Skoda
              alandberg Anders Landberg
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: