Aimeos clients - msql error
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Aimeos clients - msql error
Hi,
In typo3 backend in aimeos client list I get error "SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=', /var/www/vhosts/........./httpdocs/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Statement/PDO/Simple.php:98"
Can you help me to resolve this problem?
In typo3 backend in aimeos client list I get error "SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=', /var/www/vhosts/........./httpdocs/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Statement/PDO/Simple.php:98"
Can you help me to resolve this problem?
Re: Aimeos clients - msql error
You probably upgrade from an older TYPO3 installation whose tables use an old collation. Please change the column collation of the fe_users/fe_groups tables from "utf8_general_ci" to "utf8_unicode_ci" by hand
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star