Edit report at https://bugs.php.net/bug.php?id=69381&edit=1
ID: 69381
Comment by: JLH at Dataplan dot co dot uk
Reported by: JLH at Dataplan dot co dot uk
Summary: out of memory with sage odbc driver (ok in 5.6.5)
Status: Feedback
Type: Bug
Package: ODBC related
Operating System: Windows 2012r2 nts
PHP Version: 5.6.7
Block user comment: N
Private report: N
New Comment:
Other than the code above, it requires sage accounts be installed on the machine (or its odbc driver
at least) which is not free software.
I could provide you access to a test virtual machine for you to see the problem on with a demo data
set in sage if that is ok?
Previous Comments:
------------------------------------------------------------------------
[2015-04-14 06:30:21] ab@php.net
Ok, in this case, please provide the exact instructions how to reproduce this.
Thanks.
------------------------------------------------------------------------
[2015-04-13 09:51:44] JLH at Dataplan dot co dot uk
I tried using php from php-master-nts-windows-vc11-x86-rf265928.zip as requested and still have an
error
VirtualAlloc() failed: [0x00000008] Not enough storage is available to process t
his command.
PHP Fatal error: Out of memory (allocated 2097152) (tried to allocate 195376781
3 bytes) in C:\inetpub\wwwroot\sage.php on line 3
------------------------------------------------------------------------
[2015-04-06 15:25:23] ab@php.net
Could you please check with the latest snapshots as in bug #69354? Looks very similar to it.
Thanks.
------------------------------------------------------------------------
[2015-04-05 20:13:43] JLH at Dataplan dot co dot uk
Description:
------------
On upgrading from php 5.6.5 nts (server 2012r2 64bit) to 5.6.7, our odbc_exec is no longer working.
we are using the sage line 50 odbc driver to extract data from the accounts software we use.
I suspect this is related to bug id 68964
Test script:
---------------
c:\inetpub\php\php.exe c:\inetpub\wwwroot\sage.php
sage.php contains:
<?php
$odbcconn=odbc_connect("SageLine50v20","user","pass");
$query=odbc_exec($odbcconn,"SELECT ACCOUNT_REF, NAME FROM sales_ledger");
?>
Expected result:
----------------
in the 5.6.5 version, the code will display no errors
Actual result:
--------------
in the 5.6.7 version we get:
PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 1956365745
bytes) in C:\inetpub\wwwroot\sage.php on line 3
So i changed the memory limit from 512M to 3G to see what would happen:
PHP Fatal error: Out of memory (allocated 262144) (tried to allocate 1956365745
bytes) in C:\inetpub\wwwroot\sage.php on line 3
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=69381&edit=1