Zend_Db SQLSTATE[HY000] [2002] Invalid argument

 

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

<b>Fatal error</b>:  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 <b>/home/www/private/ZendFramework-1.9.3PL1/library/Zend/Db/Adapter/Pdo/Abstract.php</b> on line <b>144</b>

 

原因求证：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 /