Este es el foro de soporte técnico de WPML, el plugin multilingüe de WordPress.
Todas las personas pueden leerlo pero solo los clientes de WPML pueden ingresar comentarios. El equipo de WPML responde en los foros 6 días a la semana, 22 horas por día.
Log error de base de datos
SELECT COUNT(task_id)
FROM wp_icl_background_task
WHERE task_status IN ('1','0','2')
AND 1=1
Unknown
Unknown Table 'wp_produccion.wp_icl_background_task' doesn't exist qmdb
SELECT *
FROM wp_icl_background_task
WHERE task_status IN ('1','0','2')
AND 1=1
Unknown
Unknown Table 'wp_produccion.wp_icl_background_task' doesn't exist qmdb
SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status, translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding
FROM wp_icl_translate_job as jobs
INNER JOIN wp_icl_translation_status translation_status
ON translation_status.rid = jobs.rid
INNER JOIN wp_icl_translations translations
ON translation_status.translation_id = translations.translation_id
INNER JOIN wp_icl_translations parent_translations
ON translations.trid = parent_translations.trid
AND parent_translations.source_language_code IS NULL
LEFT JOIN wp_posts posts
ON parent_translations.element_id = posts.ID
WHERE jobs.job_id IN (
SELECT MAX(job_id)
FROM wp_icl_translate_job
GROUP BY rid )
AND jobs.editor = 'ate'
AND ( translation_status.status IN (1,2,40)
OR 1=0 )
AND translations.language_code IN ('en','es')
AND ( posts.post_status IS NULL
OR posts.post_status <> 'trash' )
Unknown
Unknown Unknown column 'jobs.automatic' in 'field list' qmdb
SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status, translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding
FROM wp_icl_translate_job as jobs
INNER JOIN wp_icl_translation_status translation_status
ON translation_status.rid = jobs.rid
INNER JOIN wp_icl_translations translations
ON translation_status.translation_id = translations.translation_id
INNER JOIN wp_icl_translations parent_translations
ON translations.trid = parent_translations.trid
AND parent_translations.source_language_code IS NULL
LEFT JOIN wp_posts posts
ON parent_translations.element_id = posts.ID
WHERE jobs.job_id IN (
SELECT MAX(job_id)
FROM wp_icl_translate_job
GROUP BY rid )
AND jobs.editor = 'ate'
AND ( translation_status.status IN (30)
OR translation_status.review_status IN ( 'NEEDS_REVIEW','EDITING' ) )
AND translations.language_code IN ('en','es')
AND ( posts.post_status IS NULL
OR posts.post_status <> 'trash' )
Unknown
Unknown Unknown column 'jobs.automatic' in 'field list' qmdb
SELECT j.rid, j.translator_id, t.translation_id, s.batch_id, j.translated, j.manager_id, s.status, s.review_status, s.needs_update, s.translation_service, s.uuid, s.ate_comm_retry_count, t.trid, t.language_code, t.source_language_code, iclt.field_data AS original_doc_id, iclt.job_id, ito.element_type AS original_post_type, j.title, j.deadline_date, j.completed_date, j.editor, j.editor_job_id, j.automatic, SUBSTRING_INDEX(ito.element_type, '_', 1 ) as element_type_prefix
FROM wp_icl_translate_job j JOIN wp_icl_translation_status s
ON j.rid = s.rid JOIN wp_icl_translations t
ON s.translation_id = t.translation_id JOIN wp_icl_translate iclt
ON iclt.job_id = j.job_id JOIN wp_icl_translations ito
ON ito.element_id = iclt.field_data
AND ito.trid = t.trid
LEFT JOIN wp_posts p
ON ito.element_id = p.ID
AND ito.element_type = CONCAT('post_', p.post_type)
WHERE j.job_id IN (38)
AND iclt.field_type = 'original_id'
LIMIT 1
Unknown
Unknown Unknown column 's.review_status' in 'field list' qmdb
SELECT translation_status.status, languages.code, translation_status.translator_id, translation_status.translation_service, translation_status.needs_update, translations.trid, translate_job.job_id, translate_job.editor, translate_job.automatic
FROM wp_icl_languages languages
LEFT JOIN wp_icl_translations translations
ON languages.code = translations.language_code JOIN wp_icl_translation_status translation_status
ON translations.translation_id = translation_status.translation_id JOIN wp_icl_translate_job translate_job
ON translate_job.rid = translation_status.rid
AND translate_job.revision IS NULL
WHERE languages.active = 1
AND translations.trid IN ( '43621' )
OR translations.trid IS NULL
Unknown
Unknown Unknown column 'translate_job.automatic' in 'field list' qmdb
SELECT translation_status.status, languages.code, translation_status.translator_id, translation_status.translation_service, translation_status.needs_update, translations.trid, translate_job.job_id, translate_job.editor, translate_job.automatic
FROM wp_icl_languages languages
LEFT JOIN wp_icl_translations translations
ON languages.code = translations.language_code JOIN wp_icl_translation_status translation_status
ON translations.translation_id = translation_status.translation_id JOIN wp_icl_translate_job translate_job
ON translate_job.rid = translation_status.rid
AND translate_job.revision IS NULL
WHERE languages.active = 1
AND translations.trid IN ( '43621' )
OR translations.trid IS NULL
He creado un sitio Sandbox con una nueva instalación de WPML para que veas la estructura de la base de datos y las tablas. Debes acceder al sitio utilizando este enlace: enlace oculto y luego acceder a la base de datos en este enlace enlace oculto