[BioSQL-l] error with load_ontology

[Song Haili]

Problem solved!
If the file type of synonym of the table of term_synonym is changed from varchar(255) to text, there is no error occurred anymore. However this only works for biosql-1.0.0 (maybe it also works for the latest version biosql-1.0.1, but I didn't do many test). 
Thank you all for your help.
song

----- Original Message -----
From: Peter <biopython at maubp.freeserve.co.uk>
Date: Thursday, August 27, 2009 12:24
Subject: Re: [BioSQL-l] error with load_ontology
To: Song Haili <haili at mpiz-koeln.mpg.de>
Cc: Hilmar Lapp <hlapp at gmx.net>, biosql-l at lists.open-bio.org

> On Thu, Aug 27, 2009 at 8:51 AM, Song Haili wrote:
> 
> > --------------------- WARNING ---------------------
> > MSG: failed to store term synonym 
> (Bio::DB::BioSQL::TermAdaptor) with values (alternating UDP-
> alpha-N-acetyl-D-glucosamine:beta-D-glucuronosyl-(1->3)-nascent 
> hyaluronan 4-N-acetyl-beta-D-glucosaminyltransferase and UDP-
> alpha-D-glucuronate:N-acetyl-beta-D-glucosaminyl-(1->4)-nascent 
> hyaluronan 3-beta-D-glucuronosyltransferase activity EXACT 
> EC:2.4.1.212) (FK 20401 to Bio::Ontology::OBOterm):
> > ERROR:  value too long for type character varying(255)
> > ---------------------------------------------------
> 
> Extending the relevant field in the schema might be one solution...
> 
> > I am using biosql-1.0.0 downloaded directly from
> > http://www.biosql.org/wiki/Downloads without any changes.
> > So I am not sure if the RULEs have been removed. By the
> > way, before I met the above error, I was able to use the script
> > load_seqdatabase.pl to load swissprot data with many warnings.
> 
> BioSQL 1.0.0 is out of date, the latest release is 1.0.1
> Was that a typo?
> 
> Peter