[In attesa del feedback degli utenti] Errori nel file di log del server

Buon pomeriggio Laura, purtroppo, anche dopo il reset, l'errore risulta ancora. Te lo copio-incollo di seguito e attendo istruzioni. Grazie mille.

2025/09/09 15:10:03 [error] 2978027#2978027: *419743 FastCGI sent in stderr: "PHP message: WordPress database error Not unique table/alias: 'icl_t' for query SELECT t.term_id
FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat') LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat')
WHERE tt.taxonomy IN ('product_cat') AND tt.parent = '17' AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.element_type NOT IN ('tax_product_cat') OR icl_t.element_type IS NULL ) AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.element_type NOT ...; PHP message: WordPress database error Not unique table/alias: 'icl_t' for query SELECT t.term_id
FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat') LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat')
WHERE tt.taxonomy IN ('product_cat') AND tt.parent = '23' AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.element_type NOT IN ('tax_product_cat') OR icl_t.element_type IS NULL ) AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )

2025/09/09 15:10:03 [error] 2978027#2978027: *419743 FastCGI sent in stderr: " table/alias: 'icl_t' for query SELECT t.term_id
FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat') LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat')
WHERE tt.taxonomy IN ('product_cat') AND tt.parent = '33' AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.element_type NOT IN ('tax_product_cat') OR icl_t.element_type IS NULL ) AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.element_type NOT ...; PHP message: WordPress database error Not unique table/alias: 'icl_t' for query SELECT t.term_id
FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat') LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat')
WHERE tt.taxonomy IN ('product_cat') AND tt.parent = '42' AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.element_type NOT IN ('tax_product_cat') OR icl_t.element_type IS NULL ) AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.eleme
2025/09/09 15:10:03 [error] 2978027#2978027: *419743 FastCGI sent in stderr: "d
FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat') LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat')
WHERE tt.taxonomy IN ('product_cat') AND tt.parent = '45' AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.element_type NOT IN ('tax_product_cat') OR icl_t.element_type IS NULL ) AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.element_type NOT ...; PHP message: WordPress database error Not unique table/alias: 'icl_t' for query SELECT t.term_id
FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat') LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat')
WHERE tt.taxonomy IN ('product_cat') AND tt.parent = '30' AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.element_type NOT IN ('tax_product_cat') OR icl_t.element_type IS NULL ) AND ( ( icl_t.element_type IN ('tax_product_cat') AND ( icl_t.language_code = 'it' OR 0 ) )
OR icl_t.element_type NOT ...; PHP message: WordPress database

Buongiorno Laura,
il sito è in produzione per cui purtroppo non posso fare quel tipo di test. Però ti fornisco un altro elemento che potrebbe aiutare a capire il problema. Stamattina il sito ha restituito l'errore che ti incollo di seguito (mi è arrivata la mail di WordPress relativa al problema tecnico).
Si fa riferimento alla riga 657 del file "wpml-term-translations.class.php"

When seeking help with this issue, you may be asked for some of the following information:
Versione di WordPress 6.8.1
Tema attivo: Pro – Child Theme (versione 1.0.0) Plugin corrente: WPML Multilingual CMS (versione 4.8.1) Versione PHP 8.3.23

Dettagli dell'errore
====================
Un errore di E_ERROR è stato causato nella linea 657 del file /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/inc/taxonomy-term-translation/wpml-term-translations.class.php. Messaggio di errore: Uncaught Error: Cannot use object of type WP_Error as array in /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/inc/taxonomy-term-translation/wpml-term-translations.class.php:657
Stack trace:
#0 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/fp/core/Logic.php(63): WPML_Terms_Translations::{closure}()
#1 [internal function]: WPML\FP\Logic::WPML\FP\{closure}()
#2 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/fp/core/functions.php(154): call_user_func_array()
#3 [internal function]: WPML\FP\{closure}()
#4 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/collect/src/Illuminate/Support/Collection.php(603): array_map()
#5 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/inc/taxonomy-term-translation/wpml-term-translations.class.php(574): WPML\Collect\Support\Collection->map()
#6 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/inc/taxonomy-term-translation/wpml-term-translations.class.php(524): WPML_Terms_Translations::quick_edited_post_terms()
#7 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/inc/taxonomy-term-translation/wpml-term-translations.class.php(502): WPML_Terms_Translations::set_tags_in_proper_language()
#8 /var/datahd/websites/look4hair.com/wp-includes/class-wp-hook.php(324): WPML_Terms_Translations::set_object_terms_action()
#9 /var/datahd/websites/look4hair.com/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#10 /var/datahd/websites/look4hair.com/wp-includes/plugin.php(517): WP_Hook->do_action()
#11 /var/datahd/websites/look4hair.com/wp-includes/taxonomy.php(2966): do_action()
#12 /var/datahd/websites/look4hair.com/wp-includes/post.php(5654): wp_set_object_terms()
#13 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/inc/actions/wpml-tm-post-actions.class.php(243): wp_set_post_terms()
#14 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/inc/actions/wpml-tm-post-actions.class.php(52): WPML_TM_Post_Actions->save_translation_priority()
#15 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/inc/functions-load-tm.php(941): WPML_TM_Post_Actions->save_post_actions()
#16 /var/datahd/websites/look4hair.com/wp-includes/class-wp-hook.php(324): wpml_tm_save_post()
#17 /var/datahd/websites/look4hair.com/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#18 /var/datahd/websites/look4hair.com/wp-includes/plugin.php(517): WP_Hook->do_action()
#19 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/inc/post-translation/wpml-post-translation.class.php(213): do_action()
#20 /var/datahd/websites/look4hair.com/wp-content/plugins/sitepress-multilingual-cms/inc/post-translation/wpml-admin-post-actions.class.php(123): WPML_Post_Translation->after_save_post()
#21 /var/datahd/websites/look4hair.com/wp-includes/class-wp-hook.php(326): WPML_Admin_Post_Actions->save_post_actions()
#22 /var/datahd/websites/look4hair.com/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#23 /var/datahd/websites/look4hair.com/wp-includes/plugin.php(517): WP_Hook->do_action()
#24 /var/datahd/websites/look4hair.com/wp-includes/post.php(5110): do_action()
#25 /var/datahd/websites/look4hair.com/wp-includes/post.php(5212): wp_insert_post()
#26 /var/datahd/websites/look4hair.com/wp-admin/includes/post.php(453): wp_update_post()
#27 /var/datahd/websites/look4hair.com/wp-admin/post.php(227): edit_post()
#28 {main}
thrown

Buongiorno Laura,
purtroppo abbiamo difficoltà nel creare una staging area; cercando di capire da cosa possa dipendere ho visto che il trigger che scatena l'errore è nel file /wp-content/plugins/sitepress-multilingual-cms/inc/taxonomy-term-translation/wpml-term-translations.class.php in corrispondenza di questa funzione:

private static function createTerm( $taxonomy, $postLang ) {
return function ( $termData ) use ( $taxonomy, $postLang ) {
global $sitepress;

$idInCorrectId = false;
$newTerm = wp_insert_term( $termData['name'], $taxonomy, [ 'slug' => self::term_unique_slug( sanitize_title( $termData['name'] ), $taxonomy, $postLang ) ] );
if ( isset( $newTerm['term_taxonomy_id'] ) ) {
$idInCorrectId = $newTerm['term_taxonomy_id'];
$trid = $sitepress->get_element_trid( $termData['id'], 'tax_' . $taxonomy );
$sitepress->set_element_language_details( $idInCorrectId, 'tax_' . $taxonomy, $trid, $postLang );
}

return Obj::assoc( 'idInPostLang', $idInCorrectId, $termData );
};
}

Nello specifico la riga:

if ( isset( $newTerm['term_taxonomy_id'] ) ) {

Questa info potrebbe essere d'aiuto?

Buongiorno Laura, dove posso inviarti copia del sito? Via WeTransfer?
Grazie

Buon pomeriggio Laura,
ho esportato database e files e sono pronto ad inviarti il we transfer; Dato che il ticket è pubblico, come posso fare per inoltrarti il link?

Ti ringrazio

link nascosto

Ok. Sto rieseguendo la copia tramite WP All in One Migration. Dato la copia pesa oltre 5 GB, avrei bisogno di una mail per poter condividere il link da Google Drive.

Grazie