title: VBulletin 5.4.0 installation Error: 1071
body: <p>Today I Was Installing Vbulletin For The First Time And During The Installation, It Gave This Error.</p>
  
  <blockquote>
    <p>Creating userchangelog table An error has occurred with your database.
    Please contact vBulletin Support for assistance.</p>
    
    <p>Module: install, Step 3 Database Error:1071</p>
    
    <p>Specified key was too long; max key length is 1000 bytes</p>
    
    <p>Query:</p>
    
    <p>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 Status: Aborted</p>
    
    <p>Version<br> VBulletin: 5.4.0<br> PHP: 7.0<br> MYSQL: I Have No Idea!</p>
  </blockquote>
  
  <p>Before The Installation, I Run A Script Called <a href="https://files.vbulletin.com/vb_test.zip" rel="nofollow noreferrer">vb_test.php</a> The Result Said That VBulletin 5.4.0 Can Run On This Server Without Any Error</p>