zsoltE-2
|
Hi,
I received the following errors when I activated wpml:
Table 'database.ah6_icl_languages' doesn't exis
Fatal error: Uncaught Exception: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' in ../plugins/wpml-string-translation/inc/package-translation/inc/wpml-package-translation-schema.class.php:163
Can you help me, how can I solve this?
Regards, Zsolt
|
George Botsev
Supporter
Languages:
English (English )
Timezone:
Europe/Sofia (GMT+03:00)
|
Hello and thank you for contacting us.
It seems that you have some missconfiguration in your database that is causing that.
Some of your tables in the database are in the collation utf8_general_ci, and you seem to use utf8mb4 character set.
You can solve the problem in two ways.
- Change database collate of all tables to utf8mb4_unicode_520_ci
OR
- Change default character set to utf8 instead of the current utf8mb4
Please let me know if you need further assistance about this.
|
zsoltE-2
|
Hi George,
Thanks. I changed the database's collate to utf8mb4_unicode_520_ci as you said.
There is no fatal error any more, but it still not working, none of any icl_ table have been created:
WordPress database error Table 'database.xxx_icl_languages' doesn't exist for query SELECT default_locale .....
The database charset and collation is the following:
+--------------------------+------------------------+
| @@character_set_database | @@collation_database |
+--------------------------+------------------------+
| utf8mb4 | utf8mb4_unicode_520_ci |
+--------------------------+------------------------+
Do you have any idea?
Regards, Zsolt
|
Bruno
Supporter
Languages:
English (English )
Portuguese (Brazil) (Português )
Timezone:
America/Sao_Paulo (GMT-03:00)
|
Hello,
Have you installed and configured WPML? Perhaps because of the previous problem, WPML was not installed completely. You can follow the steps below:
- Open your functions.php
- insert these lines:
if( function_exists( 'icl_sitepress_activate' ) ) {
icl_sitepress_activate();
}
- Save and upload the changed file
- Visit your site and wait for the page to load
- The function "icl_sitepress_activate" is precisely to create the tables in the database. Verify that the tables were created correctly.
By following these steps, can you see the created tables and use WPML correctly?
Thank you.
|
zsoltE-2
|
Hi Bruno,
It still do not work.
PHP Fatal error: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' in /usr/share/nginx/html/wp-content/plugins/sitepress-multilingual-cms/inc/setup/sitepress-schema.php on line 362
And others:
COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'
Table 'amenteshonlap.ah6_icl_languages' doesn't exist
and so on.
Do you have any new try?
Regards, Zsolt
|
