search

lsuonline / lsuce-block_quickmail

5 stars 32 forks source link

column "block_quickmail_schedules->usermodified" cannot be modified #56

Open haietza opened 1 year ago

haietza commented 1 year ago

Receive the following error when trying to update Moodle 4.0 plugin version 2019012401 to 2021120300:

column "block_quickmail_schedules->usermodified" cannot be modified. Dependency found with index "mdl_blocquicsche_use_ix (usermodified)"

Error code: ddldependencyerror Stack trace:

line 734 of /lib/ddl/database_manager.php: ddl_dependency_exception thrown
line 654 of /lib/ddl/database_manager.php: call to database_manager->check_field_dependencies()
line 998 of /blocks/quickmail/db/upgrade.php: call to database_manager->change_field_default()
line 1082 of /lib/upgradelib.php: call to xmldb_block_quickmail_upgrade()
line 584 of /lib/upgradelib.php: call to upgrade_plugins_blocks()
line 1935 of /lib/upgradelib.php: call to upgrade_plugins()
line 719 of /admin/index.php: call to upgrade_noncore()

Please advise. Thanks!

haietza commented 1 year ago

Any update on this? We're unable to update the plugin until the error is resolved. Thanks!

haietza commented 1 year ago

We are still unable to update the plugin due to this error. Please update on status. Thank you.

qqtuyen commented 1 year ago

This might be a work around.
You could backing up the mdl_block_quickmail_schedules table. then drop the index. Since it is only an index of that table. This work for us.

drop index mdl_blocquicsche_use_ix on mdl_block_quickmail_schedules;