Skip Navigation

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 1 reply, has 2 voices.

Last updated by Bigul 10 months ago.

Author Posts
February 20, 2024 at 8:11 am #15320845

desireeM

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

February 20, 2024 at 12:23 pm #15322605

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

Welcome to the WPML support forum. We will do our best to help you to resolve this issue.

To help you faster, I've enabled debug information for this support ticket. Please see this link for how to get this information from your site and give it to us: http://wpml.org/faq/provide-debug-information-faster-support/

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.