search

LaravelDaily / quickadmin

Quick adminpanel builder package for Laravel 5
MIT License
600 stars 194 forks source link

Installation max key length error #101

Closed newbie2005 closed 7 years ago

newbie2005 commented 7 years ago

I use Mysql, it shown error in installation SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table users add unique users_email_unique(email))

PovilasKorop commented 7 years ago

@newbie2005 this is error related to MySQL, not to QuickAdmin.

Quote from the official docs: "Prefix support and lengths of prefixes (where supported) are storage engine dependent. For example, a prefix can be up to 767 bytes long for InnoDB tables or 3072 bytes if the innodb_large_prefix option is enabled. For MyISAM tables, the prefix limit is 1000 bytes. "

Please read here https://dev.mysql.com/doc/refman/5.7/en/create-index.html or google for "Specified key was too long; max key length is 767 bytes" - there are a lot of forum topics.