Problem: After searching for a while, I discovered in the file: "woocommerce-multilingualinccurrenciesclass-wcml-multi-currency-reports.php" on line: 202 an error in the query: specifically: instead of "posts.ID" there should probably be "orders.ID".
WordPress database error Unknown column 'posts.ID' in 'on clause' for query SELECT SUM( order_item_meta.meta_value ) as qty, order_item_meta_2.meta_value as product_id FROM XXX___posts AS orders INNER JOIN XXX___woocommerce_order_items AS order_items ON orders.ID = order_id INNER JOIN XXX___woocommerce_order_itemmeta AS order_item_meta ON order_items.order_item_id INNER JOIN XXX___woocommerce_order_itemmeta AS order_item_meta_2 ON order_items.order_item_id INNER JOIN XXX___postmeta AS currency_postmeta ON posts.ID = currency_postmeta.post_id WHERE orders.post_type IN ( 'shop_order' ) AND orders.post _status IN ( 'wc-completed','wc-processing','wc-on-hold' ) AND order_item_meta.meta_key = '_qty' AND order_item_meta_2.meta_key = '_product_id' AND orders.post_date_gmt >= '2024-09-01 ' AND orders.post_date_gmt status_widget, WC_Admin_Dashboard->get_top_seller
Solution: We are aware of this issue and plan to include the fix in future releases of the WooCommerce Multilingual & Multicurrency plugin. If you're experiencing this issue, we recommend replacing
posts.ID
with
orders.ID
in your database queries.
Please note that this solution might be outdated or not applicable to your specific case. We highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the problem persists, please open a new support ticket at WPML support forum.
