ID: 39967
User updated by: rodricg at sellingsource dot com
Reported By: rodricg at sellingsource dot com
-Status: Bogus
+Status: Open
Bug Type: PDO related
Operating System: Linux
PHP Version: 5CVS-2006-12-28 (snap)
New Comment:
I am experiencing this against 2 different servers with versions
4.0.26-standard-log and 4.0.25-log. Please verify that I am wrong
before marking this as bogus. At the very least the documentation
should indicate this deficiency.
Previous Comments:
------------------------------------------------------------------------
[2006-12-30 02:04:56] [EMAIL PROTECTED]
Unfortunately I do not have 4.0 server setup, But on all the
version of MySQL i have access to PDO reports the expected
error.
------------------------------------------------------------------------
[2006-12-29 19:10:10] rodricg at sellingsource dot com
Do you experience the same behavior as me (no error
reported) against a 4.0 server? Or is it specific to my
environment / setup?
------------------------------------------------------------------------
[2006-12-29 00:12:59] [EMAIL PROTECTED]
I suspect it is caused by MySQL not returning an error code or
doing so in a non-standard fashion. With 4.1 and 5.0 versions
I get the expected exception thrown.
------------------------------------------------------------------------
[2006-12-28 16:57:06] rodricg at sellingsource dot com
Apparently I misspoke and am only experiencing this against the 4.0
server, 4.1 appears to be working.
::[EMAIL PROTECTED]::8::/usr/src/php/php5.2-200612281530
Thu Dec 28 08:37:16 # /opt/php-snap/bin/php /root/bug.php
Fatal error: Call to a member function setFetchMode() on a non-object
in /root/bug.php on line 7
::[EMAIL PROTECTED]::8::/usr/src/php/php5.2-200612281530
Thu Dec 28 08:38:54 # mysql -hxxxxxxxxx.xxx -uxxxxxxx -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2032902
Server version: 4.0.25-log
::[EMAIL PROTECTED]::8::/usr/src/php/php5.2-200612281530
Thu Dec 28 08:44:56 # /opt/php-snap/bin/php /root/bug.php
Fatal error: Uncaught exception 'PDOException' with message
'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'selec Host,
User, Password from user' at line 1' in /root/bug.php:6
Stack trace:
#0 /root/bug.php(6): PDO->query('selec Host, Use...')
#1 {main}
thrown in /root/bug.php on line 6
::[EMAIL PROTECTED]::8::/usr/src/php/php5.2-200612281530
Thu Dec 28 08:45:34 # mysql -hxxxxx.xxxxxxxxx.xxx -P3309 -uxxxxxxxx -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 627531
Server version: 4.1.10-standard-log
------------------------------------------------------------------------
[2006-12-28 00:05:05] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5.2-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.2-win32-latest.zip
Seems to work fine in latest CVS
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/39967
--
Edit this bug report at http://bugs.php.net/?id=39967&edit=1
