Open logan-reynolds opened 3 years ago
Thank you @logan-reynolds for reporting this. Do you happen to know what database backend you use in your installation (mysql? postgres?).
I know we have warnings about SQL statements which may not be cross-db compatible, so we should be aware of this when we reproduce the error.
I get the same error on our installation (Moodle 3.9 and postgresql 10.16.
When I attempt to delete the course the CAPQuiz activity disappears but the course becomes undeletable. My guess is that CAPQuiz deletes its activity prematurely, and when the core function tries to do it later, it fails.
Thank you @logan-reynolds for reporting this. Do you happen to know what database backend you use in your installation (mysql? postgres?).
I know we have warnings about SQL statements which may not be cross-db compatible, so we should be aware of this when we reproduce the error.
Hello hgeorgsch, I've got the same bug on Moodle 3.11.4 with MySQL 5.7.
I can still confirm this bug on Moodle 4.1 with MariaDB 10.6 and CAPQuiz 0.7.0.
Describe the bug When trying to delete a course containing an instance of the mod_capquiz activity module version 2021021100 release 0.6.0 on Moodle 3.9, course deletion fails with an error message, leaving an empty course that cannot be deleted unless the plugin is completely uninstalled.
To Reproduce Steps to reproduce the behavior:
Expected behavior The course should be deleted without encountering any error.
Additional context Error message encountered on the course deletion processing screen is the following:
Noting I also get the following error when deleting the activity instance indicating the subplugins file needs to be migrated to the newer format and filename, although this is unrelated to the primary course deletion problem :