Navigation überspringen

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

wp-config.php

file:

define('WP_DEBUG', true);<br />define('WP_DEBUG_LOG', true);<br />define('WP_DEBUG_DISPLAY', false);

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.

If this solution doesn't look relevant to your issue, please open a new support ticket with us.

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.

Schlagwörter: 

Dieses Thema enthält 6 Antworten, hat 2 Stimmen.

Zuletzt aktualisiert von Bruno Kos Vor 1 Jahr, 5 Monaten.

Assistiert von: Bruno Kos.

Verfasser Beiträge
Dezember 18, 2023 unter 1:10 pm #15084497

guentherU

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.

Thank you for your help!
Günther

Screenshot 2023-12-18 140939.png
Dezember 18, 2023 unter 2:16 pm #15084975

Bruno Kos
WPML-Unterstützer seit 12/2018

Sprachen: Englisch (English ) Deutsch (Deutsch ) Französisch (Français )

Zeitzone: Europe/Zagreb (GMT+02:00)

Hi,

Thank you for contacting WPML support!

After you reset WPML (so like this https://wpml.org/documentation/getting-started-guide/language-setup/deleting-languages-and-plugin-data-by-doing-a-wpml-reset-on-your-site/#step-3-do-the-wpml-reset), do you still see these tables in your database?

Because if these are still there, it may indicate that your database user has no privileges to drop them or even to insert data.

Regards,
Bruno Kos

icl tables.jpg
Dezember 18, 2023 unter 3:54 pm #15085975

guentherU

Hi Bruno,

thank you for your reply. If I reset WPML with the above funktion the tables are dropped.

And if I reinstall WPML they are agian there but it looks like they are all empty..

I don't get any erron on installing or aktivating WPML.

Must be something else... I can give backend access if you need.
Günther

Dezember 18, 2023 unter 5:36 pm #15086633

Bruno Kos
WPML-Unterstützer seit 12/2018

Sprachen: Englisch (English ) Deutsch (Deutsch ) Französisch (Français )

Zeitzone: Europe/Zagreb (GMT+02:00)

What if you try something like this?

SHOW GRANTS FOR 'username'@'hostname';

Do you have privileges for the INSERT? Can you check for database logs also or check with the hosting support if they can check for it?

You can also do this, but not sure if something will be recorded:

1. Edit wp-config.php and insert the following lines (just before /* That's all, stop editing! Happy publishing. */ part)

define( 'WP_DEBUG', true);
define( 'WP_DEBUG_LOG', true);
define( 'WP_DEBUG_DISPLAY', false);

2. Reproduce the issue - reset WPML and configure it again.

3. Locate the debug log in: /wp-content/debug.log

4. Paste the latest lines here. No need to paste the entire log file, just 20 lines or so will do. Please censor any sensitive information.

Dezember 19, 2023 unter 12:58 pm #15092723

guentherU

Hi Bruno,

we come closer to the thing..

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,

See also the db-user grants attached.

Thanks for any help
Günther

WhatsApp Image 2023-12-19 at 11.07.41.jpeg
Dezember 19, 2023 unter 1:16 pm #15092911

Bruno Kos
WPML-Unterstützer seit 12/2018

Sprachen: Englisch (English ) Deutsch (Deutsch ) Französisch (Français )

Zeitzone: Europe/Zagreb (GMT+02:00)

I see you are using MySQLVersion 5.7.42 which conforms to our minimum requirements.

Would you be willing to provide me with WordPress and FTP credentials so I could investigate the issue directly?

Also can you install the following plug-ins:
https://wordpress.org/plugins/wp-phpmyadmin-extension/
https://wordpress.org/plugins/wp-file-manager/

https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

I marked your next reply as private so that you can safely add credentials.

Dezember 20, 2023 unter 8:59 am #15099039

Bruno Kos
WPML-Unterstützer seit 12/2018

Sprachen: Englisch (English ) Deutsch (Deutsch ) Französisch (Français )

Zeitzone: Europe/Zagreb (GMT+02:00)

We finally got this:

[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

The error is explained here:

https://stackoverflow.com/a/48993956, it seems the amount of data WPML trying to insert, but storage is full for that data.

Can you check with server support about this?