<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head><meta http-equiv="Content-Type" content="text/html; charset=ANSI_X3.4-1968"><title>A.4. DBD::Sponge::db prepare failed</title><link rel="stylesheet" type="text/css" href="../../style.css"><meta name="generator" content="DocBook XSL Stylesheets V1.78.1"><meta name="keywords" content="Bugzilla, Guide, installation, FAQ, administration, integration, MySQL, Mozilla, webtools"><link rel="home" href="index.html" title="The Bugzilla Guide - 4.4.12 Release"><link rel="up" href="troubleshooting.html" title="Appendix A. Troubleshooting"><link rel="prev" href="trbl-perlmodule.html" title="A.3. I installed a Perl module, but checksetup.pl claims it's not installed!"><link rel="next" href="paranoid-security.html" title="A.5. cannot chdir(/var/spool/mqueue)"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">A.4. DBD::Sponge::db prepare failed</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="trbl-perlmodule.html">Prev</a> </td><th width="60%" align="center">Appendix A. Troubleshooting</th><td width="20%" align="right"> <a accesskey="n" href="paranoid-security.html">Next</a></td></tr></table><hr></div><div class="section"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="trbl-dbdSponge"></a>A.4. DBD::Sponge::db prepare failed</h2></div></div></div><p>The following error message may appear due to a bug in DBD::mysql
(over which the Bugzilla team have no control):
</p><pre class="programlisting"> DBD::Sponge::db prepare failed: Cannot determine NUM_OF_FIELDS at D:/Perl/site/lib/DBD/mysql.pm line 248.
SV = NULL(0x0) at 0x20fc444
REFCNT = 1
FLAGS = (PADBUSY,PADMY)
</pre><p>To fix this, go to
<code class="filename"><path-to-perl>/lib/DBD/sponge.pm</code>
in your Perl installation and replace
</p><pre class="programlisting"> my $numFields;
if ($attribs->{'NUM_OF_FIELDS'}) {
$numFields = $attribs->{'NUM_OF_FIELDS'};
} elsif ($attribs->{'NAME'}) {
$numFields = @{$attribs->{NAME}};
</pre><p>with</p><pre class="programlisting"> my $numFields;
if ($attribs->{'NUM_OF_FIELDS'}) {
$numFields = $attribs->{'NUM_OF_FIELDS'};
} elsif ($attribs->{'NAMES'}) {
$numFields = @{$attribs->{NAMES}};
</pre><p>(note the S added to NAME.)</p></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="trbl-perlmodule.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="troubleshooting.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="paranoid-security.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">A.3. I installed a Perl module, but
<code class="filename">checksetup.pl</code> claims it's not installed! </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> A.5. cannot chdir(/var/spool/mqueue)</td></tr></table></div></body></html>
