#25046 [Asn->Csd]: autoUpdate() function within PEAR DB Error Out
| From: | cox@php.net | Date: | Tue, 12 Aug 2003 12:10:43 +0000 |
| Subject: | #25046 [Asn->Csd]: autoUpdate() function within PEAR DB Error Out | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-19557@lists.php.net to get a copy of this message | ||
ID: 25046
Updated by: cox@php.net
Reported By: robhines at sbcglobal dot net
-Status: Assigned
+Status: Closed
Bug Type: PEAR related
Operating System: RedHat Linux
PHP Version: 4.3.2
Assigned To: cox
New Comment:
This bug was fixed long time ago, please upgrade your PEAR DB. Thanks
anyways.
Previous Comments:
------------------------------------------------------------------------
[2003-08-11 16:23:01] robhines at sbcglobal dot net
Description:
------------
When attempting to use the autoUpdate() function within PEAR DB I was
continually getting error msgs. Upon further inspection I traced the
problem to an apparent typo on ~line 562 of the
/usr/share/pear/DB/common.php file. Here is a snippet of the code I
found there:
function buildManipSQL($table, $table_fields, $mode, $where = false)
<...>
if ($where) {
$sql .= " WHERE $sql"; <--BAD CODE [rsh]
}
<...>
}
Here is how I modified it so that it now works as advertised.
function buildManipSQL($table, $table_fields, $mode, $where = false)
<...>
if ($where) {
$sql .= " WHERE $where"; //This code works! [rsh]
}
<...>
}
I hope that helps. Thanks for all your hard work!
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=25046&edit=1