<HTML><BODY DEFANGED_STYLE="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">A little more information on my db problem:<DIV><BR class="khtml-block-placeholder"></DIV><DIV>I discovered that this works just fine:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>db.select table=colonies database=tx_state_nad83 driver=mysql sql="select abbrv from colonies"</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>However, this does not work:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>db.select table=colonies database=tx_state_nad83 driver=mysql sql="select * from colonies"</DIV><DIV>dbmi: Protocol error</DIV><DIV>Broken pipe</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>If i use a column name in the select statement, everything works fine. If I use an * or a column name that doesn't exist, I get the errors above, namely:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>dbmi: Protocol error</DIV><DIV>Broken pipe</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I hope that sheds some light on the problem. Does anyone know what's happening here?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>- Jason</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR><DIV> <P DEFANGED_STYLE="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">Jason Horn</FONT></P> <P DEFANGED_STYLE="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">Boston University Department of Biology</FONT></P> <P DEFANGED_STYLE="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">5 Cumington Street<SPAN class="Apple-converted-space"> </SPAN>Boston, MA 02215</FONT></P> <P DEFANGED_STYLE="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><BR></P> <P DEFANGED_STYLE="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" DEFANGED_STYLE="font: 12.0px Helvetica"><A href="mailto:jhorn@bu.edu">jhorn@bu.edu</A></FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">office: 617 353 6987</FONT></P> <P DEFANGED_STYLE="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">cell: 401 588 2766</FONT></P> <BR class="Apple-interchange-newline"> </DIV><BR><DIV><DIV>On Sep 13, 2005, at 1:51 PM, Jason Horn wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Does anyone know how to resolve errors that result from db.test?<SPAN class="Apple-converted-space"> </SPAN>For example, see the error below:</DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">select * from grass_test1</DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">dbmi: Protocol error</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">/Applications/grass61cvs.app/Contents/Resources/grass-6.1.cvs/scripts/db.test: line 85: 15700 Done<SPAN class="Apple-converted-space"> </SPAN>echo "$SQL"</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-converted-space"> </SPAN>15701 Broken pipe <SPAN class="Apple-converted-space"> </SPAN>| db.select -c >$result</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">EXECUTE: ******** ERROR ********</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">0a1,2</DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">> 1|123.456000|abcd</DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">> 2||xxx</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">RESULT: ******** ERROR ********</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV> <BR class="Apple-interchange-newline"></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>