Page 1 of 1

error on install sample data

Posted: 17 Jun 2019, 18:36
by macubex
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?

Re: error on install sample data

Posted: 18 Jun 2019, 07:40
by aimeos
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

Re: error on install sample data

Posted: 18 Jun 2019, 07:53
by macubex
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!

Re: error on install sample data

Posted: 17 Sep 2019, 09:07
by johnsmith101
Ok.
And how to install sample data using zip if already downloaded without CLI?

Re: error on install sample data

Posted: 17 Sep 2019, 09:55
by aimeos
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