ID: 35607
Updated by: [EMAIL PROTECTED]
Reported By: wseibert at hxcorp dot com
-Status: Open
+Status: Assigned
Bug Type: PDO related
Operating System: Windows 2k
PHP Version: 5CVS-2005-12-08 (snap)
-Assigned To:
+Assigned To: wez
New Comment:
Assigned to the maintainer.
Previous Comments:
------------------------------------------------------------------------
[2005-12-08 21:12:16] wseibert at hxcorp dot com
Sorry, I know this is going to be difficult to duplicate as I'm
connecting to a Access DB on my local machine via ODBC. If you have a
Access DB on your system, you just need to set it up in your ODBC
Manager and point to that DSN in the script. Once that is done, try
doing a Update SQL command via PDO::query, Then try it via PDO::exec.
If it works (correctly), it should return the number of rows affected.
It crashes for me on the query, and does nothing on the exec.
------------------------------------------------------------------------
[2005-12-08 21:07:57] wseibert at hxcorp dot com
<?php
try
{
$dbh = new PDO('odbc:DSN=TEST;driver=Driver do Microsoft Access
(*.mdb)','','');
$results = $dbh->query('UPDATE xd17 SET xd17.CCDate = 20051207,
xd17.CCTime = 1200, xd17.ModifiedDS = 200512071200 WHERE xd17.XTyp17 =
157 AND xd17.X15A = 51921 AND xd157.X105B = 3300');
} catch (PDOException $e) {
print "Error!: ".$e->getMessage()."<br/>";
die();
}
?>
------------------------------------------------------------------------
[2005-12-08 20:58:56] [EMAIL PROTECTED]
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 possible, make the script source available online and provide
an URL to it here. Try to avoid embedding huge scripts into the report.
------------------------------------------------------------------------
[2005-12-08 20:49:06] wseibert at hxcorp dot com
Description:
------------
Running a UPDATE sql command via PDO crashes Apache.
Reproduce code:
---------------
try
{
$dbh = new PDO('odbc:DSN=TEST;driver=Driver do Microsoft Access
(*.mdb)','','');
$results = $dbh->query('UPDATE xd17 SET xd17.CCDate = 20051207,
xd17.CCTime = 1200, xd17.ModifiedDS = 200512071200 WHERE xd17.XTyp17 =
157 AND xd17.X15A = 51921 AND xd157.X105B = 3300');
} catch (PDOException $e) {
print "Error!: ".$e->getMessage()."<br/>";
die();
}
Expected result:
----------------
Expected to see changes in DB.
Using exec ($dbh->exec(....) ) instead of query has no effect. Doesn't
update the DB or crash anything.
SQL statement works find in MS Access.
Actual result:
--------------
Apache.exe - Application Error
The instruction at "0x7c5b97d4" referenced memory at "0x0000000c". The
memory could no be "written".
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=35607&edit=1
