I'm trying to upgrade 37 old assignments (2.2) to the new assignment version. I've already upgraded about 100 of them without an issue. However, when I select upgrade all 37 assignments at once I get the "Multiple records found, only one record expected." error message (debug message below) . If I select a few assignments to upgrade I get the same message. Does anyone know why I can't upgrade these last 37 assignments? I really need to disable the old assignment 2.2 module so teachers will stop using it. If I disable it now, their current 2.2 assignments will disappear. Any help would be greatly appreciated.
Moodle 2.5.3+, Debian 7, PHP 5.4.4, MySQL 5.5.31
I'm looking at/admin/tool/assignmentupgrade/batchupgrade.php
From what it looks like the issue is that you have duplicates for assignment ID's in the 'mdl_assignment' table. I think when the "tool_assignmentupgrade_get_assignment" function runs it finds multiple records for one of the ids.
Yeah, you're right but how do I fix this. Why would I have duplicate IDs? Do I get duplicate IDs when teachers duplicate an assignment on the same course?