[Waiting for user confirmation] Fatal Error When Attempting to Translate Pages in WPML

Hi,

batch_id should be there - see my screenshot on how this table should look like.

You could try adding it through cPanel e.g. or perhaps:

ALTER TABLE wp_icl_translation_status
ADD COLUMN batch_id INT NOT NULL DEFAULT 0;

Based on the errors you've shared, it seems the WPML database structure is incomplete or corrupted.

Since you've already tried using WPML’s troubleshooting tools and manually added the `batch_id` column without resolving the issue, I believe the core problem lies in an improper or incomplete initial setup.

If this is a new WPML installation and there are no existing translations that need to be preserved, I recommend performing a full reset of WPML. This will allow the plugin to recreate all necessary tables and start fresh, likely resolving the database-related fatal errors.

You can follow WPML’s official guide to perform the reset here:
https://wpml.org/documentation/getting-started-guide/language-setup/deleting-languages-and-plugin-data-by-doing-a-wpml-reset-on-your-site/#step-3-do-the-wpml-reset

Something has corrupted these tables, and I'm afraid the only solution is to check and fix them manually.

I’ve created a sandbox site for this purpose:
hidden link

The "WP phpMyAdmin" plugin is available on the site, so you can use it to compare your broken tables with the correct structure and make the necessary fixes.

That's correct, I see no other way. Perhaps it is the only column 'field_wrap_tag' missing and others are were not affected with this.

For the "rid" column within wp_icl_translation_status, is any value 0? If so, delete this row. Also make sure that there is AUTO_INCREMENT set for it (and other icl_ tables as well).

Would you be willing to provide me with WordPress and FTP credentials so I could investigate the issue directly?

Also install https://wordpress.org/plugins/wp-phpmyadmin-extension/ or https://wordpress.org/plugins/pexlechris-adminer/

https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

I marked your next reply as private so that you can safely add credentials.

And to confirm, the error would trigger if I enter any page and just click the + button so I could translate it, or something else needs to be done?