basv-25의 프로필

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

wp-content/plugins/woocommerce-multilingual/inc/currencies/class-wcml-multi-currency-reports.php

.
2. Replace the function

1	`filter_dashboard_status_widget_sales_query`

with the following code:

    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.