* user warning: Specified key was too long; max key length is 1000 bytes query: CREATE TABLE search_log ( `qid` INT( 11 ) NOT NULL AUTO_INCREMENT , `q` VARCHAR( 255 ) NOT NULL , `module` VARCHAR( 255 ) NOT NULL , `time` INT( 11 ) NULL DEFAULT '0', `counter` INT( 11 ) NULL DEFAULT '0', `failed` TINYINT( 1 ) UNSIGNED NULL DEFAULT '0', PRIMARY KEY ( `qid` ), UNIQUE KEY `q` (q,module,time)) in /home/www/grusha.org.ua/HTDOCS/grusha/includes/database.mysql.inc on line 174.
* Search Log installation unsuccessful. Tables may need to be installed manually.

Comments

vitovt’s picture

vitovt commented

This helps me:

mysql> CREATE TABLE `search_log`
-> (
-> `qid` INT( 11 ) NOT NULL ,
-> `q` VARCHAR( 255 ) NOT NULL ,
-> `module` VARCHAR( 255 ) NOT NULL ,
-> `time` VARCHAR( 255 ) NOT NULL ,
-> `counter` INT( 11 ) NULL DEFAULT '0',
-> `failed` TINYINT( 1 ) UNSIGNED NULL DEFAULT '0',
-> PRIMARY KEY ( `qid` ) ,
-> UNIQUE (`q`)
-> ) ENGINE = MYISAM ;
Query OK, 0 rows affected (0.01 sec)

john.money’s picture

john.money commented
Title: utf-8 key size bug in table install » error creating database
Assigned: john.money » Unassigned
Status: Fixed » Active

Thanks for bug report.

Please download release 1.01.

john.money’s picture

john.money commented
Title: error creating database » utf-8 key size bug in table install
Assigned: Unassigned » john.money
Status: Active » Fixed

Marking fixed.

Title: error creating database » utf-8 key size bug in table install
Assigned: Unassigned » john.money
Status: Active » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.