Aimeos clients - msql error

How to configure and adapt Aimeos based shops as developer
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!
Post Reply
marko123
Posts: 2
Joined: 17 Aug 2019, 10:39

Aimeos clients - msql error

Post by marko123 » 17 Aug 2019, 10:46

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?
Top
User avatar
aimeos
Administrator
Posts: 7873
Joined: 01 Jan 1970, 00:00

Re: Aimeos clients - msql error

Post by aimeos » 17 Aug 2019, 21:53

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, Image give us a star
Top
marko123
Posts: 2
Joined: 17 Aug 2019, 10:39

Re: Aimeos clients - msql error

Post by marko123 » 19 Aug 2019, 16:05

Thanks.
Top
Post Reply

Return to “Help”