已解决 【求助】NPM 环境下部署禅道2.4失败

之前安装一直提示pdo_mysql未安装,安装后部署禅道,第一步验证通过,到第三步部署数据库提交后就出现500错误。nginx日志如下,请高手帮忙:

 

2011/12/30 16:01:31 [error] 1778#0: *3 FastCGI sent in stderr: "PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQ

LSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet' in /var/www/site.pms/zentao

/module/install/model.php:337

Stack trace:

#0 /var/www/site.pms/zentao/module/install/model.php(337): PDO->query('-- DROP TABLE I...')

#1 /var/www/site.pms/zentao/module/install/model.php(223): installModel->createTable('5.5')

#2 /var/www/site.pms/zentao/module/install/control.php(88): installModel->checkConfig()

#3 [internal function]: install->step3()

#4 /var/www/site.pms/zentao/framework/router.class.php(1125): call_user_func_array(Array, Array)

#5 /var/www/site.pms/zentao/www/install.php(38): router->loadModule()

#6 {main}

  thrown in /var/www/site.pms/zentao/module/install/model.php on line 337" while reading response header from upstream, client: 114.

251.241.39, server: ps.mysite.com, request: "POST /install.php?m=install&f=step3 HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000

", host: "ps.mysite.com", referrer: "http://ps.mysite.com/install.php?m=install&f=step2"

2011/12/30 16:03:57 [error] 1778#0: *12 FastCGI sent in stderr: "PHP Fatal error:  Uncaught exception 'PDOException' with message 'S

QLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to yo

ur MySQL server version for the right syntax to use near '.`zt_action`' at line 1' in /var/www/site.pms/zentao/module/install/model.

php:337

Stack trace:

#0 /var/www/site.pms/zentao/module/install/model.php(337): PDO->query(' DROP TABLE IF ...')

#1 /var/www/site.pms/zentao/module/install/model.php(223): installModel->createTable('5.5')

#2 /var/www/site.pms/zentao/module/install/control.php(88): installModel->checkConfig()

#3 [internal function]: install->step3()

#4 /var/www/site.pms/zentao/framework/router.class.php(1125): call_user_func_array(Array, Array)

#5 /var/www/site.pms/zentao/www/install.php(38): router->loadModule()

#6 {main}

  thrown in /var/www/site.pms/zentao/module/install/model.php on line 337" while reading response header from upstream, client: 114.

251.241.39, server: ps.mysite.com, request: "POST /install.php?m=install&f=step3 HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000

", host: "ps.mysite.com", referrer: "http://ps.mysite.com/install.php?m=install&f=step2"

 

 

不胜感激!

禅道版本 2.4
操作系统 Ubuntu
客户端浏览器 Chrome

提问者: Freddy 悬赏:20 日期: 2011-12-30 16:11:10 答案:0 点击:4860

获取技术支持

QQ: 电话:
备注
Mysql服务运转正常,可本地、远程连接 PHP运行与Fast-cgi模式,与Nginx沟通正常,可显示phpinfo 配置使用localhost及127.0.0.1及公网IP都失败。 使用localhost时点第三步提交,提示 数据库连接失败 SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 本机.sock文件在/tmp/mysql.sock
设置备注