[Codestriker-user] 1.9.2 Database Creation UTF8

[Tim C. <tim...@sh...>]

I am having a problem with database creation in 1.9.2 on RHEL4 with 
MySQL 4.1.20.  When I run install.pl I get the following error message:

Checking for  LWP::UserAgent (any)     ok: found v2.031
Checking for             CGI (v2.56)   ok: found v3.05
Checking for       Net::SMTP (any)     ok: found v2.29
Checking for MIME::QuotedPrint (any)     ok: found v3.07
Checking for             DBI (v1.13)   ok: found v1.40
Checking for        Template (v2.07)   ok: found v2.15
Checking for  HTML::Entities (any)     ok: found v1.27
Checking for      File::Temp (any)     ok: found v0.16
Checking for        XML::RSS (v1.05)   ok: found v1.10
Checking for    Encode::Byte (any)     ok: found v2.00
Checking for Encode::Unicode (any)     ok: found v2.00
Checking for    Authen::SASL (any)     ok: found v2.10
Checking for      DBD::mysql (any)     ok: found v2.9004
Creating table topicusermetric...
DBD::mysql::db do failed: Specified key was too long; max key length is 
1000 bytes at ../lib/Codestriker/DB/Database.pm line 137.
Unable to create table/indexes.

Three tables get created successfully.

mysql> show tables;
+--------------------------+
| Tables_in_codestrikerdb2 |
+--------------------------+
| topic                    |
| topichistory             |
| topicviewhistory         |
+--------------------------+
3 rows in set (0.00 sec)


Any ideas?

Thanks,

-- 
Tim Casada