#21963 [NEW]: Pear DB's autoPrepare fails DB_AUTOQUERY_UPDATEs

From: samuli.tuomola@icinsight.com Operating system: Debian Linux 3.0 PHP version: 4.3.0 PHP Bug Type: PEAR related Bug description: Pear DB's autoPrepare fails DB_AUTOQUERY_UPDATEs After getting autoPrepare finally to run I was greeted with sql query like "UPDATE table SET field=? WHERE UPDATE table SET field=?" after doublechecking the code I opened DB/common.php and there in buildManipSQL() on line 526 it said $sql .= " WHERE $sql"; when it obviously should've been $sql .= " WHERE $where"; Didn't find the bug reported although it must've been there over half a year and severely damages autoPrepare functionality. -- Edit bug report at http://bugs.php.net/?id=21963&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=21963&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=21963&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=21963&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=21963&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=21963&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=21963&r=support Expected behavior: http://bugs.php.net/fix.php?id=21963&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=21963&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=21963&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=21963&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21963&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=21963&r=dst IIS Stability: http://bugs.php.net/fix.php?id=21963&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=21963&r=gnused