WordPress database error: [Unknown column ‘posts.ID’ in ‘on clause’]
-
I have this error on my wordpress dashboard:
WordPress database error:?[Unknown column ‘posts.ID’ in ‘on clause’]
SELECT SUM( order_item_meta.meta_value ) as qty, order_item_meta_2.meta_value as product_id FROM db5q_wc_orders AS orders INNER JOIN db5q_woocommerce_order_items AS order_items ON orders.id = order_id INNER JOIN db5q_woocommerce_order_itemmeta AS order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id INNER JOIN db5q_woocommerce_order_itemmeta AS order_item_meta_2 ON order_items.order_item_id = order_item_meta_2.order_item_id INNER JOIN db5q_postmeta AS currency_postmeta ON posts.ID = currency_postmeta.post_id WHERE orders.type IN ( 'shop_order' ) AND orders.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.date_created_gmt >= '2024-08-01' AND orders.date_created_gmt <= '2024-08-15 05:47:33' AND currency_postmeta.meta_key = '_order_currency' AND currency_postmeta.meta_value = 'EUR' GROUP BY product_id ORDER BY qty DESC LIMIT 1Please let me know how to fix it.
- You must be logged in to reply to this topic.
