Jump to content

Ошибка CREATE TABLE core_tags_perms


Draco-Zero
 Share

Recommended Posts

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               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...