Guest User

Untitled

a guest
Aug 19th, 2025
17
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.41 KB | None | 0 0
  1. [19-Aug-2025 11:31:59 UTC] WordPress database error Illegal mix of collations for operation 'UNION' for query (
  2. SELECT
  3. 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, (
  4. SELECT COUNT(job_id)
  5. FROM abion_icl_translate_job as copmpleted_translation_job
  6. WHERE copmpleted_translation_job.rid = translation_status.rid AND copmpleted_translation_job.translated = 1
  7. ) > 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
  8. FROM abion_icl_translation_status translation_status
  9. INNER JOIN abion_icl_translations translations
  10. ON translations.translation_id = translation_status.translation_id INNER JOIN abion_icl_translations original_translations
  11. ON original_translations.trid = translations.trid AND original_translations.language_code = translations.source_language_code INNER JOIN (
  12. SELECT *
  13. FROM abion_icl_translate_job as translate_job
  14. WHERE job_id = (
  15. SELECT MAX(job_id) AS job_id
  16. FROM abion_icl_translate_job as sub_translate_job
  17. WHERE sub_translate_job.rid = translate_job.rid
  18. )
  19. ) 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
  20. ON source_languages.code = translations.source_language_code LEFT JOIN abion_icl_languages target_languages
  21. ON target_languages.code = translations.language_code INNER JOIN abion_icl_translation_batches batches
  22. 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 (
  23. SELECT
  24. 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, (
  25. SELECT COUNT(job_id)
  26. FROM abion_icl_translate_job as copmpleted_translation_job
  27. WHERE copmpleted_translation_job.rid = translation_status.rid AND copmpleted_translation_job.translated = 1
  28. ) > 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
  29. FROM abion_icl_translation_status translation_status
  30. INNER JOIN abion_icl_translations translations
  31. ON translations.translation_id = translation_status.translation_id INNER JOIN abion_icl_translations original_translations
  32. ON original_translations.trid = translations.trid AND original_translations.language_code = translations.source_language_code INNER JOIN (
  33. SELECT *
  34. FROM abion_icl_translate_job as translate_job
  35. WHERE job_id = (
  36. SELECT MAX(job_id) AS job_id
  37. FROM abion_icl_translate_job as sub_translate_job
  38. WHERE sub_translate_job.rid = translate_job.rid
  39. )
  40. ) AS translate_job ON translate_job.rid = translation_status.rid INNER JOIN abion_icl_string_packages string_packages
  41. ON string_packages.ID = original_translations.element_id LEFT JOIN abion_icl_languages source_languages
  42. ON source_languages.code = translations.source_language_code LEFT JOIN abion_icl_languages target_languages
  43. ON target_languages.code = translations.language_code INNER JOIN abion_icl_translation_batches batches
  44. 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 (
  45. SELECT
  46. 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, (
  47. SELECT COUNT(job_id)
  48. FROM abion_icl_translate_job as copmpleted_translation_job
  49. WHERE copmpleted_translation_job.rid = translation_status.rid AND copmpleted_translation_job.translated = 1
  50. ) > 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
  51. FROM abion_icl_translation_status translation_status
  52. INNER JOIN abion_icl_translations translations
  53. ON translations.translation_id = translation_status.translation_id INNER JOIN abion_icl_translations original_translations
  54. ON original_translations.trid = translations.trid AND original_translations.language_code = translations.source_language_code INNER JOIN (
  55. SELECT *
  56. FROM abion_icl_translate_job as translate_job
  57. WHERE job_id = (
  58. SELECT MAX(job_id) AS job_id
  59. FROM abion_icl_translate_job as sub_translate_job
  60. WHERE sub_translate_job.rid = translate_job.rid
  61. )
  62. ) 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
  63. ON source_languages.code = translations.source_language_code LEFT JOIN abion_icl_languages target_languages
  64. ON target_languages.code = translations.language_code INNER JOIN abion_icl_translation_batches batches
  65. 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
  66.  
Advertisement
Add Comment
Please, Sign In to add comment