linux服务器上禅道数据迁移之后，管理员无法登陆已解决悬赏5积分

提问者墨舞清风答案数1 阅读数2855 发表时间2018-05-21 15:53:34

[root@izwz9ingetk3pqqg204c9hz log]# tail -f php.20180521.log.php
in /opt/zbox/app/zentao/framework/base/router.class.php on line 1932 when visiting user-login-L3plbnRhby8=

15:47:39 ERROR: SQLSTATE[HY000]: General error: 1036 Table 'zt_user' is read onlyThe sql is: UPDATE `zt_user` SET `fails` = '1', `locked` = '0000-00-00 00:00:00' wHeRe account = 'admin' in /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 1318, last called by /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 776 through function sqlError.
in /opt/zbox/app/zentao/framework/base/router.class.php on line 1932 when visiting user-login-L3plbnRhby8=

15:47:53 ERROR: SQLSTATE[HY000]: General error: 1036 Table 'zt_user' is read onlyThe sql is: UPDATE `zt_user` SET `fails` = '1', `locked` = '0000-00-00 00:00:00' wHeRe account = 'admin' in /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 1318, last called by /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 776 through function sqlError.
in /opt/zbox/app/zentao/framework/base/router.class.php on line 1932 when visiting user-login-L3plbnRhby8=

15:47:53 ERROR: SQLSTATE[HY000]: General error: 1036 Table 'zt_user' is read onlyThe sql is: UPDATE `zt_user` SET `fails` = '1', `locked` = '0000-00-00 00:00:00' wHeRe account = 'admin' in /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 1318, last called by /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 776 through function sqlError.
in /opt/zbox/app/zentao/framework/base/router.class.php on line 1932 when visiting user-login-L3plbnRhby8=
^C
[root@izwz9ingetk3pqqg204c9hz log]# tail -f sql.20180521.log.php
UPDATE `zt_user` SET `fails` = '1', `locked` = '0000-00-00 00:00:00' WHERE account = 'admin'

20180521 15:47:53: user-login-L3plbnRhby8=
SELECT * FROM `zt_config` WHERE owner IN ('system','') ORDER BY `id`
SELECT * FROM `zt_lang` ORDER BY `lang`,`id`
SELECT locked FROM `zt_user` WHERE account = 'admin'
SELECT * FROM `zt_user` WHERE account = 'admin' AND deleted = '0'
SELECT fails FROM `zt_user` WHERE account = 'admin'
UPDATE `zt_user` SET `fails` = '1', `locked` = '0000-00-00 00:00:00' WHERE account = 'admin'