Este usuario no tiene temas favoritos.
Temas favoritos del foro
Temas del foro creados
Estado |
Tema
|
Colaborador | Voces | Entradas | Frescura |
---|---|---|---|---|---|
WooCommerce product trial error when using WPML
Iniciado por: mathleaks en: English Support |
2 | 2 | hace 8 meses | ||
The List of languages disappeared
Iniciado por: mathleaks
en: English Support
Problem: The list of languages to choose from in wp-admin is empty. Everywhere where there would be a list of available languages, it is empty. Then while debugging the issue, the following error occurred. WordPress database error for Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wordpress.lt.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by username 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 = 'sv' 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 = 'sv' ) ) ) GROUP BY l.code ORDER BY english_name ASC skapat av WPML_Installation::refresh_active_lang_cache Solution: The problem was the wrong SQL setting. For an unknown reason, the sql_mode option had been set tp only_full_group_by. This is wrong. In fact, WordPress itself automatically unsets these incompatible SQL modes, without intervention. Please see the source code here. https://github.com/WordPress/WordPress/blob/master/wp-includes/wp-db.php#L631..L645 To correct this problem, you should remove the `ONLY_FULL_GROUP_BY` setting from the sql_mode options. The user reported the following.
|
2 | 4 | hace 1 año, 10 meses | ||
Can´t translate menus
Iniciado por: mathleaks en: Chat Support |
1 | 2 |
hace 3 años
|
||
WPML tries to create icl_string_batches for each request
Iniciado por: mathleaks en: English Support |
3 | 13 | hace 3 años, 2 meses | ||
Permalink base URLs broken when using domain-based language URL-format
Iniciado por: mathleaks en: English Support |
2 | 11 | hace 3 años, 6 meses |