[Bioperl-l] Different versions of biosql schema and bioperl-db

dugas at mediagen.fr dugas at mediagen.fr
Fri Mar 28 11:18:10 EST 2003


Helllo,

Your problem is that you don't use the correct biosql schema.
The script load_seqdatabase.pl version you are using need the biosql 
schema released with the tag MAIN, in this schema there's no display_id 
field in the bioentry table.

On Fri, 28 Mar 2003, Zayed  Albertyn wrote:

> Hi
> 
> I am trying use the biosql schema to create a sequence database but it
> doesnt seem to be working. The problem is with loading a set of sequences
> into a database.
> 
> I am working with the bioperl 1.0.2 and the biosql schema (downloaded 14th
> March). There seems to be some kind of incompatibilities between the
> load_seqdatabase.pl script and the mysql table because I get the following
> error message:  My sequences are all in Genbank format and I have checked
> that bioperl-db is installed.
> 
> DBD::mysql::st execute failed: Unknown column 'display_id' in 'field list'
> at /usr/lib/perl5/site_perl/5.6.1/Bio/DB/SQL/SeqAdaptor.pm line 427,
> <GEN0> line 169.
> DBD::mysql::st execute failed: Unknown column 'display_id' in 'field list'
> at /usr/lib/perl5/site_perl/5.6.1/Bio/DB/SQL/SeqAdaptor.pm line 427,
> <GEN0> line 169.
> 
> 
> Please help.
> Thanks
> Zayed
> 
> -----------------------------------------------
> From: Zayed Albertyn
> Electric Genetics PTY Ltd
> Tel: +27 21 959 3645; Mobile: +2782 480 6097
> www.egenetics.com
> _______________________________________________
> Bioperl-l mailing list
> Bioperl-l at bioperl.org
> http://bioperl.org/mailman/listinfo/bioperl-l
> 

-- 
Olivier DUGAS
Bioinformatics Manager

Mediagen SAS
Institut Pasteur de Lille
1, rue du Professeur Calmette
Bâtiment Guérin, 3eme étage, BP 245
59019 LILLE Cedex
Tel +33 3 20 87 72 76
Fax +33 3 20 87 72 82




More information about the Bioperl-l mailing list