Dmlreadexception Error during Upgrade to 2.3.2+ (Build: 20121101)

Dmlreadexception Error during Upgrade to 2.3.2+ (Build: 20121101)

by Martin Teufel -
Number of replies: 3

We are running Moodle 2.3.1+ (Build: 20120719) on CentOS 5.8.

During the Moodle Upgrade Procedure we get the following dmlreadexception error:

 

mod_assignment

 

Fehler beim Lesen der Datenbank

Weitere Informationen über diesen Fehler

Debug info: Table 'moodle2.mdl_files_reference' doesn't exist
SELECT f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license, f.timecreated, f.timemodified, f.sortorder, f.referencefileid, r.repositoryid AS repositoryid, r.reference AS reference, r.lastsync AS referencelastsync, r.lifetime AS referencelifetime
FROM mdl_files f
LEFT JOIN mdl_files_reference r
ON f.referencefileid = r.id
WHERE f.contextid = ?
AND f.component = ?
AND f.filearea = ?
AND f.itemid = ? ORDER BY sortorder
[array (
0 => '915',
1 => 'mod_assignment',
2 => 'submission',
3 => '10',
)]
Error code: dmlreadexception

Stack trace:

  • line 407 of /lib/dml/moodle_database.php: dml_read_exception thrown
  • line 966 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 425 of /lib/filestorage/file_storage.php: call to mysqli_native_moodle_database->get_records_sql()
  • line 61 of /mod/assignment/db/upgrade.php: call to file_storage->get_area_files()
  • line 627 of /lib/upgradelib.php: call to xmldb_assignment_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()

Any suggestions on how to fix that?

 

Kind Regards

Martin

Average of ratings: -
In reply to Martin Teufel

Re: Dmlreadexception Error during Upgrade to 2.3.2+ (Build: 20121101)

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Upgrade from what?
In reply to Howard Miller

Re: Dmlreadexception Error during Upgrade to 2.3.2+ (Build: 20121101)

by Martin Teufel -

Upgrade from: Moodle 2.3.1+ (Build: 20120719)

In reply to Martin Teufel

Re: Dmlreadexception Error during Upgrade to 2.3.2+ (Build: 20121101)

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Ahh, sorry. I see what you mean now.


Can you check your database for mdl_files_reference table. It was added at version 2012052100.00 so you should have it in your Moodle prior to the upgrade. If you don't something must have gone wrong previously. Was your Moodle working ok before this?