ID: 39967
Updated by: [EMAIL PROTECTED]
Reported By: rodricg at sellingsource dot com
-Status: Open
+Status: Bogus
Bug Type: PDO related
Operating System: Linux
PHP Version: 5CVS-2006-12-28 (snap)
New Comment:
>At the very least the documentation should indicate this deficiency.
I believe PHP documentation is wrong place for documenting MySQL
deficiencies. If the error disappears when using different library
version (and the same PHP source code) then the problem is clearly in
the library.
Previous Comments:
------------------------------------------------------------------------
[2007-01-02 16:41:16] rodricg at sellingsource dot com
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.
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
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
