[Resolved] showing critical error when installing this plugin in wordpress

Problem:
The client was experiencing a critical error on their site after purchasing and attempting to activate WPML. The error persisted even after deactivating all other plugins and switching to the default WordPress theme.

Solution:
We identified that the issue was due to corrupted default WordPress tables, specifically missing auto increments in the

wp_users

,

wp_usermeta

, and

wp_options

tables, with many entries having an ID of '0'. We provided a solution that involved running SQL queries to delete the bad data and alter the tables to add the necessary auto increments. The client needed to execute the following queries one by one:

DELETE FROM `wp_users` WHERE `ID` = '0';

ALTER TABLE `wp_users` CHANGE `ID` `ID` bigint unsigned NOT NULL AUTO_INCREMENT FIRST;

DELETE FROM `wp_usermeta` WHERE `umeta_id` = '0';

ALTER TABLE `wp_usermeta` CHANGE `umeta_id` `umeta_id` bigint unsigned NOT NULL AUTO_INCREMENT FIRST;

DELETE FROM `wp_options` WHERE `option_id` = '0';

ALTER TABLE `wp_options` CHANGE `option_id` `option_id` bigint unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

We advised the client to back up their database before making any changes. If the client was not comfortable performing these steps or if the solution did not resolve the issue, we recommended seeking further assistance, as this was beyond the scope of our support.

Please note that this solution might be irrelevant due to being outdated or not applicable to your case. If you're still facing issues, we highly recommend checking the related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the problem persists, please open a new support ticket with us.