Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client is unable to see certain posts or pages in the translation queue, and sometimes parts of a 100% translated page are missing when reopened. Additionally, there is an issue with adding a new translation for a plugin with a custom post type, as the translation management page does not list the page.

Solution:
Firstly, ensure that you are set as a local translator with the correct language pairs. You can then select the page for translation under WPML > Translation Management and proceed to translate it in WPML > Translations. For detailed instructions, refer to our documentation on setting up local translators and language pairs.

If the issue persists, it may be due to database corruption. We have fixed this for the client by deleting the problematic entries in the icl_translations table and resetting the language information for the affected post. After these steps, the post should be translatable again. For more information on language and translation tables, please see our documentation on WPML tables.

If this solution does not seem relevant to your issue, please open a new support ticket in our WPML support forum.

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.

Tagged: 

This topic contains 11 replies, has 2 voices.

Last updated by Long Nguyen 1 year, 7 months ago.

Assisted by: Long Nguyen.

Author Posts
November 21, 2023 at 10:45 am #14885617

yvonneR-7

Tell us what you are trying to achieve?

When I try to translate a post or page, the translation doesn't always appear in the translation queue, making it impossible to proceed with the translation.

Furthermore, it frequently happens that a page is 100% translated. However, when I reopen the translation, a part of it is missing. Often, it's also not possible to complete the translation, even though it shows 100% translated.

Is there a similar example that we can see?
hidden link

What is the link to your website?
hidden link

November 22, 2023 at 5:18 am #14892725

Long Nguyen
WPML Supporter since 02/2022

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi Yvonne,

Thank you for contacting WPML support, I'd be happy to help you with this issue.

Please ensure you are a local translator and have the correct language pair. Then go to:
- WPML > Translation Management > Select the page and send it to translation.
- WPML > Translations > Take the job and translate it.
Refer documentation https://wpml.org/documentation/translating-your-contents/how-to-set-up-local-translators-and-language-pairs/#adding-local-translators-through-translation-management

If it does not work, please share some screenshots of that issue on your end.

Look forward to your reply.
Thanks

November 22, 2023 at 9:14 am #14894179

yvonneR-7

Hello,
we have set up the translators as described.

Right now it is not possible to add a new translation for a plugin with a custom post type.
When clicking on the + icon for the entry "18" the translation management page is shown, but the page is not listed.

The only thing i find in the logs is the following warning
[22-Nov-2023 08:49:34 UTC] PHP Deprecated: WP_Text_Diff_Renderer_Table::__isset(): The property `_base64` is not declared. Checking `isset()` on a dynamic property is deprecated since version 6.4.0! Instead, declare the property on the class. in /sites/kirchdorfer.web-email.at/files/wp-includes/functions.php on line 6031

We have
Wordpress 6.4.1
WPML Version 4.6.7
WPML Media Version 2.7.3
WPML SEO Version 2.1.0
WPML String Translation Version 3.2.8

We can provide access to the page if that helps.

