#38518 [NEW]: Unable to allocate when deleting last row

From: Date: Sun, 20 Aug 2006 09:18:15 +0000
Subject: #38518 [NEW]: Unable to allocate when deleting last row
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-100974@lists.php.net to get a copy of this message
From: jelle at v-essen dot nl Operating system: Windows XP SP2 PHP version: 5.1.5 PHP Bug Type: ODBC related Bug description: Unable to allocate when deleting last row Description: ------------ I've seen more people have emalloc() errors, but their situations seem other than my situation. Whenever I try to delete the last row from a table, it fails. I haven't found a solution in other bug reports. Oh, yeah: the first time I tried the script, I got a php-cgi.exe error message. When I refreshed the page, I got the emalloc error. Reproduce code: --------------- <?php $adminApplyUpdateID = $_POST['applyID']; $sqlDeleteApply = "DELETE FROM tblApply WHERE id = $adminApplyUpdateID"; odbc_exec($conn,$sqlDeleteApply); ?> Expected result: ---------------- The row where the field id contains variable $adminApplyUpdateID is deleted. Actual result: -------------- When only one row is left in the table, and I try to delete it, it fails, and the following message appears. FATAL: emalloc(): Unable to allocate 1953394532 bytes -- Edit bug report at http://bugs.php.net/?id=38518&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38518&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38518&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38518&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=38518&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=38518&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=38518&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=38518&r=needscript Try newer version: http://bugs.php.net/fix.php?id=38518&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=38518&r=support Expected behavior: http://bugs.php.net/fix.php?id=38518&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=38518&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=38518&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=38518&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38518&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=38518&r=dst IIS Stability: http://bugs.php.net/fix.php?id=38518&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=38518&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=38518&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=38518&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=38518&r=mysqlcfg

« previous php.bugs (#100974) next »