Troubleshoot 'WordPress database error Unknown column' error

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.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	-
-	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	-

Supporter timezone: Asia/Kathmandu (GMT+05:45)

This topic contains 0 reply, has 0 voices.

Last updated by Ivan Beemster 6 months ago.

Assisted by: Shekhar Bhandari.

Author	Posts
February 4, 2025 at 6:59 am
Ivan Beemster	Background of the issue: I am trying to resolve an error on my site hidden link. The product page hidden link throws an error. Disabling WPML Multilingual CMS resolves the issue. The error log shows: [04-Feb-2025 06:38:25 UTC] WordPress database error Unknown column 'Geen' in 'WHERE' for query SELECT * FROM ww_nm_personalized WHERE productmeta_id IN(Geen) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/woocommerce/templates/single-product.php'), wc_get_template_part, load_template, require('/plugins/woocommerce/templates/content-single-product.php'), do_action('woocommerce_after_single_product_summary'), WP_Hook->do_action, WP_Hook->apply_filters, avia_woocommerce_output_upsells, woocommerce_upsell_display, wc_get_template, include('/plugins/woocommerce/templates/single-product/up-sells.php'), wc_get_template_part, load_template, require('/plugins/woocommerce/templates/content-product.php'), do_action('woocommerce_after_shop_loop_item_title'), WP_Hook->do_action, WP_Hook->apply_filters, woocommerce_template_loop_price, wc_get_template, include('/plugins/woocommerce/templates/loop/price.php'), WC_Product->get_price_html, apply_filters('woocommerce_get_price_html'), WP_Hook->apply_filters, ppom_woocommerce_alter_price, ppom_has_field_by_type, PPOM_Meta->__construct, PPOM_Meta->settings [04-Feb-2025 06:38:25 UTC] WordPress database error Unknown column 'Geen' in 'WHERE' for query SELECT * FROM ww_nm_personalized WHERE productmeta_id IN(Geen) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/woocommerce/templates/single-product.php'), wc_get_template_part, load_template, require('/plugins/woocommerce/templates/content-single-product.php'), do_action('woocommerce_after_single_product_summary'), WP_Hook->do_action, WP_Hook->apply_filters, avia_woocommerce_output_upsells, woocommerce_upsell_display, wc_get_template, include('/plugins/woocommerce/templates/single-product/up-sells.php'), wc_get_template_part, load_template, require('/plugins/woocommerce/templates/content-product.php'), do_action('woocommerce_after_shop_loop_item'), WP_Hook->do_action, WP_Hook->apply_filters, avia_add_cart_button, woocommerce_template_loop_add_to_cart, WC_Product->supports, apply_filters('woocommerce_product_supports'), WP_Hook->apply_filters, NM_PersonalizedProduct->product_supports, PPOM_Meta->__construct, PPOM_Meta->settings Symptoms: WordPress database error Unknown column 'Geen' in 'WHERE' for query SELECT * FROM ww_nm_personalized WHERE productmeta_id IN(Geen). Questions: How can I resolve the 'Unknown column' error related to WPML? Why does disabling WPML Multilingual CMS resolve the issue?
February 4, 2025 at 7:45 am

Author

Posts

February 4, 2025 at 6:59 am

Ivan Beemster

Background of the issue:
I am trying to resolve an error on my site hidden link. The product page hidden link throws an error. Disabling WPML Multilingual CMS resolves the issue.

The error log shows:

[04-Feb-2025 06:38:25 UTC] WordPress database error Unknown column 'Geen' in 'WHERE' for query SELECT * FROM ww_nm_personalized WHERE productmeta_id IN(Geen) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/woocommerce/templates/single-product.php'), wc_get_template_part, load_template, require('/plugins/woocommerce/templates/content-single-product.php'), do_action('woocommerce_after_single_product_summary'), WP_Hook->do_action, WP_Hook->apply_filters, avia_woocommerce_output_upsells, woocommerce_upsell_display, wc_get_template, include('/plugins/woocommerce/templates/single-product/up-sells.php'), wc_get_template_part, load_template, require('/plugins/woocommerce/templates/content-product.php'), do_action('woocommerce_after_shop_loop_item_title'), WP_Hook->do_action, WP_Hook->apply_filters, woocommerce_template_loop_price, wc_get_template, include('/plugins/woocommerce/templates/loop/price.php'), WC_Product->get_price_html, apply_filters('woocommerce_get_price_html'), WP_Hook->apply_filters, ppom_woocommerce_alter_price, ppom_has_field_by_type, PPOM_Meta->__construct, PPOM_Meta->settings

[04-Feb-2025 06:38:25 UTC] WordPress database error Unknown column 'Geen' in 'WHERE' for query SELECT * FROM ww_nm_personalized WHERE productmeta_id IN(Geen) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/woocommerce/templates/single-product.php'), wc_get_template_part, load_template, require('/plugins/woocommerce/templates/content-single-product.php'), do_action('woocommerce_after_single_product_summary'), WP_Hook->do_action, WP_Hook->apply_filters, avia_woocommerce_output_upsells, woocommerce_upsell_display, wc_get_template, include('/plugins/woocommerce/templates/single-product/up-sells.php'), wc_get_template_part, load_template, require('/plugins/woocommerce/templates/content-product.php'), do_action('woocommerce_after_shop_loop_item'), WP_Hook->do_action, WP_Hook->apply_filters, avia_add_cart_button, woocommerce_template_loop_add_to_cart, WC_Product->supports, apply_filters('woocommerce_product_supports'), WP_Hook->apply_filters, NM_PersonalizedProduct->product_supports, PPOM_Meta->__construct, PPOM_Meta->settings

Symptoms:
WordPress database error Unknown column 'Geen' in 'WHERE' for query SELECT * FROM ww_nm_personalized WHERE productmeta_id IN(Geen).

Questions:
How can I resolve the 'Unknown column' error related to WPML?
Why does disabling WPML Multilingual CMS resolve the issue?

February 4, 2025 at 7:45 am

The topic ‘[Closed] Troubleshoot 'WordPress database error Unknown column' error’ is closed to new replies.