Problem: The client translated all product attribute terms into every language using WPML but found that the term thumbnail images did not automatically display for all translated terms.
Solution: 1. Identify the custom field name used for term thumbnails. This can vary depending on the theme or plugins used. 2. Set the translation preference for this custom field in WPML to 'Copy'. This ensures that the thumbnail images display correctly across all languages. 3. If the field is set to 'Don't translate', change it to 'Copy' in WPML -> Settings -> Custom Term Meta Translation, then save the changes. 4. Update the translation of the term to reflect these changes.
If this solution does not resolve your issue, or if it seems outdated or irrelevant to your specific case, we recommend opening a new support ticket. Additionally, 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. For further assistance, please visit our support forum at WPML Support Forum.
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.
