Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes #416

Open
roberto3x opened this issue Nov 28, 2023 · 1 comment

Comments

@roberto3x
Copy link

The installation process stops and reports an error... SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
The tables are created in the database (I'm not sure if all of them are).

@Dr-Dupont
Copy link

To help others with this problem:
The error is because of UTF8mb4 and "UNIQUE KEY attribute", in the config table, and you are running an older MySQL.
You can add "innodb_large_prefix=1" to your MySQL ini file, or edit "db/database.sql" with the following:
attribute varchar(191) NULL,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants