Mix and Match Products Debug Tools

What's This?

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:

System Status

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.

Use Existing Tools

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.

New Tools

This plugin adds several tools specific to Mix and Match.

1. 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)
2. 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.
3. Repair foreign keys - The Foreign Key constraints can get out of whack if the DB tables are manually modified (specifically wp_posts is renamed). This drops the Mix and Match specific foreign keys and re-installs them.

Warning

1. This is provided as is and is only meant for temporary use while debugging.