search

Alanaktion / phproject

A high performance full-featured project management system
https://www.phproject.org
GNU General Public License v3.0
384 stars 106 forks source link

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

Open roberto3x opened 9 months ago

roberto3x commented 9 months ago

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 commented 5 months ago

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,