Zend_Db SQLSTATE[HY000] [2002] Invalid argument

来源：互联网发布：网络与新媒体专业排名编辑：程序博客网时间：2024/06/04 18:23

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

Fatalerror: Uncaught exception 'Zend_Db_Adapter_Exception' withmessage '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.phpon 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 /