[Bioperl-l] problem using load_seqdatabase.pl with biosql

[Hilmar Lapp]

display_id was renamed to name in the Singapore version. You need to 
get a recent download of biosql-schema and make sure that's the schema 
version you have instantiated.

	-hilmar

On Wednesday, December 10, 2003, at 04:22  PM, John Yao wrote:

>
> I created the biosql schema in a mySQL server and tried to load a 
> swissprot database. I was able to populate the database with taxonomy 
> data with load_ncbi_taxnomy.pl
>
> However, When I tried to load a swissprot database I got the follwoing 
> errors:
>
> /load_seqdatabase.pl --sqldb swiss  --format swiss 
> swissprot/sprot42.dat
>
>
> Reading swissprot/sprot42.dat
> DBD::mysql::st execute failed: Unknown column 'display_id' in 'field 
> list' at /usr/lib/perl5/site_perl/5.6.0/Bio/DB/SQL/SeqAdaptor.pm line 
> 427, <GEN0> line 53.
> DBD::mysql::st execute failed: Unknown column 'display_id' in 'field 
> list' at /usr/lib/perl5/site_perl/5.6.0/Bio/DB/SQL/SeqAdaptor.pm line 
> 427, <GEN0> line 53.
>
> It complained about not being able to find display_id.
>
> When I looked at the schema diagram (in pdf) and also checked the 
> database tables, indeed, there is no column of display_id. Display_id 
> was described in the schema-overview.txt but was missing is the actual 
> schema.
>
> help!
>
>
> John Yao
>
> _________________________________________________________________
> Shop online for kids’ toys by age group, price range, and toy category 
> at MSN Shopping. No waiting for a clerk to help you! 
> http://shopping.msn.com
>
> _______________________________________________
> Bioperl-l mailing list
> Bioperl-l at portal.open-bio.org
> http://portal.open-bio.org/mailman/listinfo/bioperl-l
>
>
-- 
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------