Saltar navegación

Inicio › Soporte › Soporte en español › [Resuelto] WordPress database error Unknown column

[Resuelto] WordPress database error Unknown column

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.

Hoy no hay asistentes de soporte disponibles en el foro Spanish. Siéntase libre de enviar sus tiques y les daremos trámite tan pronto como estemos disponibles en línea. Gracias por su comprensión.

Etiquetado: 

Este tema contiene 25 respuestas, tiene 2 voces.

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

Asistido por: Carlos Rojas.

Autor Entradas
enero 23, 2023 en 10:28 am #12871433

cristinaD-15

Estoy tratando de: llevo un tiempo con este problema y me gustaría solucionarlo

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

WordPress database error Unknown column 'wpml_translations.language_code' in 'where clause' for query
SELECT ivEKwT_posts.*
FROM ivEKwT_posts
WHERE 1=1 AND ivEKwT_posts.post_name = 'autodiscover-xml' AND ivEKwT_posts.post_type = 'attachment' AND ( ( ( wpml_translations.language_code = 'ca' OR (
wpml_translations.language_code = 'ca'
AND ivEKwT_posts.post_type IN ( 'product' )
AND ( (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'ca'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations t2
JOIN ivEKwT_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'ca'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND ivEKwT_posts.post_type IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','product','product_variation','wpcf7_contact_form','br_minmax_limitation' ) ) OR ivEKwT_posts.post_type NOT IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','product','product_variation','wpcf7_contact_form','br_minmax_limitation' ) )

ORDER BY ivEKwT_posts.post_date DESC

made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

Mark as fixed | Ignorar
 
Jan 23, 09:10:27

WordPress database error Unknown column 'wpml_translations.language_code' in 'where clause' for query
SELECT ivEKwT_posts.*
FROM ivEKwT_posts
WHERE 1=1 AND ivEKwT_posts.post_name = 'autodiscover-xml' AND ivEKwT_posts.post_type = 'attachment' AND ( ( ( wpml_translations.language_code = 'ca' OR (
wpml_translations.language_code = 'ca'
AND ivEKwT_posts.post_type IN ( 'product' )
AND ( (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'ca'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations t2
JOIN ivEKwT_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'ca'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND ivEKwT_posts.post_type IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','product','product_variation','wpcf7_contact_form','br_minmax_limitation' ) ) OR ivEKwT_posts.post_type NOT IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','product','product_variation','wpcf7_contact_form','br_minmax_limitation' ) )

ORDER BY ivEKwT_posts.post_date DESC

made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
enero 23, 2023 en 12:25 pm #12872563

Carlos Rojas
Supporter

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

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

Hola,
Muchas gracias por contactarnos

Por favor realice los siguientes pasos:
- Cree una copia de seguridad del sitio completo
- Pega el siguiente código al final del archivo functions.php que se encuentra en la carpeta del tema activo:

function wpmlsupp_1891_fix_missing_icl_tables() {
    if( function_exists( 'icl_sitepress_activate' ) )
        icl_sitepress_activate();
}
add_action( 'wp_footer', 'wpmlsupp_1891_fix_missing_icl_tables' );

- Visita el frontend del sitio y espera a que cargue completamente
- Borra el código que acabas de pegar en functions.php
- Comprueba si el problema desapareció

Puede decirme el resultado de los pasos anteriores?

Saludos,
Carlos
enero 24, 2023 en 12:44 am #12876251

cristinaD-15

No doy crédito. Funciona! (de momento). He estado un año y pico con esos errores.

Mil gracias. Podemos cerrar el ticket y si vuelve a aparecer algún error de ese tipo lo vuelvo a abrir.
Gracias Carlos
enero 24, 2023 en 8:26 am #12878229

cristinaD-15

Malas noticias.
Me han salido estos dos errores ahora

WordPress database error Unknown column 'wpml_translations.language_code' in 'where clause' for query
SELECT ivEKwT_posts.*
FROM ivEKwT_posts
WHERE 1=1 AND ivEKwT_posts.post_name = 'acrollam-rosado-2020' AND ivEKwT_posts.post_type = 'attachment' AND ( ( ( wpml_translations.language_code = 'es' OR (
wpml_translations.language_code = 'ca'
AND ivEKwT_posts.post_type IN ( 'nectar_slider','product' )
AND ( (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'es'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations t2
JOIN ivEKwT_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'es'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND ivEKwT_posts.post_type IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) ) OR ivEKwT_posts.post_type NOT IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) )

ORDER BY ivEKwT_posts.post_date DESC

made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

 
Jan 24, 09:14:59

WordPress database error Unknown column 'wpml_translations.language_code' in 'where clause' for query
SELECT ivEKwT_posts.*
FROM ivEKwT_posts
WHERE 1=1 AND ivEKwT_posts.post_name = 'autodiscover-xml' AND ivEKwT_posts.post_type = 'attachment' AND ( ( ( wpml_translations.language_code = 'ca' OR (
wpml_translations.language_code = 'ca'
AND ivEKwT_posts.post_type IN ( 'nectar_slider','product' )
AND ( (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'ca'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations t2
JOIN ivEKwT_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'ca'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND ivEKwT_posts.post_type IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) ) OR ivEKwT_posts.post_type NOT IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) )

ORDER BY ivEKwT_posts.post_date DESC

made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

 
Jan 24, 09:14:59

WordPress database error Unknown column 'wpml_translations.language_code' in 'where clause' for query
SELECT ivEKwT_posts.*
FROM ivEKwT_posts
WHERE 1=1 AND ivEKwT_posts.post_name = 'autodiscover-xml' AND ivEKwT_posts.post_type = 'attachment' AND ( ( ( wpml_translations.language_code = 'ca' OR (
wpml_translations.language_code = 'ca'
AND ivEKwT_posts.post_type IN ( 'nectar_slider','product' )
AND ( (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'ca'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations t2
JOIN ivEKwT_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'ca'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND ivEKwT_posts.post_type IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) ) OR ivEKwT_posts.post_type NOT IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) )

ORDER BY ivEKwT_posts.post_date DESC

made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
enero 24, 2023 en 9:04 am #12878581

Carlos Rojas
Supporter

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

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

Hola,
Me alegra saber que el problema fue resuelto con los pasos descritos en mi mensaje 🙂

Al parecer está teniendo el mismo problema, por lo que le recomiendo volver a realizar los mismos pasos, pero antes de ello confirme con sus proveedores de hosting que el usuario de la base de datos tiene full access para evitar que por falta de permisos no se creen todas las columnas y tablas necesarias en la base de datos.

Saludos,
Carlos
enero 24, 2023 en 11:28 am #12880805

cristinaD-15

Hola Carlos, no funciona. He revisado y el usuario de la base de datos instalada tiene todos los permisos.
Si quieres enviar un script y lo ejecuto directamente en la base de datos? Cuál es el problema exactamente? Que no se generan unas tablas o qué?
Gracias
Kris
enero 24, 2023 en 7:10 pm #12884535

Carlos Rojas
Supporter

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

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

Hola Kris,

De acuerdo al error, no se encuentran la columna 'wpml_translations.language_code' y por lo tanto no se puede ejecutar la query correctamente.

La solución que he descrito anteriormente debería solucionar el problema, pero si el problema persiste entonces me gustaría pedirle que comparta las credenciales de acceso al sitio en su próximo mensaje que he establecido como privado y donde encontrará los campos correspondientes a las credenciales solicitadas.

Saludos,
Carlos
enero 26, 2023 en 10:13 am #12896087

Carlos Rojas
Supporter

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

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

Hola,
Muchas gracias por compartir la información solicitada

He vuelto a aplicar la solución descrita en mi mensaje anterior y los únicos errores que veo ahora provienen del tema hijo.

Saludos,
Carlos
enero 27, 2023 en 8:44 am #12902309

cristinaD-15

Hola Carlos, lamentablemente sigue pasando

WordPress database error Unknown column 'wpml_translations.language_code' in 'where clause' for query
SELECT ivEKwT_posts.*
FROM ivEKwT_posts
WHERE 1=1 AND ivEKwT_posts.post_name = 'autodiscover-xml' AND ivEKwT_posts.post_type = 'attachment' AND ( ( ( wpml_translations.language_code = 'ca' OR (
wpml_translations.language_code = 'ca'
AND ivEKwT_posts.post_type IN ( 'nectar_slider','product','mstcprcfvc' )
AND ( (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'ca'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations t2
JOIN ivEKwT_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'ca'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND ivEKwT_posts.post_type IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) ) OR ivEKwT_posts.post_type NOT IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) )

ORDER BY ivEKwT_posts.post_date DESC

made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

Mark as fixed | Ignorar
 
Jan 27, 09:21:28

WordPress database error Unknown column 'wpml_translations.language_code' in 'where clause' for query
SELECT ivEKwT_posts.*
FROM ivEKwT_posts
WHERE 1=1 AND ivEKwT_posts.post_name = 'autodiscover-xml' AND ivEKwT_posts.post_type = 'attachment' AND ( ( ( wpml_translations.language_code = 'ca' OR (
wpml_translations.language_code = 'ca'
AND ivEKwT_posts.post_type IN ( 'nectar_slider','product','mstcprcfvc' )
AND ( (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'ca'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations t2
JOIN ivEKwT_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'ca'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND ivEKwT_posts.post_type IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) ) OR ivEKwT_posts.post_type NOT IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) )

ORDER BY ivEKwT_posts.post_date DESC

made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
enero 27, 2023 en 9:31 am #12902633

Carlos Rojas
Supporter

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

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

Hola,

Puede decirme qué pasos siguió en el sitio antes de volver a ver el problema?

Saludos,
Carlos
enero 27, 2023 en 9:36 am #12902691

cristinaD-15

Estuve trabajando en esta página
enlace oculto
y quizás cambié el slug (no estoy muy segura si esto lo hice a las 21h o al mediodía)
enero 27, 2023 en 4:41 pm #12905659

cristinaD-15

Hola Carlos, vuelvo a tener numerosos errores de wpml.

 WordPress database error Unknown column 'wpml_translations.language_code' in 'where clause' for query
SELECT ivEKwT_posts.*
FROM ivEKwT_posts
WHERE 1=1 AND ivEKwT_posts.post_name = 'terna' AND ivEKwT_posts.post_type = 'attachment' AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'ca'
AND ivEKwT_posts.post_type IN ( 'nectar_slider','product','mstcprcfvc' )
AND ( (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM ivEKwT_icl_translations t2
JOIN ivEKwT_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND ivEKwT_posts.post_type IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) ) OR ivEKwT_posts.post_type NOT IN ('page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','nectar_slider','product','product_variation','wpcf7_contact_form','br_minmax_limitation','mstcprcfvc' ) )

ORDER BY ivEKwT_posts.post_date DESC

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\ATE\REST\PublicReceive->receive_ate_job, WPML\FP\Just->chain, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Just->ap, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\TM\API\ATE->applyTranslation, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, WPML_Translate_Link_Targets_In_Content->new_content, WPML_Translate_Link_Targets_In_Content->do_new_content, WPML_Translate_Link_Targets_In_Content->fix, WPML_Pro_Translation->fix_links_to_translated_content, WPML\FP\{closure}, call_user_func_array, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, array_map, WPML_Pro_Translation->{closure}, WPML_Translate_Link_Targets->convert_text, AbsoluteLinks->convert_text, AbsoluteLinks->_process_generic_text, url_to_postid, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
enero 27, 2023 en 8:26 pm #12906569

Carlos Rojas
Supporter

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

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

Hola,
Muchas gracias por su mensaje

He activado el modo de depuración de WordPress en el sitio y solamente veo una alerta relacionada con el tema:

[27-Jan-2023 20:23:45 UTC] PHP Notice:  La funció stock_status s'ha cridat <strong>de manera incorrecta</strong>. No s'hauria d'accedir a les propietats del producte directament. Backtrace: require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/salient/page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, vc_do_shortcode, WPBakeryShortCode->output, WPBakeryShortCode_Vc_Row->content, WPBakeryShortCode->loadTemplate, require('/plugins/salient-core/includes/vc_templates/vc_row.php'), do_shortcode, preg_replace_callback, do_shortcode_tag, vc_do_shortcode, WPBakeryShortCode->output, WPBakeryShortCode->content, WPBakeryShortCode->loadTemplate, require('/plugins/salient-core/includes/vc_templates/vc_column.php'), wpb_js_remove_wpautop, do_shortcode, preg_replace_callback, do_shortcode_tag, vc_do_shortcode, WPBakeryShortCode->output, WPBakeryShortCode_Vc_Row->content, WPBakeryShortCode->loadTemplate, require('/plugins/salient-core/includes/vc_templates/vc_row_inner.php'), do_shortcode, preg_replace_callback, do_shortcode_tag, vc_do_shortcode, WPBakeryShortCode->output, WPBakeryShortCode->content, WPBakeryShortCode->loadTemplate, require('/plugins/salient-core/includes/vc_templates/vc_column_inner.php'), wpb_js_remove_wpautop, do_shortcode, preg_replace_callback, do_shortcode_tag, WC_Shortcodes::product_add_to_cart, woocommerce_template_loop_add_to_cart, wc_get_template, include('/themes/salient/woocommerce/loop/add-to-cart.php'), apply_filters('woocommerce_loop_add_to_cart_link'), WP_Hook->apply_filters, fc_archive_add_to_cart_text, WC_Abstract_Legacy_Product->__get, wc_doing_it_wrong Consulteu <a href="https://wordpress.org/support/article/debugging-in-wordpress/">la depuració en el WordPress</a> per a més informació. (Aquest missatge s'ha afegit en la versió 3.0.) in /home/mesquida/public_html/mesquidamora.com/wp-includes/functions.php on line 5835

Por favor hágame saber cómo ver el mensaje de error que aprece en su último mensaje.

Saludos,
Carlos
enero 27, 2023 en 9:05 pm #12906679

cristinaD-15

En el escritorio lo puedes ver. Tengo instalado un plugin para ver los logs.
Saludos,
Kris

Captura de pantalla 2023-01-27 a las 22.03.54.png
enero 28, 2023 en 12:13 pm #12908851

Carlos Rojas
Supporter

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

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

Hola,

He revisado el log de errores de WordPress y este mensaje de error no aparece por lo que le recomiendo que realice los siguientes pasos para confirmar si es un falso positivo o un error real:
- Contacte con sus proveedores de hosting de ser necesario
- Conéctese a la base de datos del sitio
- Busque la tabla 'wpml_translations'
- Compruebe si la columna 'language_code' existe

Puede decirme el resultado de los pasos anteriores?

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