error on install sample data

Questions around the Aimeos bundle for the Symfony framework
Forum rules
Always add your Symfony, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
macubex
Posts: 2
Joined: 17 Jun 2019, 18:31

error on install sample data

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?

User avatar
aimeos
Administrator
Posts: 8354
Joined: 01 Jan 1970, 00:00

Re: error on install sample data

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
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

macubex
Posts: 2
Joined: 17 Jun 2019, 18:31

Re: error on install sample data

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
Posts: 1
Joined: 17 Sep 2019, 09:02

Re: error on install sample data

Post by johnsmith101 » 17 Sep 2019, 09:07

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

User avatar
aimeos
Administrator
Posts: 8354
Joined: 01 Jan 1970, 00:00

Re: error on install sample data

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
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply