problem to install

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MrCriticalRx
    New Member
    • Jan 2016
    • 27
    • 5.1.x

    #16
    is that the same error ?¿

    Module: install, Step 3 Database Error:1071

    Specified key was too long; max key length is 1000 bytes

    Query:
    CREATE TABLE userchangelog ( changeid INT UNSIGNED NOT NULL AUTO_INCREMENT, userid INT UNSIGNED NOT NULL DEFAULT '0', fieldname VARCHAR(250) NOT NULL DEFAULT '', newvalue VARCHAR(250) NOT NULL DEFAULT '', oldvalue VARCHAR(250) NOT NULL DEFAULT '', adminid INT UNSIGNED NOT NULL DEFAULT '0', change_time INT UNSIGNED NOT NULL DEFAULT '0', change_uniq VARCHAR(32) NOT NULL DEFAULT '', ipaddress INT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (changeid), KEY userid (userid,change_time), KEY change_time (change_time), KEY change_uniq (change_uniq), KEY fieldname (fieldname,change_time), KEY adminid (adminid,change_time) ) ENGINE = MyISAM

    Comment

    • Wayne Luke
      vBulletin Technical Support Lead
      • Aug 2000
      • 73979

      #17
      This is the exact same error that you have had before. The fix is listed in post #4 of this topic. This is a MySQL configuration issue.

      On versions of MySQL earlier than 5.7.7, the default settings requires INNODB indexes to be 767 bytes or shorter. You will either need to change the setting already mentioned or manually edit the /core/install/mysql-schema.php file to make sure every single VARCHAR is 191 characters or less. However, editing this file will limit the functionality of your software. This is not something that we will change in the software since the setting listed above resolves the issue and is the default in MySQL 5.7.7 and higher.

      We do not test with MariaDB. It should be a drop in replacement of MySQL and support the same options. MariaDB 10.x is a fork of MySQL 5.6. If your version of MariaDB doesn't support this option, then you will need to switch to MySQL. We recommend using the latest version of MySQL 5.7 for the best support.
      Last edited by Wayne Luke; Mon 30 Apr '18, 8:44am.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API

      Comment

      Related Topics

      Collapse

      Working...