Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [19-Aug-2025 11:31:59 UTC] WordPress database error Illegal mix of collations for operation 'UNION' for query (
- 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, translations.element_id, 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 abion_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 abion_icl_translation_status translation_status
- INNER JOIN abion_icl_translations translations
- ON translations.translation_id = translation_status.translation_id INNER JOIN abion_icl_translations original_translations
- ON original_translations.trid = translations.trid AND original_translations.language_code = translations.source_language_code INNER JOIN (
- SELECT *
- FROM abion_icl_translate_job as translate_job
- WHERE job_id = (
- SELECT MAX(job_id) AS job_id
- FROM abion_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 abion_posts posts ON posts.ID = original_translations.element_id LEFT JOIN abion_icl_languages source_languages
- ON source_languages.code = translations.source_language_code LEFT JOIN abion_icl_languages target_languages
- ON target_languages.code = translations.language_code INNER JOIN abion_icl_translation_batches batches
- ON batches.id = translation_status.batch_id WHERE original_translations.element_type LIKE 'post%' AND translation_status.status != 0 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, translations.element_id, 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 abion_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 abion_icl_translation_status translation_status
- INNER JOIN abion_icl_translations translations
- ON translations.translation_id = translation_status.translation_id INNER JOIN abion_icl_translations original_translations
- ON original_translations.trid = translations.trid AND original_translations.language_code = translations.source_language_code INNER JOIN (
- SELECT *
- FROM abion_icl_translate_job as translate_job
- WHERE job_id = (
- SELECT MAX(job_id) AS job_id
- FROM abion_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 abion_icl_string_packages string_packages
- ON string_packages.ID = original_translations.element_id LEFT JOIN abion_icl_languages source_languages
- ON source_languages.code = translations.source_language_code LEFT JOIN abion_icl_languages target_languages
- ON target_languages.code = translations.language_code INNER JOIN abion_icl_translation_batches batches
- ON batches.id = translation_status.batch_id WHERE original_translations.element_type LIKE 'package%' AND translation_status.status != 0 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, translations.element_id, 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 abion_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 abion_icl_translation_status translation_status
- INNER JOIN abion_icl_translations translations
- ON translations.translation_id = translation_status.translation_id INNER JOIN abion_icl_translations original_translations
- ON original_translations.trid = translations.trid AND original_translations.language_code = translations.source_language_code INNER JOIN (
- SELECT *
- FROM abion_icl_translate_job as translate_job
- WHERE job_id = (
- SELECT MAX(job_id) AS job_id
- FROM abion_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 abion_icl_translation_batches translation_batches ON translation_batches.id = original_translations.element_id LEFT JOIN abion_icl_languages source_languages
- ON source_languages.code = translations.source_language_code LEFT JOIN abion_icl_languages target_languages
- ON target_languages.code = translations.language_code INNER JOIN abion_icl_translation_batches batches
- ON batches.id = translation_status.batch_id WHERE original_translations.element_type = 'st-batch_strings' AND translation_status.status != 0 AND translation_status.status != '42' ) ORDER BY id desc LIMIT 20 made by 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_REST_Jobs->get_jobs, WPML_TM_Jobs_Repository->get
Advertisement
Add Comment
Please, Sign In to add comment