禅道迁移后出现白屏已解决悬赏10积分

提问者钱坤答案数1 阅读数2972 发表时间2016-09-26 17:19:57

禅道在centos系统中进行了迁移，方法是直接把禅道的目录拷贝到了另一台主机的apache下，把数据库也用mysqldump进行导出迁移，PHP版本5.3迁移到php5.6上，最后迁移后出现两个问题：

1、输入正确的用户名和密码点击登陆后没有响应（如果输入密码错误会有提示报错），按F5刷新后才能登陆进去

2、点击退出后，白屏，也要刷新几下才出现登陆页面

查看禅道的日志有以下报错信息（apache的主目录为 /var/www/html/）：

17:15:09 ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC `zt_action`' at line 1The sql is: INSERT INTO `zt_action` SET `objectType` = 'user',`objectID` = '4',`actor` = 'tianming',`action` = 'login',`date` = '2016-09-26 17:15:09',`comment` = '',`extra` = '',`product` = ',0,',`project` = '0' in /var/www/html/zentaopms/lib/dao/dao.class.php on line 1058, last called by /var/www/html/zentaopms/lib/dao/dao.class.php on line 992 through function sqlError.
in /var/www/html/zentaopms/framework/router.class.php on line 1568 when visiting /zentaopms/www/index.php?m=user&f=login

禅道版本：7.2.5

安装包类型：源码包

操作系统：CentOS

客户端浏览器：Chrome

备注

在登陆时候无响应，报错日志如下：

17:37:20 ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC `zt_action`' at line 1The sql is: INSERT INTO `zt_action` SET `objectType` = 'user',`objectID` = '4',`actor` = 'tianming',`action` = 'login',`date` = '2016-09-26 17:37:20',`comment` = '',`extra` = '',`product` = ',0,',`project` = '0' in /var/www/html/zentaopms/lib/dao/dao.class.php on line 1058, last called by /var/www/html/zentaopms/lib/dao/dao.class.php on line 992 through function sqlError.
in /var/www/html/zentaopms/framework/router.class.php on line 1568 when visiting /zentaopms/www/index.php?m=user&f=login&referer=L3plbnRhb3Btcy93d3cvaW5kZXgucGhw