Skip to content Skip to sidebar

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.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 14:00 9:00 – 14:00 9:00 – 14:00 9:00 – 14:00 9:00 – 14:00 -
- 15:00 – 18:00 15:00 – 18:00 15:00 – 18:00 15:00 – 18:00 15:00 – 18:00 -

Supporter timezone: Asia/Dhaka (GMT+06:00)

Tagged: 

This topic contains 10 replies, has 2 voices.

Last updated by Prosenjit Barman 1 year, 3 months ago.

Assisted by: Prosenjit Barman.

Author Posts
March 20, 2024 at 11:55 pm #15434045

Maximilian Wellner

got this issue on backend:

Wir haben ein Problem mit einigen Tabellen in der Datenbank erkannt. Bitte kontaktieren Sie den WPML-Support, um dies beheben zu lassen.

WordPress-Datenbankfehler: Die Abfrage konnte nicht ausgeführt werden, weil sie ungültige Daten enthält.
Array
(
[language] => de
[context] => admin_texts_woocommerce_gateways
[gettext_context] =>
[domain_name_context_md5] => 73b11f2c39b6699b0b90949f4715d03d
[name] => sofortgateway_gateway_title
[value] => Sofortüberweisung
[status] => 0
[translation_priority] => optional
[allow_empty_value] =>
)

and I wanted to translate my home page with the classic editor, but the button for that is missing

March 21, 2024 at 12:14 pm #15436206

Prosenjit Barman
WPML Supporter since 03/2023

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hello There,
Thanks for contacting WPML Support.

I understand the issue you're having and will try my best to assist you in this matter.

The problem you're encountering often happens due to using emojis or similar special characters in your content, which might not be supported by your database's character encoding. Since this issue is linked to the text "Sofortüberweisung" in one of the WooCommerce Payment gateways, I recommend editing the text and replacing the Umlaut character (ü) with English 'U'. Once you've made this change and saved it, please try the translation again. This adjustment should help address the issue.

If you're still having the issue, please try the solution mentioned in the following ticket.

- https://wpml.org/forums/topic/database-error-cant-perform-query/

Regarding the question about using Classic Translation Editor - If you go to "WPML > Settings", under "Translation Editor" you should see the option to change the editor to "Classic Translation Editor". If the option appears disabled, the Automatic Translation might be enabled on your site. Please change the "Translation Mode" to "Translate What you Choose" from WPML Settings and check again.

Let me know if that helps or if you need further assistance in this matter. I will be happy to help.

Best regards,
Prosenjit

March 25, 2024 at 10:40 pm #15449163

Maximilian Wellner

Regarding the question about using Classic Translation Editor - If you go to "WPML > Settings", under "Translation Editor" you should see the option to change the editor to "Classic Translation Editor". If the option appears disabled, the Automatic Translation might be enabled on your site. Please change the "Translation Mode" to "Translate What you Choose" from WPML Settings and check again.

this is already set , but still not working. can you check pls?

text "Sofortüberweisung" in one of the WooCommerce Payment gateways,

can't find this string anywhere, it is from an old plugin

March 26, 2024 at 1:55 pm #15451630

Prosenjit Barman
WPML Supporter since 03/2023

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hi There,
Thank you for the update.

I would like to request temporary access (wp-admin and FTP) to your site to take a closser look at the issue. It would be better to have a testing site where the issue is replicated.

You will find the needed fields below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it.

Maybe I'll need to replicate your site locally. For this, I’ll need to temporarily install a plugin called “Duplicator” or "All in One WP Migration" on your site. This will allow me to create a copy of your site and your content. Once the problem is resolved I will delete the local site. Let me know if this is ok with you.

IMPORTANT
-Please backup site files and database before providing us access.
-If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields. If you do not, please ask me to enable the private box. The private box looks like this:
hidden link

Looking forward to your response.

Best Regards,
Prosenjit

March 26, 2024 at 3:31 pm #15452030

Prosenjit Barman
WPML Supporter since 03/2023

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hi There,
Thank you for sharing the access information.

The error notice that appears on the backend about translating the Strings is solved now. It happens due to some issues in the Database table. I removed the 'wpml_notices' key from the `_options` table which effectively solves the issue. Please check the ticket below to get a brief understanding of what I've done.

- https://wpml.org/forums/topic/invalid-data-in-the-database/#post-10838029

Adding translation using Classic Translation Editor - I opened the Homepage in the default Editor and found that all the translations were in the 'in-progress' state. When I clicked the gear icon(hidden link) to see the translation editor, I found that the classic translation editor was loaded correctly. Please check this screenshot: hidden link

If the Classic Translation editor is selected in the backend, then it is not required to select any button or option at the time of adding translation. The Editor should be loaded correctly. If the correct editor is still not loading, please clear the caches from your site and browser then check again.

I hope it will help. Please feel free to let me know if you need further assistance in this matter. I will be happy to help.

Best regards,
Prosenjit

March 26, 2024 at 3:33 pm #15452046

Maximilian Wellner

the thing is, I want to edit the translations in the wp bakery page builder view, too.

March 27, 2024 at 3:14 am #15453418

Prosenjit Barman
WPML Supporter since 03/2023

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hi,

I understand what you're looking for. It seems the Translated pages were created manually first and later they were connected with the default page using the "Connect with translations" feature, as mentioned in this guide: https://wpml.org/faq/how-to-link-already-translated-pages/

Which is why, the button to switch to the WordPress editor wasn't showing. I disconnected the English translation and now, the buttons are showing correctly. Please check this screenshot: hidden link

You can now add translation using the WordPress Editor. As I have disconnected the English translation, please retranslate the default page into English.

Let me know if that helps or if there is anything else you need help with. I will be happy to assist.

Best regards,
Prosenjit

March 27, 2024 at 2:06 pm #15456171

Maximilian Wellner

can you do this for all languages on the home page please? Dutch for example is still not working

March 28, 2024 at 4:43 am #15458689

Prosenjit Barman
WPML Supporter since 03/2023

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hi There,

I canceled all the in-progress jobs from "WPML > Translation Management > Jobs" and now you can manually translate the Homepage into Dutch and other languages.

Here is how you can cancel the in-progress jobs on your own: https://wpml.org/documentation/translating-your-contents/#how-to-cancel-translation-jobs

Let me know if there is anything else you need help with. I'll be happy to assist.

Best regards,
Prosenjit

March 29, 2024 at 7:01 pm #15465521

Maximilian Wellner

I manually retranslated dutch on the home page, but somehow there is a bug. The dutch version seems not to be set as home page

April 1, 2024 at 4:05 am #15467953

Prosenjit Barman
WPML Supporter since 03/2023

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hi There,
I hope you're doing well. Sorry for the delay in responding due to the weekend.

Since the default language of your site is set to German, that's the version I initially saw upon visiting. However, upon switching to Dutch (Nederlands), I noticed the Dutch version of the homepage with Dutch contents loads properly without any problems. For a clearer picture, please refer to this video: hidden link

Could you elaborate on the specific issue you're encountering with the Dutch version? If you can create a video illustrating the problem or some screenshots detailing the issue and share in your next response, it would greatly help in comprehending the situation and providing targeted support.

Looking forward to your response.

Best regards,
Prosenjit

The topic ‘[Closed] error’ is closed to new replies.