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.

We recommend modifying the SQL query used by WooCommerce Multilingual. Here\'s how you can do it: 1. Navigate to <code>wp-content/plugins/woocommerce-multilingual/inc/currencies/class-wcml-multi-currency-reports.php</code>. 2. Replace the function <code>filter_dashboard_status_widget_sales_query</code> with the following code: <code> public function filter_dashboard_status_widget_sales_query( $query ) {\n\n $currency = $this->woocommerce_wpml->multi_currency->admin_currency_selector->get_cookie_dashboard_currency();\n if ( isset( $query["select"] ) && ( ( strpos( $query["select"], "SELECT COUNT" ) !== false ) || ( strpos( $query["select"], "SELECT SUM" ) !== false ) ) ) {\n $query[\'join\'] .= " INNER JOIN {$this->wpdb->postmeta} AS currency_postmeta ON posts.ID = currency_postmeta.post_id";\n } else {\n $query[\'join\'] .= " INNER JOIN {$this->wpdb->postmeta} AS currency_postmeta ON orders.ID = currency_postmeta.post_id";\n }\n $query[\'where\'] .= $this->wpdb->prepare( " AND currency_postmeta.meta_key = \'_order_currency\' AND currency_postmeta.meta_value = %s", $currency );\n\n return $query;\n }\n\n}</code> 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 <a href="https://wpml.org/known-issues/">https://wpml.org/known-issues/</a>, 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 <a href="https://wpml.org/forums/forum/english-support/">open a new support ticket</a>.

Bug - WPML

Tema	Voces	Entradas	Frescura
Issue when translating articles Iniciado por: stefand-43 en: English Support	2	5	hace 3 días, 14 horas Lucas Vidal de Andrade
Language Switcher Iniciado por: patrick-jankoP-2 en: Chat Support	1	2	hace 3 días, 16 horas
Issue when translating articles (stuck at 98%) Iniciado por: stefand-43 en: English Support	2	2	hace 3 días, 17 horas Lucas Vidal de Andrade
checkout page is in wrong lamngauge for one language Iniciado por: haraldK-9 en: English Support	2	11	hace 3 días, 18 horas Lucas Vidal de Andrade
Partage: WPFD and Jetengine – Product loop isn't translated 1 2 Iniciado por: renaudL-2 en: Assistance en français	2	17	hace 3 días, 18 horas Ilyes
Deutscher Beitrag wird auch auf der französischen Website angezeigt Iniciado por: yvonneO en: Chat Support	1	2	hace 3 días, 18 horas
wp-admin user language/cookie doesn't work/ignored Iniciado por: desireeM en: English Support	2	5	hace 3 días, 18 horas Bruno Kos
wo ist mein support chat? Iniciado por: ulrichR-7 en: Chat Support	1	2	hace 3 días, 19 horas
Credits Iniciado por: ulrichR-7 en: Unterstützung in Deutsch	1	2	hace 3 días, 19 horas
Side cart plugin doesn't switch languages Iniciado por: frankC-20 en: Unterstützung in Deutsch	2	15	hace 3 días, 19 horas Lucas Vidal de Andrade
Standardkategorie verschwindet und dazugehöriger URL-Slug wird umbenannt Iniciado por: johannaB-12 en: Unterstützung in Deutsch	2	7	hace 3 días, 20 horas Lucas Vidal de Andrade
Use directory for default language causes problem with IndexNow Iniciado por: mariuszM-13 en: English Support	2	11	hace 3 días, 22 horas Christopher Amirian
woodmart layout condition Iniciado por: robertod-38 en: Assistenza in italiano	2	15	hace 4 días Laura
WPML fallback if not translated – Translated url/taxonomy doesn't show correctly Iniciado por: jonasP-14 en: English Support	2	4	hace 4 días, 2 horas Bruno Kos
A huge problem with the translating repeater field in classic editor (continued again) Iniciado por: klimeM en: English Support	3	13	hace 6 días, 15 horas Bigul