ID:               45160
 User updated by:  php at eklenet dot de
 Reported By:      php at eklenet dot de
-Status:           Feedback
+Status:           Open
 Bug Type:         PDO related
 Operating System: Windows 2003 Server 32bit
 PHP Version:      5.2.6
 New Comment:

here:
http://space.eklenet.de/CrashHang_Memory_Report__PID_5904__06092008100613171.mht
but i dont see something in this report.


Previous Comments:
------------------------------------------------------------------------

[2008-06-08 16:02:29] [EMAIL PROTECTED]

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.



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

[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

Reply via email to