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