Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PHP

ERROR 1071 (42000) at line 51: Specified key was too long; max key length is 767 bytes

sudo nano /etc/my.cnf.d/server.cnf

[mysqld]
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true

sudo systemctl restart mariadb
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #ERROR #line #Specified #key #max #key #length #bytes
ADD COMMENT
Topic
Name
8+1 =