I'm receiving an error message when attempting to upgrade to Certificate 2.3.
My environment is:
Moodle 2.3.1-latest, Windows Server 2008, IIS, MSSQL 2008, PHP 5.3.15
Here is the error text (screen grab also attached):
mod_certificate
Error writing to database
Error Code: 8155<br>
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]No column name was specified for column 1 of 't'.<br>
DELETE
FROM mdl_certificate_issues
WHERE id NOT IN (SELECT * FROM (SELECT MAX(id)
FROM mdl_certificate_issues
GROUP BY certificateid, userid) as t)
[array (
)]
Error code: dmlwriteexception
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]No column name was specified for column 1 of 't'.<br>
DELETE
FROM mdl_certificate_issues
WHERE id NOT IN (SELECT * FROM (SELECT MAX(id)
FROM mdl_certificate_issues
GROUP BY certificateid, userid) as t)
[array (
)]
Error code: dmlwriteexception
Stack trace:
- line 410 of \lib\dml\moodle_database.php: dml_write_exception thrown
- line 258 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
- line 365 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
- line 740 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
- line 374 of \mod\certificate\db\upgrade.php: call to sqlsrv_native_moodle_database->execute()
- line 627 of \lib\upgradelib.php: call to xmldb_certificate_upgrade()
- line 358 of \lib\upgradelib.php: call to upgrade_plugins_modules()
- line 1524 of \lib\upgradelib.php: call to upgrade_plugins()
- line 329 of \admin\index.php: call to upgrade_noncore()