This is the site health report
`
### wp-core ###

version: 6.4.1
site_language: de_DE
user_language: de_DE
timezone: Europe/Vienna
permalink: /%postname%/
https_status: true
multisite: false
user_registration: 0
blog_public: 0
default_comment_status: open
environment_type: production
user_count: 6
dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: /sites/kirchdorfer.web-email.at/files
wordpress_size: 69,92 MB (73319983 bytes)
uploads_path: /sites/kirchdorfer.web-email.at/files/wp-content/uploads
uploads_size: 1,82 GB (1956519488 bytes)
themes_path: /sites/kirchdorfer.web-email.at/files/wp-content/themes
themes_size: 8,32 MB (8726633 bytes)
plugins_path: /sites/kirchdorfer.web-email.at/files/wp-content/plugins
plugins_size: 199,10 MB (208772236 bytes)
database_size: 106,08 MB (111230976 bytes)
total_size: 2,20 GB (2358569316 bytes)

### wp-dropins (1) ###

object-cache.php: true

### wp-active-theme ###

name: THEME
version: 1.0.0
author:
author_website:
parent_theme: none
theme_features: core-block-patterns, widgets-block-editor, title-tag, post-thumbnails, menus, html5, custom-background, customize-selective-refresh-widgets, custom-logo, widgets
theme_path: /sites/kirchdorfer.web-email.at/files/wp-content/themes/kirchdorfer
auto_update: Deaktiviert

### wp-themes-inactive (1) ###

Twenty Twenty-Four: version: 1.0, author: Das WordPress-Team, Automatische Aktualisierungen deaktiviert

### wp-mu-plugins (1) ###

SpinupWP Debug Log Path: version: 1.0, author: SpinupWP

### wp-plugins-active (27) ###

3D FlipBook : Dflip Lite: version: 2.0.86, author: DearHive, Automatische Aktualisierungen deaktiviert
ACF Content Analysis for Yoast SEO: version: 3.1, author: Thomas Kräftner, ViktorFroberg, marol87, pekz0r, angrycreative, Team Yoast, Automatische Aktualisierungen deaktiviert
Advanced Custom Fields Multilingual: version: 2.0.5, author: OnTheGoSystems, Automatische Aktualisierungen deaktiviert
Advanced Custom Fields PRO: version: 6.2.3, author: WP Engine, Automatische Aktualisierungen deaktiviert
Ajax Search Lite: version: 4.11.4, author: Ernest Marcinko, Automatische Aktualisierungen deaktiviert
Flockler: version: 1.0.3, author: Flockler, Automatische Aktualisierungen deaktiviert
Gravity Forms: version: 2.7.17, author: Gravity Forms, Automatische Aktualisierungen aktiviert
Gravity Forms Multilingual: version: 1.7.2, author: OnTheGoSystems, Automatische Aktualisierungen deaktiviert
Gravity Forms Signature Add-On: version: 4.6.0, author: Gravity Forms, Automatische Aktualisierungen deaktiviert
Gravity Forms Zero Spam: version: 1.4.1, author: GravityKit, Automatische Aktualisierungen deaktiviert
GTM4WP: version: 1.18.1, author: Thomas Geiger, Automatische Aktualisierungen deaktiviert
deaktiviert
LuckyWP ACF Menu Field: version: 1.0, author: LuckyWP, Automatische Aktualisierungen deaktiviert
Redirection: version: 5.3.10, author: John Godley, Automatische Aktualisierungen deaktiviert
Regenerate Thumbnails: version: 3.1.6, author: Alex Mills (Viper007Bond), Automatische Aktualisierungen deaktiviert
WordPress fancy XMAS-Calendar: version: 1.0.0, author:, Automatischen
WP All Import - ACF Add-On: version: 3.3.8, author: Soflyy, Automatische Aktualisierungen deaktiviert
WP All Import Pro: version: 4.8.0, author: Soflyy, Automatische Aktualisierungen deaktiviert
WP Mail SMTP: version: 3.10.0, author: WP Mail SMTP, Automatische Aktualisierungen deaktiviert
WPML Media: version: 2.7.3, author: OnTheGoSystems, Automatische Aktualisierungen deaktiviert
WPML Multilingual CMS: version: 4.6.7, author: OnTheGoSystems, Automatische Aktualisierungen deaktiviert
WPML SEO: version: 2.1.0, author: OnTheGoSystems, Automatische Aktualisierungen deaktiviert
WPML String Translation: version: 3.2.8, author: OnTheGoSystems, Automatische Aktualisierungen deaktiviert
Wrap Form Fields In Gravity Forms: version: 0.1.1, author: Mikkel Rommelhoff, Automatische Aktualisierungen deaktiviert
Yoast Duplicate Post: version: 4.5, author: Enrico Battocchi & Team Yoast, Automatische Aktualisierungen deaktiviert
Yoast SEO: version: 21.5, author: Team Yoast, Automatische Aktualisierungen deaktiviert

### wp-plugins-inactive (5) ###

Advanced Custom Fields: version: 6.2.3, author: WP Engine, Automatische Aktualisierungen deaktiviert
OTGS Installer: version: 3.1.1, author: OnTheGoSystems, Automatische Aktualisierungen deaktiviert
SpinupWP: version: 1.5.1, author: SpinupWP, Automatische Aktualisierungen deaktiviert
WPML All Import: version: 2.3.0, author: OnTheGoSystems, Automatische Aktualisierungen deaktiviert
WP Rocket: version: 3.12.4, author: WP Media, Automatische Aktualisierungen deaktiviert

### wp-media ###

image_editor: WP_Image_Editor_Imagick
imagick_module_version: 1691
imagemagick_version: ImageMagick 6.9.11-60 Q16 x86_64 2021-01-25 hidden link
imagick_version: 3.7.0
file_uploads: 1
post_max_size: 64M
upload_max_filesize: 64M
max_effective_size: 64 MB
max_file_uploads: 20
imagick_limits:
imagick::RESOURCETYPE_AREA: 122 MB
imagick::RESOURCETYPE_DISK: 1073741824
imagick::RESOURCETYPE_FILE: 768
imagick::RESOURCETYPE_MAP: 512 MB
imagick::RESOURCETYPE_MEMORY: 256 MB
imagick::RESOURCETYPE_THREAD: 1
imagick::RESOURCETYPE_TIME: 9.2233720368548E+18
imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, AVI, AVIF, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, FAX, FILE, FITS, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, H, HALD, HDR, HEIC, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPG, MRW, MSL, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMV, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV
gd_version: 2.3.3
gd_formats: GIF, JPEG, PNG, WebP, BMP, XPM
ghostscript_version: unknown

### wp-server ###

server_architecture: Linux 5.15.0-88-generic x86_64
httpd_software: nginx/1.24.0
php_version: 8.0.30 64bit
php_sapi: fpm-fcgi
max_input_variables: 1000
time_limit: 600
memory_limit: 1G
max_input_time: 600
upload_max_filesize: 64M
php_post_max_size: 64M
curl_version: 7.81.0 OpenSSL/3.0.2
suhosin: false
imagick_availability: true
pretty_permalinks: true
current: 2023-11-22T09:08:16+00:00
utc-time: Wednesday, 22-Nov-23 09:08:16 UTC
server-time: 2023-11-22T10:08:13+01:00

### wp-database ###

extension: mysqli
server_version: 8.0.34-26
client_version: mysqlnd 8.0.30
max_allowed_packet: 52428800
max_connections: 2000

### wp-constants ###

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /sites/kirchdorfer.web-email.at/files/wp-content
WP_PLUGIN_DIR: /sites/kirchdorfer.web-email.at/files/wp-content/plugins
WP_MEMORY_LIMIT: 256M
WP_MAX_MEMORY_LIMIT: 1G
WP_DEBUG: true
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: true
SCRIPT_DEBUG: false
WP_CACHE: false
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: Nicht definiert
WP_DEVELOPMENT_MODE: undefined
DB_CHARSET: utf8mb4
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable

### wp_mail_smtp ###

version: 3.10.0
license_key_type: lite
debug: Keine Debug-Hinweise gefunden.
lite_install_date: Jun 16, 2023 @ 8:13am

Screenshot 2023-11-22 at 10.05.33.png
Screenshot 2023-11-22 at 10.04.42.png
November 22, 2023 at 9:46 am #14894883

Long Nguyen
WPML Supporter since 02/2022

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

The page WPML > Translations will show the list of jobs. When you click on the Plus icon in the table list of the post type, it does not create the job and won't display on the Translations page.
Please follow steps I mentioned above to add a new job to translate the post type.

- WPML > Translation Management > Select the post "18" and send it to translation.
- WPML > Translations > Take the job and translate it.

If it still does not work, I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. Your next reply is set to private to share the info.

❌ IMPORTANT: Please backup your database and website before proceeding ❌
You can use this plugin to create the backup: https://wordpress.org/plugins/duplicator/

Look forward to your reply.
Thanks

November 22, 2023 at 1:32 pm #14898223

yvonneR-7

Backup was created without the duplicator plugin.
You can modify the plugin or content as you like

November 23, 2023 at 1:48 am #14903169

Long Nguyen
WPML Supporter since 02/2022

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

It is a database corruption issue and I've fixed that issue on your site. Now you can translate post 18 properly, please check the screenshot attached.

Regarding the translation manager, the administrator is the translation manager, no need to set them up. For other users, they must have at least Editor-level permissions to set up a translation manager. Please follow the documentation
https://wpml.org/documentation/translating-your-contents/working-with-translation-managers/#setting-up-a-translation-manager

We can handle one issue per ticket only, if you have another issue, please open a new ticket for that. Our support team will help you with our best.

Look forward to your reply.
Thanks

Translations ‹ Kirchdorfer — WordPress 2023-11-23 08-41-30.png
November 23, 2023 at 6:51 am #14903763

yvonneR-7

Hello,
thank you for the fix.
Could you point out where the issue was in the database?
Maybe this helps to solve further issues by ourself.

Thanks

November 23, 2023 at 7:26 am #14904005

Long Nguyen
WPML Supporter since 02/2022

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

You can read more about the language and translation table in the documentation https://wpml.org/documentation/support/wpml-tables/#language-information-and-translations

The post 18 has ID 23, when you access the database, table icl_translations and search for element ID 23, you will see the translation ID group "trid".
Search for the trid, you will see the post and its translation has different element IDs and the same trid. But on your site, the element ID of the translation is NULL, which is not correct.

Then I did steps below to fix this:

- Delete two entries in the table icl_translations (post 18 and its translation).
- Now the post 18 does not have a language, I go to WPML > Support > Troubleshooting > Click on the button "Set language information" to set the default language for post 18.
- Re-translate the post and it works properly.

I hope I was helpful. Don't hesitate to ask if you find any problem along the way, I'll gladly help you.

November 23, 2023 at 8:29 am #14904575

yvonneR-7

We need assistance with Advent calendar doors 3 and 15, we're encountering the same issue again.

Thanks.

Bildschirm­foto 2023-11-23 um 09.28.48.png
November 23, 2023 at 9:14 am #14905255

Long Nguyen
WPML Supporter since 02/2022

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

I fixed the issue with two posts and the same steps above. You can see the issue in the screenshot attached.

Thanks.

kirchdorfer.web-email.at : Signon test : kirchdorfer-stage : o71_icl_translations | phpMyAdmin 5.2.1 2023-11-23 16-11-42.png
November 23, 2023 at 9:33 am #14905539

yvonneR-7

Thank you,
how does this happen?
It seems this could be a bug in the plugin, as this is recurring while working in the backend

November 24, 2023 at 1:16 am #14912729

Long Nguyen
WPML Supporter since 02/2022

Languages: English (English )

Timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Hi,

As I mentioned above (https://wpml.org/forums/topic/translation-does-not-appear-in-the-translation-queue/#post-14903169)
it's the database issue, not come from the source code. And honesty, I'm not sure how this happened but I know how to fix this. It won't happen again for new posts and translations.

If you see another post has the same issue, please let me know. I will take a backup of your database and ask our 2nd tier support about this.

Thanks.