Installation script error when creating databases
-
When trying to install PufferPanel, the setup had an error that prevented it from creating databases and installing the frontend. As a result, the panel shows "500 Internal Error" page.
The error is as follows:
ERROR 1709 (HY000) at line 24: Index column size too large. The maximum column size is 767 bytes.
This occurs after I type in the MySQL account details.
I'm running Linux Mint (Ubuntu 16.04) with MariaDB 10.2 and PHP 7.1. I did some research online and found that this issue is caused by a limitation of InnoDB, but I have no idea how to solve it (Setting the default database storage type to Aria in MySQL did not fix it).
-
Still not solved. Bump
-
This is an issue with a key we use, but I thought we removed it.
The easiest way will be removing the following line from the /srv/pufferpanel/install/install.sql file (line 41)
UNIQUE KEY 'email_unique' ('email'),
https://github.com/PufferPanel/PufferPanel/blob/master/install/install.sql#L41
-
@LordRalex said in Installation script error when creating databases:
This is an issue with a key we use, but I thought we removed it.
The easiest way will be removing the following line from the /srv/pufferpanel/install/install.sql file (line 41)
UNIQUE KEY 'email_unique' ('email'),
https://github.com/PufferPanel/PufferPanel/blob/master/install/install.sql#L41
Thanks a lot. Will try when I got time.
-
@LordRalex said in Installation script error when creating databases:
This is an issue with a key we use, but I thought we removed it.
The easiest way will be removing the following line from the /srv/pufferpanel/install/install.sql file (line 41)
UNIQUE KEY 'email_unique' ('email'),
https://github.com/PufferPanel/PufferPanel/blob/master/install/install.sql#L41
Problem solved. Instead of deleting the line with the emails, I lowered the length of the key to 128, well below the character limit (767/4>128). This allowed the setup to complete without errors.