|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2005-11-28 00:05 UTC] bugs at jth dot net
Description:
------------
PDO::query is not returning a PDOStatement object.
and segmentation fault using array(PDO::ATTR_PERSISTENT => true)
mysqld Ver 5.0.15-standard for pc-linux-gnu on i686
Server version: Apache/2.0.54
Architecture: 32-bit
Reproduce code:
---------------
try {
$dbh = new PDO('mysql:host=localhost;dbname=ddddd', "xxxxx", "xxxxxxx");
$query = "SELECT COUNT(*) FROM ordrer";
$stmt = $dbh->query($query);
//$stmt = $dbh->prepare($query); $result = $stmt->execute();
print $stmt->columnCount();
} catch (PDOException $e) {
print "Error !: " . $e->getMessage() . "<br/>";
die();
}
Actual result:
--------------
$stmt = $dbh->query($query);
Call to a member function columnCount() on a non-object
when executing code print $stmt->columnCount() but not after
$stmt = $dbh->prepare($query); $result = $stmt->execute();
However,
Apache2 child pid 22634 exit signal Segmentation fault (11)
in any case when using array(PDO::ATTR_PERSISTENT => true)
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Sun May 05 04:01:32 2024 UTC |
I have been experiencing something similar, with the following code: $dsn = "sqlite:foo.db"; $dbh = new PDO($dsn); $stmt = $dbh->prepare("SELECT id, name FROM foo"); $stmt if returning a boolean value (false), thus all my folloing code fails with a "Call to a member function execute() on a non-object", which is weird as the PHP documentation states this should return a PDOStatement. In addition I tried telling PDO to change its error mode to exceptions, to see if I coult 'catch' the error, but this failed to generate an exception. Below if the code I used to set PDO to exception mode: $dbh = new PDO($dsn); $dbh->setAttribute(PDO::ERRMODE_EXCEPTION, true); I know there is nothing wrong with the sqlite DB as I created it using the SQLite lib in PHP and can read it fine: I am attempting to read the same DB file using PDO. I am running: Win Server 2003 Ent Ed PHP 5.1.2 Apache 2.0.55 I replaced the php_pdo.dll and php_pdo_sqlite.dll in my PHP ext directory with those in the ZIP file located at, as per your suggestion: http://snaps.php.net/win32/php5-win32-latest.zip I've tried to be a through as possible, and tried to add to an existing bug report (rather than generate an new report). If there is any further info you need to help diagnose this problem, drop me an email at omarshariffdontlikeit@gmail.com and I will get it for you. Cheers!