Using Moodle 2.9.2 with Microsoft Sql Server 2014 as backend
Installed Learning plan plugin. Version details below:
$plugin->version = 2017032102; // The current plugin version (Date: YYYYMMDDXX).
$plugin->requires = 2010112400; // Requires Moodle 2.1 or later.
$plugin->release = '3.2';
$plugin->maturity = MATURITY_STABLE;
$plugin->component = 'block_learning_plan';
Not able to assign learning plan to users. The following error is thrown:
Debug info: SQLState: 42S22<br>
Error Code: 207<br>
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'guest'.<br>
SQLState: 42S22<br>
Error Code: 207<br>
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name ' '.<br>
SELECT id, CONCAT(firstname," ", lastname)FROM mdl_user where username!="guest"
[array (
)]
Error code: dmlreadexception
Error Code: 207<br>
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'guest'.<br>
SQLState: 42S22<br>
Error Code: 207<br>
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name ' '.<br>
SELECT id, CONCAT(firstname," ", lastname)FROM mdl_user where username!="guest"
[array (
)]
Error code: dmlreadexception
Stack trace:
- line 443 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 850 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
- line 898 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
- line 1402 of \lib\dml\moodle_database.php: call to sqlsrv_native_moodle_database->get_records_sql()
- line 349 of \blocks\learning_plan\learning_plan_form.php: call to moodle_database->get_records_sql_menu()
- line 196 of \lib\formslib.php: call to assignlerningplan_user_form->definition()
- line 199 of \blocks\learning_plan\view.php: call to moodleform->moodleform()
Request your help to have this issue resolved. Appreciate your help in this regard. Thanks in advance