<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>CHADO Ontologies Install</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">I am running into a error during the manual ontology installation that manifests pretty much identical to the error described in #1 on the chado 0.003 FAQ (</FONT><A HREF="http://gmod.sourceforge.net/schema/gmod-0.003-faq.shtml"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://gmod.sourceforge.net/schema/gmod-0.003-faq.shtml</FONT></U></A><FONT SIZE=2 FACE="Arial">). The fix being to apply a patch to Class::DB::Pg. I could not find the patch in the source tree or on sourceforge as described in </FONT><A HREF="http://sourceforge.net/project/shownotes.php?release_id=340674"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://sourceforge.net/project/shownotes.php?release_id=340674</FONT></U></A><FONT SIZE=2 FACE="Arial"> . Is the patch still necessary and if so is it available?</FONT></P>
<P><FONT SIZE=2 FACE="Arial">The specific command and error follow:</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">gmod_load_ontology.pl ./tmp/manual_dwnld/ro.obo</FONT>
<BR><FONT SIZE=2 FACE="Arial">DBD::Pg::st execute failed: ERROR: more than one row returned by a subquery used as an expression</FONT>
<BR><FONT SIZE=2 FACE="Arial"> [for Statement "SELECT indkey FROM pg_catalog.pg_index</FONT>
<BR><FONT SIZE=2 FACE="Arial">WHERE indisprimary=true AND indrelid=(</FONT>
<BR><FONT SIZE=2 FACE="Arial">SELECT oid FROM pg_catalog.pg_class</FONT>
<BR><FONT SIZE=2 FACE="Arial">WHERE relname = ?)</FONT>
<BR><FONT SIZE=2 FACE="Arial">" with ParamValues: 1='db'] at /usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line 52.</FONT>
<BR><FONT SIZE=2 FACE="Arial">Compilation failed in require at lib/Chado/LoadDBI.pm line 5.</FONT>
<BR><FONT SIZE=2 FACE="Arial">BEGIN failed--compilation aborted at lib/Chado/LoadDBI.pm line 5.</FONT>
<BR><FONT SIZE=2 FACE="Arial">Compilation failed in require at /usr/bin/gmod_load_ontology.pl line 10.</FONT>
<BR><FONT SIZE=2 FACE="Arial">BEGIN failed--compilation aborted at /usr/bin/gmod_load_ontology.pl line 10.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Todd</FONT>
</P>
<BR>
<P><B><SPAN LANG="en-gb"><FONT COLOR="#808080" SIZE=1 FACE="Arial">Todd Moughamer</FONT></SPAN></B>
<P ALIGN=JUSTIFY><SPAN LANG="en-gb"><FONT COLOR="#808080" SIZE=1 FACE="Arial">Bioinformatics Consultancy & Training Group</FONT></SPAN></P>
<P ALIGN=JUSTIFY><SPAN LANG="en-gb"><FONT COLOR="#808080" SIZE=1 FACE="Arial">Syngenta Biotechnology, Inc.</FONT></SPAN></P>
<P ALIGN=JUSTIFY><SPAN LANG="en-gb"><FONT COLOR="#808080" SIZE=1 FACE="Arial">3054 Cornwallis Road, 1243.E</FONT></SPAN></P>
<P ALIGN=JUSTIFY><SPAN LANG="en-gb"><FONT COLOR="#808080" SIZE=1 FACE="Arial">Research Triangle Park, NC 27709-2257</FONT></SPAN></P>
<P ALIGN=JUSTIFY><SPAN LANG="en-gb"><FONT COLOR="#808080" SIZE=1 FACE="Arial">Tel: 919-597-3078</FONT></SPAN></P>
<P><SPAN LANG="en-gb"><FONT COLOR="#808080" SIZE=1 FACE="Arial">Email: todd.moughamer@syngenta.com</FONT></SPAN>
<BR><SPAN LANG="en-gb"><U></U></SPAN><A HREF="file://www.syngenta.com"><SPAN LANG="en-gb"><U><FONT COLOR="#0000FF" SIZE=1 FACE="Arial">www.syngenta.com</FONT></U><U></U></SPAN></A><SPAN LANG="en-gb"><U></U></SPAN><SPAN LANG="en-us"></SPAN>
</P>
<BR>
</BODY>
</HTML>