ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes

user_8264375 0
Viewed 3216

I was installing Govway 3.3.2 on a linux machine with Tomcat 7.0.76.0 and MariaDB 10.2.23; when I started importing the sql "GovWay.sql" I got the error "ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes". I tried to change the character and I also tried to set the following variables:

  • SET GLOBAL innodb_large_prefix=ON;
  • SET GLOBAL innodb_file_format=barracuda;
  • SET GLOBAL innodb_file_per_table=true;

but I haven't solved the problem.

the solutions proposed in this question, it is not possible for me to apply them question

other solutions said to change the

varchar (4000)

but I can't make this change.

any suggestions?

mariadb mysql
1 Answers

a proposed solution is to comment on the "constraint"

-- CONSTRAINT uniq_pa_behaviour_props_1 UNIQUE (id_porta,nome,valore),

user_82643750
Related