[ensembl-dev] [ensemblgenomes] exception when using list_stable_ids() with Borrelia recurrentis

Giuseppe G. G.Gallone at sms.ed.ac.uk
Wed Aug 10 19:11:18 BST 2011


Hi,

I was trying to retrieve the gene list for Borrelia recurrentis and 
stumbled upon the following exception after doing

my $gene_adaptor = $registry->get_adaptor('Borrelia 
recurrentis','core','Gene');
my @genes = @{$gene_adaptor->list_stable_ids()};


DBD::mysql::st execute failed: Unknown column 'seq_region_id' in 'from 
clause' at 
/home/giuseppe/src/ensembl/modules/Bio/EnsEMBL/DBSQL/BaseAdaptor.pm line 
299.

-------------------- EXCEPTION --------------------
MSG: Detected an error whilst executing SQL 'SELECT stable_id FROM 
gene_stable_id
JOIN seq_region USING (seq_region_id)
JOIN coord_system cs USING (coord_system_id)
WHERE cs.species_id = ?
': DBD::mysql::st execute failed: Unknown column 'seq_region_id' in 
'from clause' at /ensembl/modules/Bio/EnsEMBL/DBSQL/BaseAdaptor.pm line 299.

STACK Bio::EnsEMBL::DBSQL::BaseAdaptor::_list_dbIDs 
ensembl/modules/Bio/EnsEMBL/DBSQL/BaseAdaptor.pm:300
STACK Bio::EnsEMBL::DBSQL::GeneAdaptor::list_stable_ids 
/ensembl/modules/Bio/EnsEMBL/DBSQL/GeneAdaptor.pm:172
Ensembl API version = 63
---------------------------------------------------


Your help is as usual greatly appreciated.

Best,
G
-- 

The University of Edinburgh is a charitable body, registered in 
Scotland, with registration number SC005336.




More information about the Dev mailing list