Hi Tim, I meant to submit this problem as well. I see it on Fedora Core 5. The workaround for me is rather simple. I replace email field length from 255 to 100 (if I remember it correctly, there are 3 places in install.pl where it should be done).
After that, everything works fine. Thanks, --Vladimir On 7/20/06, Tim Casada <[EMAIL PROTECTED]> wrote: > 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 > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Codestriker-user mailing list > Codestriker-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/codestriker-user > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Codestriker-user mailing list Codestriker-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/codestriker-user
