Problem: You are encountering a database error after migrating your domain to a new hosting environment. The error is caused by an emoji in a WooCommerce translation string, which leads to a query failure due to mixed collation in the database. Solution: We recommend removing the emoji from the content as a temporary workaround. If this solution does not resolve your issue or seems outdated, please check the related known issues, verify the version of the permanent fix, and confirm that you have installed the latest versions of themes and plugins. If further assistance is needed, feel free to open a new support ticket at our support forum.
Problem: If you're experiencing a fatal error when trying to activate the WPML plugin, it might be due to an issue with your MySQL version. The error message indicates a problem with creating a table because only one TIMESTAMP column with CURRENT_TIMESTAMP in the DEFAULT or ON UPDATE clause is allowed. Solution: We recommend updating your MySQL to the latest stable version supported by your hosting environment. This issue often occurs with MySQL versions ≤ 5.5 or early versions of 5.6, which only allow one TIMESTAMP column with DEFAULT CURRENT_TIMESTAMP or ON UPDATE CURRENT_TIMESTAMP per table. Updating MySQL should resolve this issue. Additionally, consider updating PHP to the latest supported version to enhance performance, security, and compatibility with modern plugins.
If this solution does not apply to your case, or if it seems outdated, please check the related known issues, verify the version of the permanent fix, and confirm that you have installed the latest versions of themes and plugins. If the problem persists, we highly recommend opening a new support ticket at WPML support forum.
