Skip to content

Error reading from database when trying to duplicate an assignment in Moodle 3.1 #23

@sscott1

Description

@sscott1

Hi,

I'm hoping someone could help me.

Any feedback is appreciated.

I have been having an issue duplicating items/assignments within a course in Moodle 3.1.9. When clicking duplicate item I receive an error message stating 'error reading from database' from what I can tell it seems related to the tables that support the tab display activity module.

This issue surfaced after upgrading from 2.7 to 3.1

I have reported the issue in Moodle tracker and Moodle discussion group to no avail.

Here is some of the debug information:

Debug info: Unknown column 't.intro' in 'field list' SELECT
t.id, t.intro FROM mdl_tab t JOIN mdl_backup_ids_temp b
ON b.newitemid = t.id WHERE b.backupid = ? AND
b.itemname = ? [array ( 0 =>
'5a5cd0fe64125f724465d3537cbbe3cf', 1 => 'tab', )] Error
code: dmlreadexception
Stack trace:

line 479 of /lib/dml/moodle_database.php: dml_read_exception thrown

line 1114 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 103 of /backup/util/helper/restore_decode_content.class.php: call to mysqli_native_moodle_database->get_recordset_sql()
line 72 of /backup/util/helper/restore_decode_content.class.php: call to restore_decode_content->get_iterator()
line 81 of /backup/util/helper/restore_decode_processor.class.php: call to restore_decode_content->process()
line 775 of /backup/moodle2/restore_stepslib.php: call to restore_decode_processor->execute()
line 34 of /backup/util/plan/restore_execution_step.class.php: call to restore_decode_interlinks->define_execution()
line 181 of /backup/util/plan/base_task.class.php: call to restore_execution_step->execute()
line 177 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
line 167 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()
line 335 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()
line 3698 of /course/lib.php: call to restore_controller->execute_plan()
line 3625 of /course/lib.php: call to duplicate_module()
line 118 of /course/rest.php: call to mod_duplicate_activity()

Thank you for any help you can provide.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions