M4T14SG4M3R
Well-known member
Hi, i want to know how i can fix the error for the mysql option, i'm trying to connect it to a mysql server version less than 5.7 and i get this:
[2019-08-04 11:40:55] [INFO] GEN | Upgrading database from version -1 to 10. This could take a moment!
[2019-08-04 11:40:58] [ERROR] GEN | SQL Error: Specified key was too long; max key length is 767 bytes
[2019-08-04 11:40:58] [CRITICAL] GEN | Could not initialize SQL!
[2019-08-04 11:40:58] [CRITICAL] GEN | Could not setup SQL table indexes! Command 'CREATE INDEX `idx_general_key` ON `general` (`key`);' returns sql: CREATE INDEX `idx_general_key` ON `general` (`key`); returned -> -1/Specified key was too long; max key length is 767 bytes
[2019-08-04 11:40:58] [INFO] GEN | Stopping application
[2019-08-04 11:40:58] [INFO] GEN | Application suspend successful!
I have a database with version higher than 5.7 but it uses cpanel, so the database name and users contains a "_", and i can't use the mysql:// url with a "_" inside of it because it throws and error on start
[2019-08-04 11:40:55] [INFO] GEN | Upgrading database from version -1 to 10. This could take a moment!
[2019-08-04 11:40:58] [ERROR] GEN | SQL Error: Specified key was too long; max key length is 767 bytes
[2019-08-04 11:40:58] [CRITICAL] GEN | Could not initialize SQL!
[2019-08-04 11:40:58] [CRITICAL] GEN | Could not setup SQL table indexes! Command 'CREATE INDEX `idx_general_key` ON `general` (`key`);' returns sql: CREATE INDEX `idx_general_key` ON `general` (`key`); returned -> -1/Specified key was too long; max key length is 767 bytes
[2019-08-04 11:40:58] [INFO] GEN | Stopping application
[2019-08-04 11:40:58] [INFO] GEN | Application suspend successful!
I have a database with version higher than 5.7 but it uses cpanel, so the database name and users contains a "_", and i can't use the mysql:// url with a "_" inside of it because it throws and error on start