Friday, May 4, 2018

Vtiger 7.1.0 Database charset or collation not compatible

Vtiger 7.1.0 Database charset or collation not compatible with UTF8 Error

If you are manually installing latest Vtiger 7.1.0 version, you might got this error: “vtiger Database charset or collation not compatible with UTF8”

This happens when the database charset is not compatible with Vtiger recommended utf8_general_ci. For this, login to phpmyadmin in your cPanel. In PhpMyAdmin, you can select the database you have created and then go to “Operations”.

In the operations tab section there is an option down below for “Collation”. In that there are collation options in the drop down list. You can select “utf8_general_ci” and click Go. That’s it, your database charset is now changed to utf8_general_ci. You can go ahead and continue with the manual installation of Vtiger 7.1.0.

Alternatively, you can also select the database in phpmyadmin and then run the follow command:

“ALTER DATABASE DB_NAME CHARACTER SET utf8 COLLATE utf8_general_ci;”


0 comments: