Background of the issue:
I am using WooCommerce with WPML, WooCommerce Multilingual & Multicurrency( Multicurrency enabled), Marketplace for WooCommerce (by webkul), and WooCommerce Marketplace Membership (by webkul). A vendor tries to purchase a membership product that has a custom price set for it ('Set prices in other currencies manually') for ILS, using the ILS currency (not any other currency). The membership plugin is supposed to create a subscription with Stripe. Link to a page where the issue can be seen: hidden link
A Vendor user need to log in, choose a paid membership, add it to the cart and continue with checkout with ILS currency. This bug does not happen with other currencies, only with ILS (which is the only one that has a custom price set).
Symptoms:
The subscription with Stripe was not created because an error thrown by the WCML (multicurrency) interrupted the natural flow of the WooCommerce order. The error message is:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3 for query SELECT post_id, meta_key, meta_value FROM wp_postmeta
WHERE meta_key IN ('_price', '_regular_price', '_sale_price', '_price_ILS', '_regular_price_ILS', '_sale_price_ILS')
AND post_id IN () made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action('wc_ajax_checkout'), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::checkout, WC_Checkout->process_checkout, WC_Checkout->process_order_payment, WC_Stripe_UPE_Payment_Gateway->process_payment, WC_Stripe_UPE_Payment_Gateway->process_payment_with_deferred_intent, WC_Stripe_UPE_Payment_Gateway->process_payment_with_payment_method, WC_Stripe_Payment_Gateway->process_response, WC_Order->payment_complete, WC_Order->save, WC_Order->status_transition, do_action('woocommerce_order_status_processing'), WP_Hook->do_action, WP_Hook->apply_filters, wc_update_total_sales_counts, do_action('woocommerce_recorded_sales'), WP_Hook->do_action, WP_Hook->apply_filters, WCML_Synchronize_Product_Data->sync_product_total_sales, WC_Data_Store->__call, WC_Product_Data_Store_CPT->update_product_sales, WC_Data_Store_WP->update_lookup_table, WC_Product_Data_Store_CPT->get_data_for_lookup_table, get_post_meta, get_metadata, get_metadata_raw, apply_filters('get_post_metadata'), WP_Hook->apply_filters, WCML_Multi_Currency_Prices->product_price_filter, WPMLFP{closure}, call_user_func_array, WPMLFPLogic::WPMLFP{closure}, WCML_Multi_Currency_Prices->{closure}, WCML_Custom_Prices->get_product_custom_prices
Questions:
Why is the WCML (multicurrency) causing an error during the WooCommerce order process?
How can I resolve the SQL syntax error to ensure the subscription with Stripe is created?
I am confirming that the problem still persists with the marketplace plugins disabled. The only plugins enabled are: Error Log Monitor, WooCommerce, WooCommerce Multilingual & Multicurrency, WooCommerce Stripe Gateway, WPML Multilingual CMS and WPML String Translation. (Note I need to stripe plugin active in order to pay and finish the checkout process)
Add this item to the cart: hidden link
Choose the ILS currency (you will need to use a vpn for a location in Israel to have ILS accessible, or you can change the preferences of the WCML to show ILS always, I can provide login details)
Continue with full checkout process
Log will show:
Deprecated: Optional parameter $post_translations declared before required parameter $wpdb is implicitly treated as a required parameter in /mnt/data/home/1369476.cloudwaysapps.com/ayfwawuspa/public_html/wp-content/plugins/woocommerce-multilingual/inc/class-wcml-products.php on line 33
(many iterations of this alert)
and:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3 for query SELECT post_id, meta_key, meta_value FROM wp_postmeta
WHERE meta_key IN ('_price', '_regular_price', '_sale_price', '_price_ILS', '_regular_price_ILS', '_sale_price_ILS')
AND post_id IN () made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action('wc_ajax_checkout'), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::checkout, WC_Checkout->process_checkout, WC_Checkout->process_order_payment, WC_Stripe_UPE_Payment_Gateway->process_payment, WC_Stripe_UPE_Payment_Gateway->process_payment_with_deferred_intent, WC_Stripe_UPE_Payment_Gateway->process_payment_with_payment_method, WC_Stripe_Payment_Gateway->process_response, WC_Order->payment_complete, WC_Order->save, WC_Order->status_transition, do_action('woocommerce_order_status_processing'), WP_Hook->do_action, WP_Hook->apply_filters, wc_update_total_sales_counts, do_action('woocommerce_recorded_sales'), WP_Hook->do_action, WP_Hook->apply_filters, WCML_Synchronize_Product_Data->sync_product_total_sales, WC_Data_Store->__call, WC_Product_Data_Store_CPT->update_product_sales, WC_Data_Store_WP->update_lookup_table, WC_Product_Data_Store_CPT->get_data_for_lookup_table, get_post_meta, get_metadata, get_metadata_raw, apply_filters('get_post_metadata'), WP_Hook->apply_filters, WCML_Multi_Currency_Prices->product_price_filter, WPML\FP\{closure}, call_user_func_array, WPML\FP\Logic::WPML\FP\{closure}, WCML_Multi_Currency_Prices->{closure}, WCML_Custom_Prices->get_product_custom_prices
This staging site is set up for you should you need to access it: (same site as the product link above) hidden link
I need to take a closer look at your site. So I request temporary access (WP-Admin and FTP), preferably to a test site where the problem has been replicated.
Your next answer will be private, to share this information safely.
IMPORTANT: Please take a complete backup of the site to avoid data loss. I may need to activate/deactivate plugins also.
I was able to reproduce the issue, even without Stripe and after updating WooCommerce to the latest (as well as with a default WP theme). So far, the issue is evident in the minimal setup, and with ILS currency only.
I'm further looking into it. Please do not make any change in the staging site and leave it as it is in the current condition.
It may take some time, however, I'll update you accordingly.
I'm trying to reproduce the issue in a sandbox site, to confirm if that the issue can be reproduced elsewhere or is it only happening in your site.
This 'll take some time and I'll be able to update you on Monday. After confirming this, I'll escalate the issue to our 2nd tier team, with my sandbox site or your staging site.
P.S.: I'll be off over the weekend and 'll be able to attend on Monday.
Hello, I am sorry to report that after updateding WooCommerce Multilingual & Multicurrency in my live site to the last version 5.5.0 via the Commercial tab and adding the fix that you suggested manually, now each page in the website logs the error:
Deprecated: Optional parameter $post_translations declared before required parameter $wpdb is implicitly treated as a required parameter in /mnt/data/home/1369476.cloudwaysapps.com/gkrgagekyw/public_html/wp-content/plugins/woocommerce-multilingual/inc/class-wcml-products.php on line 33
(same one reported on June 25, 2025 at 10:59 am on this ticket)
This also occurs when I have only WooCommerce, WooCommerce Multilingual & Multicurrency, WPML Multilingual CMS, WPML String Translation plugins enabled (all the rest are disabled) and Twenty Seventeen Theme.
