Can not find data record in database table assign_submission.

Can not find data record in database table assign_submission.

by Urs Giezendanner -
Number of replies: 1

Hi 

In all my assignments when I want to see the upoaded media, I get the following Error.

It does not matter if it's aconverted assignment from the 1.9 or in a new build assignment in 2.3.

Can not find data record in database table assign_submission.

Then:

Debug info: SELECT userid, assignment FROM {assign_submission} WHERE id = ?
[array (
0 => 0,
)]
Error code: invalidrecord

Stack trace:
  • line 1312 of /lib/dml/moodle_database.php: dml_missing_record_exception thrown
  • line 1288 of /lib/dml/moodle_database.php: call to moodle_database->get_record_select()
  • line 46 of /mod/assign/submission/file/lib.php: call to moodle_database->get_record()
  • line 4191 of /lib/filelib.php: call to assignsubmission_file_pluginfile()
  • line 38 of /pluginfile.php: call to file_pluginfile()
Output buffer: Warning: array_shift() expects parameter 1 to be array, integer given in /var/www/vhosts/ksm-lernt.ch/httpdocs/moodle/mod/assign/submission/file/lib.php on line 45

 

Average of ratings: -
In reply to Urs Giezendanner

Re: Can not find data record in database table assign_submission.

by David Richards -

If you upgraded your assignments to the version in Moodle 2.2 and 2.3, then the assignments are stored in a different table. It is called mdl_assign not assignment.