If this solution does not apply to your case, or if it seems outdated, 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 issues persist, please open a new support ticket.
Problem: If you're trying to activate Multicurrency in WooCommerce with the WPML plugin and encounter a WordPress database error stating 'Unknown column 'posts.ID'', this issue typically arises when the SQL query fails to correctly join tables in the database. Solution: We recommend modifying the SQL query used by WooCommerce Multilingual. Here's how you can do it: 1. Navigate to
public function filter_dashboard_status_widget_sales_query( $query ) {
$currency = $this->woocommerce_wpml->multi_currency->admin_currency_selector->get_cookie_dashboard_currency();
if ( isset( $query["select"] ) && ( ( strpos( $query["select"], "SELECT COUNT" ) !== false ) || ( strpos( $query["select"], "SELECT SUM" ) !== false ) ) ) {
$query['join'] .= " INNER JOIN {$this->wpdb->postmeta} AS currency_postmeta ON posts.ID = currency_postmeta.post_id";
} else {
$query['join'] .= " INNER JOIN {$this->wpdb->postmeta} AS currency_postmeta ON orders.ID = currency_postmeta.post_id";
}
$query['where'] .= $this->wpdb->prepare( " AND currency_postmeta.meta_key = '_order_currency' AND currency_postmeta.meta_value = %s", $currency );
return $query;
}
}
This modification should resolve the error. Please note that this solution will be included in a future release of the WCML plugin.
If this solution does not apply to your situation, or if it seems outdated, 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 issue persists, please open a new support ticket.
