error on install sample data

macubex · Post by **macubex** » 17 Jun 2019, 18:36

i have try install sample data with this command: php bin/console aimeos:setup

i have return:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

https://imgur.com/RxFO7q2

how i can reasolve?

Post by **aimeos** » 18 Jun 2019, 07:40

This is an MySQL < 5.7.8 issue in combination with utf8mb4. You should set the character set to utf8 and your collation to utf8_bin instead in your config: https://github.com/aimeos/aimeos-symfon ... op.yml#L30

Note: You have to recreate your tables afterwards

macubex · Post by **macubex** » 18 Jun 2019, 07:53

aimeos wrote:This is an MySQL < 5.7.8 issue in combination with utf8mb4. You should set the character set to utf8 and your collation to utf8_bin instead in your config: https://github.com/aimeos/aimeos-symfon ... op.yml#L30

Note: You have to recreate your tables afterwards

works it, thanks!

johnsmith101 · Post by **johnsmith101** » 17 Sep 2019, 09:07

Ok.
And how to install sample data using zip if already downloaded without CLI?

Post by **aimeos** » 17 Sep 2019, 09:55

The sample data is included in the package (no separate zip file) and you can install it using:

Code: Select all

php bin/console aimeos:setup --option=setup/default/demo:1

Help for Aimeos