Experimental plugin that adds some Tools for dealing with failed update routines. Specicially, we confirm an update routine is required when saving fails with the following error:
This plugin will add a JSON representation of the admin Note that is saved in the database in the Mix and Match section of the WooCommerce > Status system status.
Note! If for some reason is_deleted is 1 or otherwise truthy the Note will not display, which prevents users from running the update routine required to get saving functioning again.
Before using the tools enabled by this plugin, you should try deleting the existing Note by navigating to WooCommerce > Status > Tools and locating the "Delete an Inbox Notification" tool. You can search for mnm to locate the wc-mnm-update-db-reminder note and then once it is selected, click the Delete button.
Mix and Match should now re-spawn the update prompt and hopefully you can proceed by clicking on the update prompt's "Update Database" button.
This plugin adds several tools specific to Mix and Match.
- Reset the Mix and Match DB version to 2.0 - This was the old way to force the update prompt to re-appear, but it's a hard-reset to 2.0 which might not be appropriate if you still need the 2.0-specific routines (of which there were some major ones)
- Force run the Mix and Match update routines - Any available updates are added to the Action Scheduler. For example if the DB version is 1.9.x then all 2.0 and 2.2 updates will be scheduled for immedate execution.
- Repair foreign keys - The Foreign Key constraints can get out of whack if the DB tables are manually modified (specifically
wp_postsis renamed). This drops the Mix and Match specific foreign keys and re-installs them.
Warning
- This is provided as is and is only meant for temporary use while debugging.