WCML
woocommerce-multilingual/inc/class-wcml-upgrade.php line 726
```
$wpdb->query( "DELETE FROM {$wpdb->prefix}woocommerce_bundled_itemmeta WHERE `meta_id` IN (" . DB::prepareIn( $not_existing_items ) . ')' );
```
We get a notice from this when the IN statement is empty:
>WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 for query DELETE FROM foowoocommerce_bundled_itemmeta WHERE `meta_id` IN ()
This is a bug in WCML.
The fix is to not run this query if `$not_existing_items` is empty
This is a simple fix that should get shipped with the next release please
Hope you had this bug while upgrading WooCommerce Multilingual & Multicurrency to the 5.3.4 version from 5.3.3.1. Please check it and let us know your feedback.
--
Thanks!
Bigul
The topic ‘[Closed] Database error when upgrading WCML’ is closed to new replies.