ID: 45160
Updated by: pajoye@php.net
Reported By: php at eklenet dot de
-Status: Open
+Status: Feedback
Bug Type: PDO related
Operating System: Windows 2003 Server 32bit
PHP Version: 5.2.6
New Comment:
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php
for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php
for Win32
Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.
Previous Comments:
------------------------------------------------------------------------
[2008-06-08 14:42:24] php at eklenet dot de
but in the last sql was no getdate(), getdate() was two sql before.
all the errors are on Windows not on Linux. The ODBC-Connection points
to a MS-SQL.
------------------------------------------------------------------------
[2008-06-08 12:36:18] ncoesel at dealogic dot nl
I believe this bug is caused by calling getdate(). On my Linux machine
calling getdate() crashes PHP consistently. I'll file a bug report
shortly.
------------------------------------------------------------------------
[2008-06-03 12:57:56] php at eklenet dot de
Description:
------------
hi,
i got the error :
PHP has encountered an Access Violation at 01B849C7
on some sqls.
i have tried some php-version, 5.2.4, 5.2.5, 5.2.6 and
php5.2-win32-latest.zip, on IIS ISAPI and Apache2 Mod, all the same.
i think the the error must be in the PDO prepare statement, as you see
a "A" is show with the SQL in the actual result, but never a "B" at the
last line
The attatched output is complete.
The reproduce code is just a part of a big script.
Reproduce code:
---------------
...
$this->CONNECTION['handle'] =$dbh = new PDO('odbc:bluesheet',
"sa","xxxx");
...
echo "A:$sql:";
$this->CONNECTION['response'] =
$this->CONNECTION['handle']->prepare($sql);
echo "B";
$this->CONNECTION['response']->execute();
echo "C";
...
Expected result:
----------------
no error and correctly executed sqls.
Actual result:
--------------
PHP has encountered an Access Violation at 01B849C7A:SELECT id,name
FROM bs_companies;:BCA:SELECT
id,name FROM bs_users;:BCA:SELECT * FROM bs_salesmans;:BCA:INSERT INTO
bs_access_log
(
func ,
ip ,
ip_for ,
session ,
php_session ,
browser ,
login ,
date
) VALUES (
'muster_stueckliste_edit' /* func */ ,
'192.168.224.4' /* ip */ ,
'' /* ip_for */ ,
'e9bc10605d413039c338efeaef5abef0' /* session */ ,
'8b1q4n09vhpvba2dqgfl7sh6t5' /* php_session */ ,
'Mozilla/5.0 (Windows; U; Windows NT 5.2; de; rv:1.8.1.14)
Gecko/20080404 Firefox/2.0.0.14' /* browser
*/ ,
'1' /* login */ ,
getdate() /* date */
)
:BCA:SELECT
[function]
FROM
bs_functions4user
WHERE
user_id = '1'
:BCA:UPDATE
bs_stueckliste
SET
parent_id = '32' ,
stueck = '2' ,
details = '2' ,
einheit = '2' ,
verbrauch = DEFAULT ,
groese = '2' ,
farbe = DEFAULT ,
positions = DEFAULT ,
anz = DEFAULT
WHERE
id = '5' AND
ident = '64'
:
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=45160&edit=1