[Bioperl-l] DB::SeqFeature::Store error

Chris Fields cjfields at uiuc.edu
Sun Sep 30 20:39:23 UTC 2007


I'm getting the following error on my local MySQL (v 5.0.41) with  
bp_seqfeature_load:

-------------------- EXCEPTION --------------------
MSG: The used table type doesn't support FULLTEXT indexes
STACK Bio::DB::SeqFeature::Store::DBI::mysql::_init_database /Library/ 
Perl/5.8.6/Bio/DB/SeqFeature/Store/DBI/mysql.pm:414
STACK Bio::DB::SeqFeature::Store::init_database /Library/Perl/5.8.6/ 
Bio/DB/SeqFeature/Store.pm:382
STACK Bio::DB::SeqFeature::Store::DBI::mysql::init /Library/Perl/ 
5.8.6/Bio/DB/SeqFeature/Store/DBI/mysql.pm:218
STACK Bio::DB::SeqFeature::Store::new /Library/Perl/5.8.6/Bio/DB/ 
SeqFeature/Store.pm:345
STACK toplevel /usr/local/bin/bp_seqfeature_load.pl:57
-------------------------------------------

The default setting for storage is InnoDB; switching to MyISAM fixes  
the issue.  Should we specify TYPE = MyISAM with the various CREATE  
TABLE queries in Bio::DB::SeqFeature::Store::DBI::mysql to be on the  
safe side?

chris



More information about the Bioperl-l mailing list