Hello,
I have problem in Moodle 3.2 Toggle notifications menu, when i click on the notification icon the error message appear:
dmlreadexception
SQLState: 42000<br>Error Code: 195<br>Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]'concat' is not a recognized built-in function name.<br>SQLState: 42000<br>Error Code: 156<br>Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'AND'.<br>SQLState: 42000<br>Error Code: 195<br>Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]'concat' is not a recognized built-in function name.<br>SQLState: 42000<br>Error Code: 156<br>Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'AND'.<br>SELECT TOP 20 * FROM ( SELECT concat('r', r.id) as uniqueid, r.id, r.useridfrom, r.useridto, r.subject, r.fullmessage, r.fullmessageformat, r.fullmessagehtml, r.smallmessage, r.notification, r.contexturl, r.contexturlname, r.timecreated, r.timeuserfromdeleted, r.timeusertodeleted, r.component, r.eventtype, r.timeread FROM mdl_message_read r WHERE r.notification = 1 AND r.id IN (SELECT messageid FROM mdl_message_popup WHERE isread = 1) AND r.useridto = '2' UNION ALL SELECT concat('u', u.id) as uniqueid, u.id, u.useridfrom, u.useridto, u.subject, u.fullmessage, u.fullmessageformat, u.fullmessagehtml, u.smallmessage, u.notification, u.contexturl, u.contexturlname, u.timecreated, u.timeuserfromdeleted, u.timeusertodeleted, u.component, u.eventtype, 0 as timeread FROM mdl_message u WHERE u.notification = 1 AND u.id IN (SELECT messageid FROM mdl_message_popup WHERE isread = 0) AND u.useridto = '2' ) f ORDER BY timecreated DESC, timeread DESC, id DESC[array ( 0 => 2, 1 => 2,)]
Error code: dmlreadexception* line 474 of \lib\dml\moodle_database.php: dml_read_exception thrown* line 291 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()* line 398 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()* line 859 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()* line 907 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()* line 98 of \message\output\popup\classes\api.php: call to sqlsrv_native_moodle_database->get_records_sql()* line 111 of \message\output\popup\externallib.php: call to message_popup\api::get_popup_notifications()* line ? of unknownfile: call to message_popup_external::get_popup_notifications()* line 229 of \lib\externallib.php: call to call_user_func_array()* line 59 of \lib\ajax\service.php: call to external_api::call_external_function()
Best Regards,
