Re: Problems using PDO_MYSQL with MySQL3
| From: | Andreas Korthaus | Date: | Fri, 24 Mar 2006 14:58:35 +0000 |
| Subject: | Re: Problems using PDO_MYSQL with MySQL3 | ||
| References: | 1 2 3 4 5 6 | Groups: | php.pecl.dev |
| Request: | Send a blank email to pecl-dev+get-3656@lists.php.net to get a copy of this message | ||
Hi Andrey!
Andrey Hristov wrote:
"Uknown command" comes from the server (ER_UNKNOWN_COM_ERROR) PDO sends a command which is not implemented in 3.23 it's not a query but some COM like COM_PING and so on. The server returns ER_UNKNOWN_COM_ERROR. To trace this you need debug build of the 3.23 server with activated debug trace log or debug build of PHP with PDO to trace and see what is being sent. It's possible that the libmysql sends a command unknown to 3.23 thus confusing the server.Thank you for your explanation! It's definitly caused by the PDO::query() call, because before that line PDO::errorInfo() is empty. The strange thing is, that it works fine with the same libmysql used by the old MySQL extension, but not with PDO. So PDO_MYSQL seems to send a command when calling PDO::query(), which is not compatible with MySQL 3.23 and could be avoided, because it works using the MySQL extension with the same libmysql. best regads Andreas