From: mjsabby at gmail dot com
Operating system: Fedora Core 5
PHP version: 5.1.6
PHP Bug Type: PDO related
Bug description: PDO prepare() or query() always fails, MySQL
Description:
------------
PHP 5.1.6
MySQL 5.0.19-standard
Fedora Core 5
prepare() or query() alwyas fails, regardless of syntactically correct SQL
or not, atleast for MySQL.
MySQL(i) client libraries work perfectly, but the PDO with the exact same
query fails.
Reproduce code:
---------------
<?php
define('DB_DSN', 'mysql:localhost;dbname=xxx');
define('DB_USER', 'xxx');
define('DB_PASS', 'xxx');
try {
$dbh = new PDO(DB_DSN, DB_USER, DB_PASS);
} catch (PDOException $e) {
die($e->getMessage());
}
$query = $dbh->query("SELECT * FROM users") or echo("BOO");
$prepa = $dbh->prepare("SELECT * FROM users") or echo("BOO2");
$dbh = null;
?>
Expected result:
----------------
Run the query
--
Edit bug report at http://bugs.php.net/?id=38736&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=38736&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=38736&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=38736&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=38736&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=38736&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=38736&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=38736&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=38736&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=38736&r=support
Expected behavior: http://bugs.php.net/fix.php?id=38736&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=38736&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=38736&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=38736&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38736&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=38736&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=38736&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=38736&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=38736&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=38736&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=38736&r=mysqlcfg
