mysql error specified key was too long

[MayanD]

hi all, i'm on Wamp with mariaDB and i have this error on Prestashop installation :

mysql error  specified key was too longmax : 1000

thank you for your help

 

[selectshop.at]

The problem is your database configuration. Changing the default engine from MyISAM to InnoDB should solve the problem. Run the SQL-Query:

set GLOBAL storage_engine='InnoDb';

Furthermore database collation should be utf8.

[MayanD]

error message : Unknown storage engine 'InnoDb'

i see on the my.ini but all look ok

[Wuschel]

It could solve the problem to add

default-storage-engine=InnoDB

to your my.ini.

[MayanD]

i'm not sur about the path . is

C:/wamp64/bin/mariadb/mariadb10.3.14/data/mysql/

or

C:/wamp64/bin/mysql/mysql5.7.26/data/     (nothing inside here)

??