Background of the issue:
I am trying to activate the WPML for our new website (Production).
Symptoms:
An ERR message appeared when activating WPML String Translation. The error message states: 'We have detected a problem with some tables in the database. Please contact WPML support to get this fixed.' Additionally, there is a WordPress database error: 'Could not perform query because it contains invalid data.'
Questions:
How can I fix the database table issue detected during WPML activation?
What steps should I take to resolve the WordPress database error?
Thank you for contacting WPML Support. Sometimes, these messages can be false positives that get stuck, and you can verify this by following the steps below:
1. Please attempt to remove the warning message by clicking the small 'x' icon on the message.
2. Afterward, refresh the dashboard to check if the warning message persists.
If the message disappears, then everything should be in order. However, if the issue persists, please follow the below steps:
1. Take a backup of your site first for safety reasons.
2. We have recently released WPML 4.7.2, please update it to the latest version. You can update it from Plugins >> Add New Plugin page, click the Commercial tab, and then click the “Check for updates” button. Here is the screenshot for more details: https://wpml.org/wp-content/uploads/2020/04/wpml-force-plugin-update-1.png
3. If still an issue persists, please enable error reporting on your site as I need to see the details of the latest error log to understand the cause of the issue better. To enable it, open your ‘wp-config.php’ file and look for ‘define(‘WP_DEBUG’, false);’. Change it to:
// Enable WP_DEBUG mode
define( 'WP_DEBUG', true );
// Enable Debug logging to the /wp-content/debug.log file
define( 'WP_DEBUG_LOG', true );
// Disable display of errors and warnings
define( 'WP_DEBUG_DISPLAY', false );
@ini_set( 'display_errors', 0 );
define( 'SCRIPT_DEBUG', true );
After adding the above code, please try activating the WPML String Translation plugin and accessing the WPML >> String Translation page again, and if this process creates a debug.log file in your site's wp-content directory. Please send me its contents.