Dieses Thema ist gelöst. Hier finden Sie eine Beschreibung des Problems und der Lösung.
Problem: The client was unable to set up the default language and translation languages in WPML, as no languages were appearing in the lists. Despite resetting WPML, the issue persisted. Error logs indicated a SQL syntax error and missing tables in the database.
Solution: We first suggested checking if the database user had sufficient privileges to drop tables and insert data by using the
SHOW GRANTS FOR 'username'@'hostname';
command. We also recommended enabling WordPress debugging to capture any errors during the WPML reset process by adding the following lines to the
After further investigation, we discovered a database error related to storage engine issues when WPML tried to insert data. We advised the client to check with their server support to ensure there was enough storage available for WPML's data.
Dies ist das technische Support-Forum für WPML – das mehrsprachige WordPress-Plugin.
Mitlesen können alle, doch nur WPML-Kunden können hier Fragen veröffentlichen. Das WPML-Team antwortet im Forum an 6 Tagen pro Woche, 22 Stunden am Tag.
I just have installed WPML and try to first set up WPML but on the first page where I should set up the default language and translations languages I have no language in the lists.
I tried to reset as suggested but always the same.
I installed WPML so many times but never had this problem.
Don't think it is a rights problem but could have to do with db-version perhaps?
Here a part from the error log, it is always the same then:
[19-Dec-2023 11:21:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 for query SELECT t.name, t.term_id, tt.taxonomy FROM wp_terms AS t JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE () made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), WPML_Troubleshooting_Terms_Menu::display_terms_with_suffix, WPML_Terms_Translations::get_all_terms_with_language_suffix
[19-Dec-2023 11:21:15 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 for query SELECT t.name, t.term_id, tt.taxonomy FROM wp_terms AS t JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE () made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), WPML_Troubleshooting_Terms_Menu::display_terms_with_suffix, WPML_Terms_Translations::get_all_terms_with_language_suffix
[19-Dec-2023 11:21:30 UTC] WordPress database error Table 'website.wp_icl_languages' doesn't exist for query
SELECT
l.code,
l.id,
english_name,
nt.name AS native_name,
major,
active,
default_locale,
encode_url,
tag,
lt.name AS display_name
FROM wp_icl_languages l
JOIN wp_icl_languages_translations nt
ON ( nt.language_code = l.code AND nt.display_language_code = l.code )
LEFT OUTER JOIN wp_icl_languages_translations lt ON l.code=lt.language_code
WHERE
( lt.display_language_code = ''
OR (lt.display_language_code = 'en'
AND NOT EXISTS ( SELECT *
FROM wp_icl_languages_translations ls
WHERE ls.language_code = l.code
AND ls.display_language_code = '' ) ) )
GROUP BY l.code
ORDER BY english_name ASC made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, require_once('/plugins/sitepress-multilingual-cms/addons/wpml-page-builders/app.php'), WPML\PB\App::run, WPML\PB\LegacyIntegration::load, WPML_Action_Filter_Loader->load, WPML_Action_Filter_Loader->load_factory_or_action, WPML_Action_Filter_Loader->load_factory, WPML_Action_Filter_Loader->run_factory, WPML_Compatibility_Plugin_Fusion_Hooks_Factory->create, WPML_Compatibility_Plugin_Fusion_Hooks_Factory->get_filtered_active_languages, SitePress->get_active_languages, SitePress->get_current_language, SitePress->set_this_lang, SitePress->is_valid_language, SitePress->get_languages, WPML_Installation->refresh_active_lang_cache
[19-Dec-2023 11:21:30 UTC] WordPress database error Table 'website.wp_icl_languages' doesn't exist for query
SELECT
l.code,
l.id,
english_name,
[20-Dec-2023 08:24:19 UTC] WordPress database error Got error 168 from storage engine for query TRUNCATE wp_icl_languages made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), SitePress_Setup::fill_languages
Wir verwenden Cookies, um unsere Website und Dienste zu optimieren. Ihre Zustimmung erlaubt es uns, Daten wie das Durchsuchen der Website zu verarbeiten. Wenn Sie nicht zustimmen, können einige Funktionen beeinträchtigt werden.
Funktionell
Immer aktiv
Erforderlich für den Betrieb und die korrekte Kommunikation auf unserer Website.
Präferenzen
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistiken
Wir verwenden diese, um die Statistiken unserer Website zu analysieren. Die gesammelten Informationen sind völlig anonym. Der technische Speicher oder Zugriff, der ausschließlich zu anonymen statistischen Zwecken verwendet wird. Ohne eine Vorladung, die freiwillige Einhaltung durch Ihren Internetdienstanbieter oder zusätzliche Aufzeichnungen von Dritten können die zu diesem Zweck gespeicherten oder abgerufenen Informationen in der Regel nicht dazu verwendet werden, Sie zu identifizieren.
Marketing
Diese Cookies verfolgen Ihr Surfverhalten, um für Sie relevante Werbung anzuzeigen.