ID: 33717
User updated by: fhenninot at freesurf dot fr
Reported By: fhenninot at freesurf dot fr
Status: Assigned
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.1.0b3
Assigned To: wez
New Comment:
hi wez!
thank you for your help! but!!
If i use parameters, this don't crash apache!! ok!
but if my table haven't record like the parameter (now not only
'::memory') then that kill the PHP script!!
I've test it on beta2 and this work properly but with beta3 crashed.
Previous Comments:
------------------------------------------------------------------------
[2005-07-15 23:33:22] [EMAIL PROTECTED]
Doh. Like this:
$stmt = $db->prepare("SELECT * from database where location like ?");
$stmt->execute(array(":memory:"));
------------------------------------------------------------------------
[2005-07-15 23:32:41] [EMAIL PROTECTED]
BTW, if you want a workaround, you can use parameters like this:
$stmt = $db->prepare("SELECT * from database where location like ?");
$stmt->execute(array(":memory"));
------------------------------------------------------------------------
[2005-07-15 23:30:54] [EMAIL PROTECTED]
Sounds like a pretty nasty problem to me.
------------------------------------------------------------------------
[2005-07-15 23:01:05] fhenninot at freesurf dot fr
Description:
------------
This is a bug, i think, in PHP-5.1B3
When i search a string named ':memory:' into a database field, this
crash apache with the message : [Fri Jul 15 20:17:11 2005] [notice]
child pid 11338 exit signal Segmentation fault (11)
I can test it on linux only! and with some apache version.
Reproduce code:
---------------
<?php
$PDO_DB = new
PDO('sqlite:/usr/local/apache2/htdocs/SQLiteManager-1.1.2CVS/include/config3.db',
'', '');
$res = $PDO_DB->query("SELECT * FROM database WHERE location like
':memory:'");
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=33717&edit=1
