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 10 replies, has 2 voices.

Last updated by Camilo 1 year, 6 months ago.

Assisted by: Dražen Duvnjak.

Author Posts
May 12, 2023 at 9:41 pm #13639351

Camilo

Hi,

I'm using the String Package Translation (https://wpml.org/documentation/support/string-package-translation/) to register strings for translation that are coming from an API (they won't change, only new content will be added).

I used the string translation screen to select them all and send them to the translation basket, and through the basket, I assigned them to myself for translation.

After doing this, I went to the translation queue and I'm now getting the "Jobs could not be loaded" error. Same with the Jobs tab from the translation management screen. I was not getting this before sending the string package for translation.

What I'm really looking for (besides fixing the "Jobs could not be loaded" error, I've already checked my memory limit and it's 256M <green> and no logged errors when debugging is enabled) is to use automatic translations for these string packages. How can I achieve it without breaking WPML?

Thanks,

May 15, 2023 at 6:27 am #13644503

Dražen Duvnjak
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+01:00)

Hello,

thanks for contacting us.

Such an issue can happen if the website was recently moved from production to staging, or some connection was lost with our ATE server.

Please try next:

- Go to WPML > Support > Troubleshooting > "Synchronize local job ids with ATE jobs", then also run "Synchronize translators and translation managers with ATE"
- Go to WPML > String translation and send again strings for translation and repeat the process.
- Once the ATE editor us opened you can use the Translate automatically button from top. Image attached.

Another way would be enabling the Translate Everything mode.

- https://wpml.org/documentation/automatic-translation/

Let me know how it goes and if you still get related error message.

Regards,
Drazen

translate-automatically-in-ate-1.png
May 15, 2023 at 2:34 pm #13648889

Camilo

Hi Dražen,

After following your suggested steps on the troubleshooting page (which I had already done before my original post), I'm still getting the "Jobs could not be loaded" on the Jobs and Translation pages (see attached images).

All of this started happening after I went to String Translation, selected all items from my package (speaker-speaker) and sent them for translation (see Screenshot 2023-05-15 at 9.32.35.jpg).

Any ideas on how to fix this?

Thanks,

Screenshot 2023-05-15 at 9.32.35.jpg
Screenshot 2023-05-15 at 9.31.13.jpg
Screenshot 2023-05-15 at 9.30.57.jpg
May 16, 2023 at 6:30 am #13652259

Dražen Duvnjak
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+01:00)

Hello,

thanks for getting back.

It could be there is some issue with the connection or some of the security/hosting plugins blocking that.

Please make a full backup of your site (files and database) and confirm it in your next reply.
If possible please provide access to the staging website, not production.

Please note, that I might need to do some debugging procedures like enable/disable plugins, switch themes, change the default language of the user account, and/or access your website database to debug the issue furtherly.

I will share with you any changes or steps done in this process. Please let me know if you do not agree with the above or if I do not have your permission for any.

I would need to access both your site's wp-admin and FTP account, if possible.

I have enabled the private username and password fields in your next reply.

I suggest you create a new user, set it as an administrator and then add those credentials in the private fields mentioned.

You can safely add your information into these fields.

Thanks,
Drazen

May 17, 2023 at 6:49 am #13660787

Dražen Duvnjak
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+01:00)

Hello,

thanks for getting back.

At first I couldn't proceed further to check the issue, since I am missing some features with my admin user, for example, the plugins page, there is some custom code and etc.

But once I have run mentioned troubleshooting steps and re-sent the page for translation via Translation Management, it seems to work just fine.

Please try it yourself and make sure to create a new job, by sending it to translation via Translation Management.

Video: hidden link

Let me know how it goes and if any related questions.

Regards,
Drazen

May 17, 2023 at 7:03 am #13661021

Camilo

Hi Dražen,

I've made you Super Admin so you should be able to do everything, including the plugins page.

What custom code are you referring to?

As I mentioned on my first comment, this is happening for String Package Translations.

Please check this video about steps to recreate: hidden link

Thanks,

May 17, 2023 at 11:04 am #13663447

Dražen Duvnjak
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+01:00)

Hello,

thanks for getting, sorry I misunderstood it then. As for custom code, it is related to your custom theme and custom plugins.

Anyway, I checked and could see the issue and error message:
- Table 'wp_vidconstaging.wp_e43U0q_4_icl_string_batches' doesn't exist

I have checked your DB and could see this table missing, while for example for another subsite it exists: wp_e43U0q_3_icl_string_batches

Please try the next steps:
- https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/

If not please manually create the table with the correct structure, as in the shared image. I have tried to modify some parts but do not have permission, could be the same caused issue as WPML was not able to create tables.

Then please try again and let me know if the issue still happens.

Regards,
Drazen

Screenshot_4.jpg
May 17, 2023 at 11:30 pm #13668377

Camilo

Hi Dražen,

I've tried to fix it with the `icl_sitepress_activate();` method but it didn't work, so I ended up copying the structure of the table `wp_e43U0q_3_icl_string_batches` to `wp_e43U0q_3_icl_string_batches`. I saw the empty table with the correct structure after this.

I tried again the same process as shown on the video I shared earlier, and saw that the new table was populated with several new rows, but I'm still seeing the same "Jobs could not be loaded" error.

Please see attached images for reference.

Any ideas what else can I try?

Thanks,

Screenshot 2023-05-17 at 18.26.25.jpg
Screenshot 2023-05-17 at 18.26.00.jpg
Screenshot 2023-05-17 at 18.25.37.jpg
May 18, 2023 at 6:47 am #13669221

Dražen Duvnjak
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+01:00)

Hello,

thanks for getting back.

I have enabled debug log and could see some new error messages, that seem to be related to nonexisting translation jobs, probably caused by that table missing. So I went to wp_e43U0q_4_icl_translation_status and changed two jobs from status 2 to 1, (completed)

Now if you open WPML > Translation, it seems to work fine.

Please check.

Regards,
Drazen

May 18, 2023 at 1:14 pm #13672271

Camilo

Hi Dražen,

On staging things are working as expected, thanks!

I'm trying to replicate this fix on production: I've used most of the troubleshooting buttons to clear/clean the WPML database; I've added the icl_sitepress_activate() to be triggered on the footer and later removed it; I've manually created the missing table; I've changed the status column on two random jobs from the `wp_e43U0q_4_icl_translation_status` table from 2 to 1.

Although I've replicated all the steps, I'm still seeing the "Jobs could not be loaded" error on production.

Am I missing anything? Were there additional steps performed?

Thanks,

May 18, 2023 at 1:29 pm #13672389

Camilo

Hi Dražen,

After changing the status on some more random jobs from 2 to 1 it finally worked!

My issue is resolved now.

Thanks so much for all the help!!!