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

From: Date: Sun, 20 Aug 2006 09:22:59 +0000
Subject: #38518 [Opn]: Unable to allocate when deleting last row
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-100976@lists.php.net to get a copy of this message
ID: 38518 User updated by: jelle at v-essen dot nl Reported By: jelle at v-essen dot nl Status: Open Bug Type: ODBC related Operating System: Windows XP SP2 PHP Version: 5.1.5 New Comment: This happens whenever I try to delete the last row in a table, not only in this script, but in any of them. Oh, I forgot to post a part of the code, which might be very useful: <?php $connectDriver = 'DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=data.mdb;'; $conn = odbc_connect($connectDriver,'',''); ?> Maybe it's the driver... Previous Comments: ------------------------------------------------------------------------ [2006-08-20 09:18:15] jelle at v-essen dot nl 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 this bug report at http://bugs.php.net/?id=38518&edit=1

« previous php.bugs (#100976) next »