WooCommerce 7.2.1 was released yesterday on December 20, 2022. On the 21st it was rolled back and necessitated a 7.2.2 fix release which also is available since the 21st.
The details
- The WooCommerce 7.1.0 release updated the states for New Zealand to the CLDR standard. This introduced a bug as the database records did not get updated.
- WooCommerce 7.2.1 fixed the issue with the New Zealand states by creating a database migration helper to convert the NZ states to the new standard. Additionally, it included the state update and migration for Ukraine.
- The fix implemented in 7.2.1 inadvertently included a hard-coded table prefix for the migration. For sites with custom database prefixes (anything other than
wp_), the update routine caused error messages to be logged which subsequently rescheduled the routine, filling the debug logs rapidly. - After realizing the severity of the issue, we began the work to release 7.2.2 and rolled back the 7.2.1 release entirely.
- How can I tell if this affects me?
- You will be able to quickly see if you are experiencing an issue by checking your log files. The bug produces the following error message:
WordPress database error Unknown column ‘wp_postmeta.post_id’ in ‘where clause’ for query...
How can I tell if this affects me?
You will be able to quickly see if you are experiencing an issue by checking your log files. The bug produces the following error message: WordPress database error Unknown column ‘wp_postmeta.post_id’ in ‘where clause’ for query...
When upgrading to 7.2.2 you will be prompted to update the Woo database. You will need to perform this step to ensure that you get fixes for NZ and Ukranian states/regions.
You can download the latest release of WooCommerce here or visit Dashboard → Updates to update the plugin from your WordPress admin screen.
As usual, if you spot issues in WooCommerce core, please log them in detail on GitHub. Found a security issue? Please submit a report via HackerOne.
