I have discovered that in one of our installations there is a lot of course modules with idnumber=NULL in the mysql database. I think the error occurred after we updated to ver. 1.9.10 back in October, while I am able to restore course backups from the 1.9.9 version. Is there anything I can do to solve this/would it help to update again?
When I try to restore I get the debug message:
* line 1664 of lib/deprecatedlib.php: call to debugging()
* line 69 of backup/restore_execute.html: call to error()
* line 174 of backup/restore.php: call to include_once()"
When I make the query
WHERE `idnumber` IS NULL"
"MySQL returned an empty result set (i.e. zero rows)."
Besides at the search result page there is a warning:
"The indexes PRIMARY and id seem to be equal and one of them could possibly be removed."