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 1 reply, has 2 voices.

Last updated by Carlos Rojas 2 years ago.

Assisted by: Carlos Rojas.

Author Posts
April 18, 2022 at 11:06 pm #11040877

John

Hello,
We have e issue with your plugin and this one, WP JobSearch by Eyecix (hidden link). He is creating an error_log. Attached is a photo where you will find a part of the error code hidden link
Also I have copy and pasted here, half of the error message
Waiting for your replay,
Thank you!

SELECT
translation_status.rid AS id, 'post' AS type, translation_status.tp_id AS tp_id, batches.id AS local_batch_id, batches.tp_id AS tp_batch_id, batches.batch_name, translation_status.status AS status, original_translations.element_id AS original_element_id, translations.source_language_code AS source_language, translations.language_code AS target_language, translations.trid, translations.element_type, translation_status.translation_service AS translation_service, translation_status.timestamp AS sent_date, translate_job.deadline_date AS deadline_date, translate_job.completed_date AS completed_date, posts.post_title AS title, source_languages.english_name AS source_language_name, target_languages.english_name AS target_language_name, translate_job.translator_id AS translator_id, translate_job.job_id AS translate_job_id, translation_status.tp_revision AS revision, translation_status.ts_status AS ts_status, translation_status.needs_update AS needs_update, translate_job.editor AS editor, (
SELECT COUNT(job_id)
FROM pro_icl_translate_job as copmpleted_translation_job
WHERE copmpleted_translation_job.rid = translation_status.rid AND copmpleted_translation_job.translated = 1
) > 0 AS has_completed_translation, translate_job.editor_job_id AS editor_job_id, translate_job.automatic AS automatic, translate_job.title AS job_title, translation_status.review_status AS review_status
FROM pro_icl_translation_status translation_status
INNER JOIN pro_icl_translations translations
ON translations.translation_id = translation_status.translation_id INNER JOIN pro_icl_translations original_translations
ON original_translations.trid = translations.trid AND original_translations.language_code = translations.source_language_code INNER JOIN (
SELECT *
FROM pro_icl_translate_job as translate_job
WHERE job_id = (
SELECT MAX(job_id) AS job_id
FROM pro_icl_translate_job as sub_translate_job
WHERE sub_translate_job.rid = translate_job.rid
)
) AS translate_job ON translate_job.rid = translation_status.rid INNER JOIN pro_posts posts ON posts.ID = original_translations.element_id LEFT JOIN pro_icl_languages source_languages
ON source_languages.code = translations.source_language_code LEFT JOIN pro_icl_languages target_languages
ON target_languages.code = translations.language_code INNER JOIN pro_icl_translation_batches batches
ON batches.id = translation_status.batch_id WHERE original_translations.element_type LIKE 'post%' AND translation_status.status IN (40) AND translation_status.translation_service = 'local' AND translation_status.status != '42' ) UNION (
SELECT
translation_status.rid AS id, 'package' AS type, translation_status.tp_id AS tp_id, batches.id AS local_batch_id, batches.tp_id AS tp_batch_id, batches.batch_name, translation_status.status AS status, original_translations.element_id AS original_element_id, translations.source_language_code AS source_language, translations.language_code AS target_language, translations.trid, translations.element_type, translation_status.translation_service AS translation_service, translation_status.timestamp AS sent_date, translate_job.deadline_date AS deadline_date, translate_job.completed_date AS completed_date, string_packages.title AS title, source_languages.english_name AS source_language_name, target_languages.english_name AS target_language_name, translate_job.translator_id AS translator_id, translate_job.job_id AS translate_job_id, translation_status.tp_revision AS revision, translation_status.ts_status AS ts_status, translation_status.needs_update AS needs_update, translate_job.editor AS editor, (
SELECT COUNT(job_id)
FROM pro_icl_translate_job as copmpleted_translation_job
WHERE copmpleted_translation_job.rid = translation_status.rid AND copmpleted_translation_job.translated = 1
) > 0 AS has_completed_translation, translate_job.editor_job_id AS editor_job_id, translate_job.automatic AS automatic, translate_job.title AS job_title, translation_status.review_status AS review_status
FROM pro_icl_translation_status translation_status
INNER JOIN pro_icl_translations translations
ON translations.translation_id = translation_status.translation_id INNER JOIN pro_icl_translations original_translations
ON original_translations.trid = translations.trid AND original_translations.language_code = translations.source_language_code INNER JOIN (
SELECT *
FROM pro_icl_translate_job as translate_job
WHERE job_id = (
SELECT MAX(job_id) AS job_id
FROM pro_icl_translate_job as sub_translate_job
WHERE sub_translate_job.rid = translate_job.rid
)
) AS translate_job ON translate_job.rid = translation_status.rid INNER JOIN pro_icl_string_packages string_packages
ON string_packages.ID = original_translations.element_id LEFT JOIN pro_icl_languages source_languages
ON source_languages.code = translations.source_language_code LEFT JOIN pro_icl_languages target_languages
ON target_languages.code = translations.language_code INNER JOIN pro_icl_translation_batches batches
ON batches.id = translation_status.batch_id WHERE original_translations.element_type LIKE 'package%' AND translation_status.status IN (40) AND translation_status.translation_service = 'local' AND translation_status.status != '42' ) UNION (
SELECT
translation_status.rid AS id, 'st-batch_strings' AS type, translation_status.tp_id AS tp_id, batches.id AS local_batch_id, batches.tp_id AS tp_batch_id, batches.batch_name, translation_status.status AS status, original_translations.element_id AS original_element_id, translations.source_language_code AS source_language, translations.language_code AS target_language, translations.trid, translations.element_type, translation_status.translation_service AS translation_service, translation_status.timestamp AS sent_date, translate_job.deadline_date AS deadline_date, translate_job.completed_date AS completed_date, translation_batches.batch_name AS title, source_languages.english_name AS source_language_name, target_languages.english_name AS target_language_name, translate_job.translator_id AS translator_id, translate_job.job_id AS translate_job_id, translation_status.tp_revision AS revision, translation_status.ts_status AS ts_status, translation_status.needs_update AS needs_update, translate_job.editor AS editor, (
SELECT COUNT(job_id)
FROM pro_icl_translate_job as copmpleted_translation_job
WHERE copmpleted_translation_job.rid = translation_status.rid AND copmpleted_translation_job.translated = 1
) > 0 AS has_completed_translation, translate_job.editor_job_id AS editor_job_id, translate_job.automatic AS automatic, translate_job.title AS job_title, translation_status.review_status AS review_status
FROM pro_icl_translation_status translation_status
INNER JOIN pro_icl_translations translations
ON translations.translation_id = translation_status.translation_id INNER JOIN pro_icl_translations original_translations
ON original_translations.trid = translations.trid AND original_translations.language_code = translations.source_language_code INNER JOIN (
SELECT *
FROM pro_icl_translate_job as translate_job
WHERE job_id = (
SELECT MAX(job_id) AS job_id
FROM pro_icl_translate_job as sub_translate_job
WHERE sub_translate_job.rid = translate_job.rid
)
) AS translate_job ON translate_job.rid = translation_status.rid INNER JOIN pro_icl_translation_batches translation_batches ON translation_batches.id = original_translations.element_id LEFT JOIN pro_icl_languages source_languages
ON source_languages.code = translations.source_language_code LEFT JOIN pro_icl_languages target_languages
ON target_languages.code = translations.language_code INNER JOIN pro_icl_translation_batches batches
ON batches.id = translation_status.batch_id WHERE original_translations.element_type = 'st-batch_strings' AND translation_status.status IN (40) AND translation_status.translation_service = 'local' AND translation_status.status != '42' ) efectuată de require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\Retry->retry, WPML\TM\ATE\Retry\Process->run, WPML\TM\ATE\Retry\Process->runRetryInit, WPML\TM\ATE\Retry\Process->getWpmlJobIdsToRetry, WPML_TM_ATE_Job_Repository->get_jobs_to_retry, WPML_TM_Jobs_Repository->get

April 19, 2022 at 12:15 am #11040945

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

Hello,
Thank you for contacting us

The plugin WP JobSearch doesn't appear in our Multilingual-Ready Plugins list, you can double-check it here: https://wpml.org/plugin/ This means that our compatibility team hasn't validated it yet.

I would recommend you to contact the authors of the plugin and ask them to check the error you are getting and invite them to join our Go Global Program at this link: https://wpml.org/documentation/support/go-global-program/ where they will be able to get in contact with our compatibility specialists directly and solve any conflict that might exist.

Regards,
Carlos

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