[Gmod-help] Re:Re: [GMOD-devel] help

[wangjun19820303]

hi Dave,
    A few days ago I delete all data in Chado database, then I imported my gff file,it's ok.There isn't error.So I don't know
why it is .Maybe that's my gff problem. Thank you!!!


在2010-04-22 02:31:44，"Dave Clements, GMOD Help Desk" <help at gmod.org> 写道：
Hi Wangjun,


I'm CC'ing the Schema/Chado list, which is probably a better place to discuss this question.


I talked to Scott Cain about this:  Make sure that BioPerl and schema are up to date, and if that doesn't fix it, run the loader with the --save option so the tmp files get saved. Then you can find the line in the featureloc file that is offending.  If that approach doesn't result in solving the problem, then we might need to see the GFF that is causing the problem.


Thanks


Dave C


2010/4/15 wangjun19820303 <wangjun19820303 at 163.com>
hi all,
    When I was importing blast result gff3 file into chado database using  gmod_bulk_load_gff3.pl, I got  the errors like this:
    DBD::Pg::db commit failed: ERROR:  insert or update on table "featureloc" violates foreign key constraint "featureloc_srcfeature_id_fkey"
DETAIL:  Key (srcfeature_id)=(177) is not present in table "feature". at /usr/local/share/perl/5.10.1/Bio/GMOD/DB/Adapter.pm line 2651, <$fh> line 4190.
commit failed: ERROR:  insert or update on table "featureloc" violates foreign key constraint "featureloc_srcfeature_id_fkey"
DETAIL:  Key (srcfeature_id)=(177) is not present in table "feature". at /usr/local/share/perl/5.10.1/Bio/GMOD/DB/Adapter.pm line 2651, <$fh> line 4190.
I don't know why and how to handle. Could you help me?
I am looking forward to your reply.

Wangjun




------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Gmod-devel mailing list
Gmod-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gmod-devel





-- 
===> PLEASE KEEP RESPONSES ON THE LIST <===
http://gmod.org/wiki/GMOD_Logo_Program
http://gmod.org/wiki/GMOD_News
Was this helpful? http://gmod.org/wiki/Help_Desk_Feedback
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://brie4.cshl.edu/pipermail/gmod-help/attachments/20100422/1f520c20/attachment.html>