全站提示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 /