Saltar navegación

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.

Etiquetado: 

Este tema contiene 4 respuestas, tiene 2 voces.

Última actualización por Carlos Rojas hace 1 año, 6 meses.

Asistido por: Carlos Rojas.

Autor Entradas
mayo 24, 2023 en 11:39 am #13706653

nocitoD

Estoy tratando de: Guardar una traduccion

URL de (mi) sitio web donde aparece el problema: enlace oculto

Yo esperaba ver: la grabacion de la traduccion

En vez de eso, obtuve: error 502 bad gateway

mayo 24, 2023 en 11:49 am #13706685

nocitoD

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

mayo 24, 2023 en 11:55 am #13706753

Carlos Rojas
Supporter

Idiomas: Inglés (English ) Español (Español )

Zona horaria: Europe/Madrid (GMT+01:00)

Hola,
Muchas gracias por contactarnos

Por favor siga los pasos descritos en este ticket y hágame saber si necesita más asistencia de nuestra parte: https://wpml.org/forums/topic/wordpress-database-error-table-icl_background_task-doesnt-exist/#post-13346647

Saludos,
Carlos

mayo 24, 2023 en 12:22 pm #13706979

nocitoD

Podrias pasarme la estructura de la base de datos , no esta creada

mayo 25, 2023 en 9:36 am #13714729

Carlos Rojas
Supporter

Idiomas: Inglés (English ) Español (Español )

Zona horaria: Europe/Madrid (GMT+01:00)

Hola,

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

Saludos,
Carlos