Re: Bug #9816 Updated: FATAL: emalloc(): Unable to allocate

*sigh*...Still fails in 4.0.5...thanks just the same. Let me know if there's anything else I can do... tested on: Windows 2000 Server, SP1 PHP4.0.5 CGI IIS5 Access97, called using odbc_exec query: "SELECT LastName & ', ' & FirstName AS pName FROM Borrowers" error: FATAL: emalloc(): Unable to allocate 2147483599 bytes <kalowsky@php.net> wrote in message news:20010508013530.31198.qmail@php2.chek.com... > ID: 9816 > Updated by: kalowsky > Reported By: shazlista@usa.net > Old-Status: Open > Status: Feedback > Bug Type: ODBC related > Operating system: > PHP Version: 4.0.4pl1 > Assigned To: > Comments: > > Please try the recently released 4.0.5 to see if this is > corrected for you. > > Previous Comments: > -------------------------------------------------------------------------- - > > [2001-04-29 22:49:00] shazlista@usa.net > I got the same error when I tried (in numerous ways) to get the concatenation of two fields returned "AS" a new fieldname: > > My example query: > > SELECT BorrowerId, [FirstName] & [LastName] AS BName FROM Borrowers > > causes: > FATAL: emalloc(): Unable to allocate 2147483599 bytes > > I tried '+', '|', and '&' as concatenation operators, tried > CONCAT(a, b) -- I had heard that there was supposedly an internal odbc function called CONCAT that's supposed to be driver independent, though I'm not quite sure how that would work in practice -- and I even tried creating an Access "Query"/View/StoredProcedure called BorrowerNames using the query above. When I then issued a "SELECT * FROM BorrowerNames", I still got the error. > > Environment: > Windows 2000 Server, SP1 > PHP 4.0.4pl1 (CGI) > Access 97 > using odbc_exec() to Access 97 database > > > > -------------------------------------------------------------------------- - > > [2001-04-27 08:32:09] kalowsky@php.net > Another user commented: > > I just have read the bug-report 9816 at php.net and want to answer your email. > > Yes, the users are right: I had the same problems with FATAL:emalloc() using the same odbc-queries to get information out of two ms access tables. The first table only contains Customer-ID and pasword, the second contains customer adress and a remark-field (data type memo) > > Tests: > user authentication for login taken from table 1 -> OK > hello text for user from table 2 -> FATAL:emalloc() > > Result of Test enviroment - after some nights of installation :-) : > > 1) Win2000, MS Access2000, IIS5 and PHP4.0.4 : FATAL:emalloc() > 2) Win2000, MS Access2000 SP1, IIS5 and PHP4.0.4 : FATL:emalloc() > 3) Win2000, MS Access2000 SP1, Apache 1.3 and PHP 4.0.4 : FATAL:emalloc() > > 4) Win NT 4, MS Access2000, IIS4 and PHP 4.0.4: OK, no errors > 5) Win NT 4, MS Access2000, Apache 1.3 and PHP 4.0.4: OK, no errors > > The next days I try to debug the source code to find out what the trigger of emalloc() realy is. Our new Webserver should be a Win2000 Server with Apache and PHP. Therefore we need to know where the emalloc() error comes from. > > If you want know our results of debugging please send me an email to joerg.andreas@matrix-computer.com. > > -------------------------------------------------------------------------- - > > [2001-04-16 22:54:23] kalowsky@php.net > Can someone with access to Windows2000 please test this out and either confirm or deny this report? User reports this won't happen under Win98SE and that is currently all I have access to... > > -------------------------------------------------------------------------- - > > [2001-04-03 07:50:46] shazlista@usa.net > I am sorry but I have no coments on you ... > In all versions from 4.0.2 till 4.0.4pl1. > Only in win2000 with srvice pack 1 installed. > Only, not in 95,98,me,nt and win2000 with out service pack 1. > This script > <? > $a=odbc_connect("oh","",""); > $r=odbc_prepare($a,"SELECT 'a' FROM xx"); > odbc_execute($r); > odbc_free_result($r); > odbc_close($a); > ?> > where > xx is a table whith 1 integer field and 1 row. > and oh is odbc system dsn for ms access file with only one table (xx). > I get FATAL: emalloc(): Unable to allocate 2147483599 bytes > > > -------------------------------------------------------------------------- - > > [2001-04-01 20:40:00] kalowsky@php.net > A) Unable to reproduce locally on Win98SE, and MSAccess > with 4.0.5RC4 > > B) which version of PHP are you using? Bug report says > 4.0.4pl1, but your sample script suggests 4.0.2 - > 4.0.1pl1... which is it? > > -------------------------------------------------------------------------- - > > The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online. > > > ATTENTION! Do NOT reply to this email! > To reply, use the web interface found at http://bugs.php.net/?id=9816&edit=2 > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >