mySQL query error: CREATE TABLE core_tags_perms (
tag_perm_aai_lookup CHAR(32) NOT NULL DEFAULT '',
tag_perm_aap_lookup CHAR(32) NOT NULL DEFAULT '',
tag_perm_text VARCHAR(255) NOT NULL DEFAULT '',
tag_perm_visible INT(1) NOT NULL DEFAULT 1,
UNIQUE KEY tag_perm_aai_lookup (tag_perm_aai_lookup),
KEY tag_perm_aap_lookup( tag_perm_aap_lookup ),
KEY tag_lookup (tag_perm_text, tag_perm_visible)
) ENGINE=MyISAM;
SQL error: Specified key was too long; max key length is 1000 bytes
SQL error code: 1071
Date: Friday 02nd June 2017 01:04:51 PM
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Fri, 02 Jun 2017 13:04:51 +0000
Error: 1071 - Specified key was too long; max key length is 1000 bytes
IP Address: 127.0.0.1 - /admin/install/index.php?app=install§ion=install&do=sql
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: CREATE TABLE core_tags_perms (
tag_perm_aai_lookup CHAR(32) NOT NULL DEFAULT '',
tag_perm_aap_lookup CHAR(32) NOT NULL DEFAULT '',
tag_perm_text VARCHAR(255) NOT NULL DEFAULT '',
tag_perm_visible INT(1) NOT NULL DEFAULT 1,
UNIQUE KEY tag_perm_aai_lookup (tag_perm_aai_lookup),
KEY tag_perm_aap_lookup( tag_perm_aap_lookup ),
KEY tag_lookup (tag_perm_text, tag_perm_visible)
) ENGINE=MyISAM;
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/setup/applications/install/sections/install.php | [install_install].install_sql | 89 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/setup/sources/base/ipsController_setup.php | [install_install].doExecute | 258 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'