Skip Navigation

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 15 replies, has 2 voices.

Last updated by ghilanA 1 year, 10 months ago.

Assisted by: Bobby.

Author Posts
June 8, 2022 at 3:15 pm #11416117

ghilanA

We have an error message that appears on the site. I attached a picture of it to you. WPML cannot connect to your site. Also, we are unable to upload an image when String Translation is active.

June 8, 2022 at 5:30 pm #11417227

ghilanA

Important note, I tried to access the media section within the WordPress control panel, but unfortunately there was no response and the error shown in the attached image appeared by pressing "inspect" from the browser options

Screenshot 2022-06-08 202512.jpg
June 8, 2022 at 9:23 pm #11418347

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-07:00)

Hello,

I would need to see the detail of the error. You can see how to enable debug logging here:
https://wpml.org/documentation/support/debugging-wpml/

Go in your wp-config.php file and look for define(‘WP_DEBUG’, false);. Change it to:
define('WP_DEBUG', true);

Edit your wp-config.php file and add these lines, just before it says 'stop editing here':

ini_set('log_errors',TRUE);
ini_set('error_reporting', E_ALL);
ini_set('error_log', dirname(__FILE__) . 'https://cdn.wpml.org/error_log.txt');

This will create an error_log.txt file in your site's root directory. Please send me its contents.

June 9, 2022 at 3:35 am #11419603

ghilanA

I did what you asked, but I couldn't find the file mentioned in the root directory, so I sent the last 200 lines content for log file that was previously inside the logs folder, which I enabled earlier :

"

June 9, 2022 at 3:44 am #11419641

ghilanA

Also, the following message appears in the WordPress control panel :

Screenshot 2022-06-09 064238.jpg
June 9, 2022 at 8:19 am #11421363

ghilanA

and these the last debuge errors :
---------------------

June 9, 2022 at 9:41 am #11422609

ghilanA

After we deactive the string traslation plugin we can upload the pictures with postes but we have this error when we want to publish the post :

" There was a fatal error in this site.
Learn more about troubleshooting in WordPress."

June 9, 2022 at 5:35 pm #11427413

ghilanA

Is there anything new about our problem?!

June 9, 2022 at 8:41 pm #11428021

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-07:00)

Thank you for sharing the debug info, below you can see the two issues related to the error you are receiving

[09-Jun-2022 03:40:44 UTC] PHP Fatal error: Uncaught InvalidArgumentException: No translation entry found for query: s:42:" element_id = %d AND element_type LIKE %s ";a:2:

and

[08-Jun-2022 19:53:48 UTC] cURL error 28: Resolving timed out after 10000 milliseconds

Regarding Curl error:

1)
ask your server/hosting support for assistance to install the latest CURL extension on your site.
Here is more info on this:
hidden link

2)
Also, please ask them to whitelist the IPs from the following URLs for you:
- https://wpml.org
- hidden link
- hidden link
- hidden link
- hidden link

For the other error go to your database and locate the wp_icl_translations database table, and share a screenshot of it's structure with me.

Screen Shot 2022-06-09 at 1.40.51 PM.png
June 9, 2022 at 9:17 pm #11428127

ghilanA

Thank you for your interaction with us.. I will try to contact the hosting company to clarify points 1 and 2 for them, even though they told me that there is no problem on their part!

ِAnd for "wp_icl_translations database table"you can see the attached picture ..

icl_translations database table.jpg
June 9, 2022 at 10:01 pm #11428247

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-07:00)

Did you recently migrate your site or make any changes to your database?

The database is missing the AUTO INCREMENT and also it's indexes.

Can you please also review other tables in case they are missing indexes and AUTO INCREMENT ?

Do you have any recent backups ?

June 9, 2022 at 11:26 pm #11428369

ghilanA

Yes, we have moved the site from an external hosting company to a local company,

June 9, 2022 at 11:32 pm #11428373

ghilanA

and how I can know the other tables that in case they are missing indexes and AUTO INCREMENT ?

June 9, 2022 at 11:33 pm #11428375

ghilanA

I have a copy of the database from the previous hosting before transfer to local hosting

June 10, 2022 at 5:17 pm #11436435

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-07:00)

These are all the WPML tables that should have AUTO Increment enabled

ALTER TABLE `wp_icl_core_status`
CHANGE `id` `id` bigint(20) NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_flags`
CHANGE `id` `id` int(11) NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_languages`
CHANGE `id` `id` int(11) NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_languages_translations`
CHANGE `id` `id` int(11) NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_message_status`
CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_mo_files_domains`
CHANGE `id` `id` int(11) NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_strings`
CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_string_pages`
CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_string_positions`
CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_string_status`
CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_string_translations`
CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_string_urls`
CHANGE `id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_translate`
CHANGE `tid` `tid` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_translate_job`
CHANGE `job_id` `job_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_translation_batches`
CHANGE `id` `id` int(11) NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE `wp_icl_translation_status`
CHANGE `rid` `rid` bigint(20) NOT NULL AUTO_INCREMENT FIRST;

WordPress related tables:
https://wordpress.stackexchange.com/questions/225641/wordpress-database-lost-auto-increment

I recommend trying to re-migrate your database first or reviewing your previous installation's database tables to see if they are ok.

The database at the moment is corrupted, this is not caused by WPML but a migration gone wrong.

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.