We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Hello everyone, I followed the installation instructions, but now I'm encountering the following error during the SQL setup:
Cannot install sql SCHEMA file: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes query that failed: CREATE TABLE users(idint(11) NOT NULL AUTO_INCREMENT,usernamevarchar(255) NOT NULL DEFAULT '',authMethodINT(2) NULL DEFAULT 1,passwordCHAR(128) DEFAULT NULL,groupsvarchar(1024) DEFAULT NULL,roletext,real_namevarchar(128) DEFAULT NULL,emailvarchar(254) DEFAULT NULL,domainUserbinary(1) DEFAULT '0',widgetsVARCHAR(1024) NULL DEFAULT 'statistics;favourite_subnets;changelog;top10_hosts_v4',langINT(11) UNSIGNED NULL DEFAULT '9',favourite_subnetsVARCHAR(1024) NULL DEFAULT NULL,disabledENUM('Yes','No') NOT NULL DEFAULT 'No',mailNotifyENUM('Yes','No') NOT NULL DEFAULT 'No',mailChangelogENUM('Yes','No') NOT NULL DEFAULT 'No',passChangeENUM('Yes','No') NOT NULL DEFAULT 'No',editDateTIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP,lastLoginTIMESTAMP NULL,lastActivityTIMESTAMP NULL,compressOverrideENUM('default','Uncompress') NOT NULL DEFAULT 'default',hideFreeRangetinyint(1) DEFAULT '0',menuTypeENUM('Static','Dynamic') NOT NULL DEFAULT 'Dynamic',menuCompactTINYINT NULL DEFAULT '1',2faBOOL NOT NULL DEFAULT '0',2fa_secretVARCHAR(32) NULL DEFAULT NULL,themeVARCHAR(32) NULL DEFAULT '',tokenVARCHAR(24) NULL DEFAULT NULL,token_valid_untilDATETIME NULL,module_permissionsvarchar(255) DEFAULT '{"vlan":"1","l2dom":"1","vrf":"1","pdns":"1","circuits":"1","racks":"1","nat":"1","pstn":"1","customers":"1","locations":"1","devices":"1","routing":"1","vaults":"1"}',compress_actions TINYINT(1) NULL DEFAULT '1', PRIMARY KEY (username), UNIQUE KEY id_2 (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Cannot install sql SCHEMA file: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes query that failed: CREATE TABLE
(
int(11) NOT NULL AUTO_INCREMENT,
varchar(255) NOT NULL DEFAULT '',
INT(2) NULL DEFAULT 1,
CHAR(128) DEFAULT NULL,
varchar(1024) DEFAULT NULL,
text,
varchar(128) DEFAULT NULL,
varchar(254) DEFAULT NULL,
binary(1) DEFAULT '0',
VARCHAR(1024) NULL DEFAULT 'statistics;favourite_subnets;changelog;top10_hosts_v4',
INT(11) UNSIGNED NULL DEFAULT '9',
VARCHAR(1024) NULL DEFAULT NULL,
ENUM('Yes','No') NOT NULL DEFAULT 'No',
TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP,
TIMESTAMP NULL,
ENUM('default','Uncompress') NOT NULL DEFAULT 'default',
tinyint(1) DEFAULT '0',
ENUM('Static','Dynamic') NOT NULL DEFAULT 'Dynamic',
TINYINT NULL DEFAULT '1',
BOOL NOT NULL DEFAULT '0',
VARCHAR(32) NULL DEFAULT NULL,
VARCHAR(32) NULL DEFAULT '',
VARCHAR(24) NULL DEFAULT NULL,
DATETIME NULL,
varchar(255) DEFAULT '{"vlan":"1","l2dom":"1","vrf":"1","pdns":"1","circuits":"1","racks":"1","nat":"1","pstn":"1","customers":"1","locations":"1","devices":"1","routing":"1","vaults":"1"}',
TINYINT(1) NULL DEFAULT '1', PRIMARY KEY (
), UNIQUE KEY
) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
The Docker is running on a Ugreen NAS.
What can I do to get past step 2?
Thanks for the help. Best regards.
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Hello everyone,
I followed the installation instructions, but now I'm encountering the following error during the SQL setup:
Cannot install sql SCHEMA file: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes query that failed: CREATE TABLE
users(
idint(11) NOT NULL AUTO_INCREMENT,
usernamevarchar(255) NOT NULL DEFAULT '',
authMethodINT(2) NULL DEFAULT 1,
passwordCHAR(128) DEFAULT NULL,
groupsvarchar(1024) DEFAULT NULL,
roletext,
real_namevarchar(128) DEFAULT NULL,
emailvarchar(254) DEFAULT NULL,
domainUserbinary(1) DEFAULT '0',
widgetsVARCHAR(1024) NULL DEFAULT 'statistics;favourite_subnets;changelog;top10_hosts_v4',
langINT(11) UNSIGNED NULL DEFAULT '9',
favourite_subnetsVARCHAR(1024) NULL DEFAULT NULL,
disabledENUM('Yes','No') NOT NULL DEFAULT 'No',
mailNotifyENUM('Yes','No') NOT NULL DEFAULT 'No',
mailChangelogENUM('Yes','No') NOT NULL DEFAULT 'No',
passChangeENUM('Yes','No') NOT NULL DEFAULT 'No',
editDateTIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP,
lastLoginTIMESTAMP NULL,
lastActivityTIMESTAMP NULL,
compressOverrideENUM('default','Uncompress') NOT NULL DEFAULT 'default',
hideFreeRangetinyint(1) DEFAULT '0',
menuTypeENUM('Static','Dynamic') NOT NULL DEFAULT 'Dynamic',
menuCompactTINYINT NULL DEFAULT '1',
2faBOOL NOT NULL DEFAULT '0',
2fa_secretVARCHAR(32) NULL DEFAULT NULL,
themeVARCHAR(32) NULL DEFAULT '',
tokenVARCHAR(24) NULL DEFAULT NULL,
token_valid_untilDATETIME NULL,
module_permissionsvarchar(255) DEFAULT '{"vlan":"1","l2dom":"1","vrf":"1","pdns":"1","circuits":"1","racks":"1","nat":"1","pstn":"1","customers":"1","locations":"1","devices":"1","routing":"1","vaults":"1"}',
compress_actionsTINYINT(1) NULL DEFAULT '1', PRIMARY KEY (
username), UNIQUE KEY
id_2(
id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
The Docker is running on a Ugreen NAS.
What can I do to get past step 2?
Thanks for the help.
Best regards.
The text was updated successfully, but these errors were encountered: