Database error when upgrading WCML

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.

Our next available supporter will start replying to tickets in about 7.14 hours from now. Thank you for your understanding.

This topic contains 1 reply, has 2 voices.

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+02: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.