Edit report at https://bugs.php.net/bug.php?id=55712&edit=1

 ID:                 55712
 User updated by:    ken at simplecommerce dot com
 Reported by:        ken at simplecommerce dot com
 Summary:            FastCGI causes event 1000 application error when
                     using number_format(0)
 Status:             Open
 Type:               Bug
 Package:            IIS related
 Operating System:   Windows server 2008 R2
 PHP Version:        5.3.8
 Block user comment: N
 Private report:     N

 New Comment:

We just tried updating the windows server 2008 R2 with all updates to make sure 
that none of the updates missing we're part of the problem.
The error still occurs.


Previous Comments:
------------------------------------------------------------------------
[2011-09-16 16:42:58] ken at simplecommerce dot com

Hi,

The test script I have provided is infact the same one I am using.
The only thing I removed was the login information. 
The database I am using is Acomba which is a accounting software.
I have the same setup on PHP 5.2.13 which works flawlessly, except for the 
number errors that we are getting ".:" which seems to be fixed in the latest 
version of PHP. 

Also, the error occurs when using this simple script:

<?php echo number_format(0); ?>

The only difference is that it occurs less frequently than the other script 
which queries a database.

I have tried everything I could find online about IIS7 and 500 error messages.
Setup the fastcgi settings like it was mentionned. 
Even used the windows installer which is supposed to do it all for you.

No php error is returned to the logs, always the 500 on the browser every 2 
refreshes if you account for the ODBC link, if not, it happens once in a while.

The issue, is that our application uses number format and the ODBC link 
intensively, so we need to get the 500 error resolved or at least need to 
figure out what is causing it.

I do know that when running the same scripts using command line, I do not get 
the 500 error but running it in the webpage I do.

Also, when switching from fastcgi to cgi, the error does not occur, but other 
problems arises, like 502 errors.

Oh and to add, we also tried 5.3.6 at first, and get the same event errors, 
talking about php-cgi.exe and kernelbase.dll.

------------------------------------------------------------------------
[2011-09-16 16:34:37] paj...@php.net

Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves. 

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external 
resources such as databases, etc. If the script requires a 
database to demonstrate the issue, please make sure it creates 
all necessary tables, stored procedures etc.

Please avoid embedding huge scripts into the report.



------------------------------------------------------------------------
[2011-09-16 16:28:53] ken at simplecommerce dot com

Description:
------------
We installed PHP 5.3.8 using the windows installer from microsoft and set the 
configuration according to the recommended settings for IIS 7.

http://www.microsoft.com/web/platform/phponwindows.aspx

We have a simple script that echo number_format(0); 
When accessing that script, and refreshing a couple of times, we get an error 
500.

We also have another script which does the same but has a query to an ODBC 
link. 
Whenever we use both at the same time, the 500 error occurs frequently, every 2 
refreshes. 

We also, made sure that no script errors appear in the logs we have saved to 
the windows temp dir and in fact none appear, to be sure it was working 
properly we made simple errors to test and it was in fact writing properly to 
the log files.

Test script:
---------------
<?php
// works alone / doesn't work when both used with odbc acomba
echo number_format(0).'<br />';

// acomba
$odbc_link = odbc_connect('', '', '');

$result = odbc_exec($odbc_link,"SELECT PrActive AS actif, PrNumber AS 
code_produit, PrDescription1 AS desc_f, PrDescription2 AS desc_e, PrComments AS 
commentaire, PrProductGroupCP AS id_produits_groupes, PrTaxExceptionCP AS 
id_tax_exception, PrSellingPrice0_1 AS prix_membre_individuel, 
PrSellingPrice0_2 AS prix_membre_couple, PrSellingPrice0_3 AS 
prix_membre_famille, PrSellingPrice0_4 AS prix_membre_enfants, 
PrSellingPrice0_5 AS prix_non_membre, RecCardPos AS id_produits_acomba FROM 
Product") or die(odbc_errormsg($odbc_link));

if (odbc_num_rows($result)) {           
        while ($row = odbc_fetch_array($result)) {
                print_r($row);
                exit;
        }
}
?>

Expected result:
----------------
The script should run and not cause a 500 error.

Actual result:
--------------
Here is the event details that is given on the crash.

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event";>
<System>
<Provider Name="Application Error" /> 
<EventID Qualifiers="0">1000</EventID> 
<Level>2</Level> 
<Task>100</Task> 
<Keywords>0x80000000000000</Keywords> 
<TimeCreated SystemTime="2011-09-15T22:37:50.000000000Z" /> 
<EventRecordID>5414</EventRecordID> 
<Channel>Application</Channel> 
<Computer>svrweb.intranet.local</Computer> 
<Security /> 
</System>
<EventData>
<Data>php-cgi.exe</Data> 
<Data>5.3.8.0</Data> 
<Data>4e537f4b</Data> 
<Data>KERNELBASE.dll</Data> 
<Data>6.1.7600.16385</Data> 
<Data>4a5bdbdf</Data> 
<Data>c000008e</Data> 
<Data>0000b727</Data> 
<Data>9b4</Data> 
<Data>01cc73f7f2b1da31</Data> 
<Data>C:\Program Files (x86)\PHP\v5.3\php-cgi.exe</Data> 
<Data>C:\Windows\syswow64\KERNELBASE.dll</Data> 
<Data>5773289d-dfeb-11e0-99e3-bc305bd47266</Data> 
</EventData>
</Event>


------------------------------------------------------------------------



-- 
Edit this bug report at https://bugs.php.net/bug.php?id=55712&edit=1

Reply via email to