Problem: The client is experiencing a database error in the WooCommerce status widget on the WordPress dashboard when the WooCommerce Multilingual & Multicurrency plugin is activated. The error message indicates an unknown column 'posts.ID' in the 'on clause' of a SQL query. Solution: We first asked the client to deactivate the HPOS to see if the error resolves, as the issue might be related to that. If the error persists, we recommended enabling debug logging to gather more details about the error. Debug logging can provide insights into what might be causing the issue, as the error message does not point to a specific WPML database table but seems more related to WooCommerce. To enable debug logging, follow the instructions provided here: https://wpml.org/documentation/support/debugging-wpml/
Please note that the solution provided might be outdated or not applicable to your case. If the issue persists after trying the recommended steps, 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 you still need assistance, please open a new support ticket with us.
Problem: The client is unable to edit exchange rates using the code provided in the WPML documentation. They are fetching rates from an external source and want to set WPML's currency rates to custom values. The provided code works on the front end but does not affect the backend, as the rates in the WooCommerce Multilingual multicurrency tab remain unchanged.
Solution: We explained that the
wcml_exchange_rates
filter is not used to edit rates but to provide them when needed. To use custom exchange rates, the client should: 1) Disable WCML automatic exchange rates. 2) Implement a mechanism to regularly update and store the exchange rates, potentially in the
wp_options
table. 3) Use the
wcml_exchange_rates
filter to read the stored exchange rates and provide them to WCML. We also mentioned that there is no specific hook to update the rates in the backend, but the client can use the wcml_before_multi_currency_ui hook to run actions before generating the Multi-currency tab. If the client requires a custom solution beyond the scope of the support forum, we recommend contacting WPML Contractors at https://wpml.org/contractors/.
Please note that this solution might be outdated or not applicable to your case. If so, we encourage you to check the related known issues at https://wpml.org/known-issues/, verify the version of the permanent fix, and ensure you have the latest versions of themes and plugins installed. If the issue persists, please open a new support ticket at our support forum.
