Zend_Db SQLSTATE[HY000] [2002] Invalid argument

最新推荐文章于 2024-10-23 14:49:24 发布

原创最新推荐文章于 2024-10-23 14:49:24 发布 · 1.9k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#zend #exception #null #php

PHP相关专栏收录该内容

10 篇文章

订阅专栏

本文记录了一个关于SQLSTATE[HY000][2002] Invalid argument错误的问题及解决过程。该错误出现在使用Zend Framework进行数据库操作时，通过调整PHP的mysql配置解决了问题。

全站提示SQLSTATE[HY000] [2002] Invalid argument，类似信息如下：

Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[HY000] [2002] Invalid argument' in /home/www/private/ZendFramework-1.9.3PL1/library/Zend/Db/Adapter/Pdo/Abstract.php:144
Stack trace:
#0 /home/www/private/ZendFramework-1.9.3PL1/library/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /home/www/private/ZendFramework-1.9.3PL1/library/Zend/Db/Adapter/Abstract.php(832): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /home/www/private/ZendFramework-1.9.3PL1/library/Zend/Db/Adapter/Abstract.php(902): Zend_Db_Adapter_Abstract->quote(1, NULL)
#3 /home/www/private/ZendFramework-1.9.3PL1/library/Zend/Db/Select.php(930): Zend_Db_Adapter_Abstract->quoteInto('SSHY = ?', 1, NULL)
#4 /home/www/private/ZendFramework-1.9.3PL1/library/Zend/Db/Select.php(463): Zend_Db_Select->_where('SSHY = ?', 1, NULL, true)
#5 /home/www/lelaa/app/models/Public/Ticket.php(235): Zend_Db_Select->where('SSHY = ?', 1)
#6 /home/www/lelaa/app/modules/public/controllers/TicketController.php(329): Public_Tic in /home/www/private/ZendFramework-1.9.3PL1/library/Zend/Db/Adapter/Pdo/Abstract.php on line 144

原因求证：php5.3内置驱动有问题。开始使用php5.3内置mysqlnd编译：
  --with-mysql=mysqlnd /
  --with-mysqli=mysqlnd /
  --with-pdo-mysql=mysqlnd /

解决办法：把编译选项改为：
  --with-mysql=/path/to/mysql /
  --with-pdo-mysql=/path/to/mysql /
  --with-mysqli=/path/to/mysql/bin/mysql_config /