hi Dave,<br> 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<br>why it is .Maybe that's my gff problem. Thank you!!!<br><div></div><br>ÔÚ2010-04-22 02:31:44£¬"Dave Clements, GMOD Help Desk" <help@gmod.org> дµÀ£º<br> <blockquote id="isReplyContent" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">Hi Wangjun,<div><br></div><div>I'm CC'ing the Schema/Chado list, which is probably a better place to discuss this question.</div><div><br></div><div>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.</div>
<div><br></div><div>Thanks</div><div><br></div><div>Dave C</div><div><br></div><div><div class="gmail_quote">2010/4/15 wangjun19820303 <span dir="ltr"><<a href="mailto:wangjun19820303@163.com">wangjun19820303@163.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">hi all,<br> When I was importing blast result gff3 file into chado database using <a href="http://gmod_bulk_load_gff3.pl" target="_blank">gmod_bulk_load_gff3.pl</a>, I got the errors like this:<br>
DBD::Pg::db commit failed: ERROR: insert or update on table "featureloc" violates foreign key constraint "featureloc_srcfeature_id_fkey"<br>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.<br>
commit failed: ERROR: insert or update on table "featureloc" violates foreign key constraint "featureloc_srcfeature_id_fkey"<br>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.<br>
I don't know why and how to handle. Could you help me?<br>I am looking forward to your reply.<br><br>Wangjun<br><br><br><br><span title="neteasefooter"></span><br>------------------------------------------------------------------------------<br>
Download Intel&#174; Parallel Studio Eval<br>
Try the new software tools for yourself. Speed compiling, find bugs<br>
proactively, and fine-tune applications for parallel performance.<br>
See why Intel Parallel Studio got high marks during beta.<br>
<a href="http://p.sf.net/sfu/intel-sw-dev" target="_blank">http://p.sf.net/sfu/intel-sw-dev</a><br>_______________________________________________<br>
Gmod-devel mailing list<br>
<a href="mailto:Gmod-devel@lists.sourceforge.net">Gmod-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/gmod-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/gmod-devel</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>===> PLEASE KEEP RESPONSES ON THE LIST <===<br><a href="http://gmod.org/wiki/GMOD_Logo_Program">http://gmod.org/wiki/GMOD_Logo_Program</a><br><a href="http://gmod.org/wiki/GMOD_News">http://gmod.org/wiki/GMOD_News</a><br>
Was this helpful? <a href="http://gmod.org/wiki/Help_Desk_Feedback">http://gmod.org/wiki/Help_Desk_Feedback</a><br><br>
</div>
</blockquote><br><br><span title="neteasefooter"/></span>