已解决 开源版8.1.3升级到9.8错误

07:50:01 ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'project' in 'field list'

The sql is: SELECT project, account FROM `zt_team` wHeRe project = '1'

in D:\12Zendao\xampp\zentao\lib\base\dao\dao.class.php on line 1392, last called by D:\12Zendao\xampp\zentao\lib\base\dao\dao.class.php on line 706 through function sqlError.
in D:\12Zendao\xampp\zentao\framework\base\router.class.php on line 2196 when visiting /zentao/upgrade.php?m=upgrade&f=execute




zt_team 表中并没有Project字段


ALTER TABLE `zt_team` ADD `limitedUser` varchar(8) NOT NULL default 'no' AFTER `role`;
ALTER TABLE `zt_team` ADD `task` mediumint(8) NOT NULL DEFAULT '0' AFTER `project`;
ALTER TABLE `zt_team` ADD `estimate` DECIMAL(12,2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `zt_team` ADD `consumed` DECIMAL(12,2) UNSIGNED NOT NULL DEFAULT '0' AFTER `estimate`;
ALTER TABLE `zt_team` ADD `left` DECIMAL(12,2) UNSIGNED NOT NULL DEFAULT '0' AFTER `consumed`;
ALTER TABLE `zt_team` ADD `order` TINYINT(3) NOT NULL DEFAULT '0' AFTER `left`;
ALTER TABLE `zt_team` DROP PRIMARY KEY;
ALTER TABLE `zt_team` ADD PRIMARY KEY (`project`, `task`, `account`);
ALTER TABLE `zt_team` CHANGE `limitedUser` `limited` varchar(8) COLLATE 'utf8_general_ci' NOT NULL DEFAULT 'no' AFTER `role`;


禅道版本 9.8.stable 源码包
操作系统 Windows 7
客户端浏览器 Chrome

提问者: ~~ 悬赏:5 日期: 2018-02-01 08:48:21 答案:2 点击:2439

获取技术支持

QQ: 电话:
设置备注
答案列表
2018/02/01
升级覆盖源码后,有执行upgrade.php进行升级吗?执行升级操作后,有提示升级成功吗?
2018/02/02
升级只能执行一次,升级过程中会把 project字段去掉的。
2018/06/30
怎么解决呢
2018/07/02
还原下升级之前备份的禅道,重新升级下。然后试试
2019/02/21
我的问题是:第一次按照步骤升级,提示升级成功。然后在集成运行环境里打开禅道首页,自动又跳转到升级页面,我就又升级了一次,然后就提示上方的同样内容的提示。然后现在要如何解决呢?
2019/02/21
先还原下之前的备份,重新升级下吧