I'm getting an error in my logs. Not sure if there something wrong with the configuration or a bug. This is probably triggered by a customer trying to do a purchase.
```
[20-Sep-2023 18:58:42 UTC] 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 3 for query SELECT post_id, meta_key, meta_value FROM wp_postmeta
WHERE meta_key IN ('_price', '_regular_price', '_sale_price', '_price_NOK', '_regular_price_NOK', '_sale_price_NOK')
AND post_id IN () made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, KCO_Confirmation->confirm_order, kco_confirm_klarna_order, 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
```
Also these warnings precede the error with the same timestamp:
```
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_regular_price_NOK in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_regular_price_NOK in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_regular_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_regular_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_sale_price_NOK in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_sale_price_NOK in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_price_NOK in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_price_NOK in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_regular_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_regular_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_sale_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_sale_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_regular_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_regular_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_sale_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_sale_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
[20-Sep-2023 18:58:42 UTC] PHP Warning: Undefined property: stdClass::$_price in /var/www/wp-site/wp-includes/class-wp-list-util.php on line 192
```
[28-Sep-2023 11:53:30 UTC] 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 3 for query SELECT post_id, meta_key, meta_value FROM wp_postmeta
WHERE meta_key IN ('_price', '_regular_price', '_sale_price', '_price_NOK', '_regular_price_NOK', '_sale_price_NOK')
AND post_id IN () made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, KCO_Confirmation->confirm_order, kco_confirm_klarna_order, 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
I'm guessing the error is 'post_id IN ()', since this is probably invalid SQL. Why the post_id is empty though, I do not know...
As this is a syntax error most likely something in the code is triggering it with the version of MySQL used.
Taking a second look again at your MySQL Version I can see you are using 8.0, are you able to as a quick test to drop down to an older version? If you can please let me know your results.
The topic ‘[Closed] Error in your SQL syntax: get_product_custom_prices’ is closed to new replies.
