BUG #18::本机新安装禅道项目管理软件后无法访问项目及产品视图
Confirm Resolve Close Activate To story Back
Steps
[前提]
已安装禅道管理,并按install页面提示设置好参数,可以正常访问禅道管理首页
[步骤]
case_1:点击“浏览项目”或“项目视图”
case_2:点击“浏览产品”或“产品视图”

[结果]
提示column not found错误(见附件截图),无法打开
[备注]
跟论坛的某帖子出错信息提示不同,debug改为false不能解决问题。
File
History[Reverse] [Toggle Show]
  1. 2010-01-20 19:45:48, Opened by sophia.
  2. 2010-01-20 19:46:10, Edited by sophia.
  3. 2010-01-20 20:03:24, Edited by 王春生.
    这个两个错误倒是非常的明显。
    case1中的错误是由于zt_task表里面缺少statusCustom字段造成的。
    case2中的错误是由于zt_story表里面缺少plan字段造成的。
    改正的sql如下:
    ALTER TABLE `zt_story` CHANGE `replease` `plan` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0';
    ALTER TABLE `zt_task` ADD `statusCustom` TINYINT UNSIGNED NOT NULL AFTER `status` ,
    ADD INDEX ( statusCustom );
    update zt_task set statusCustom = locate(status, 'wait,doing,done,cancel')

    不过很奇怪的是,如果你拿的是最新的程序的话,通过安装,这些字段应该是都在的才对。你是拿的那个版本的程序?
  4. 2010-01-20 20:55:02, Resolved by sophia, resolution is Won't fix.
    验证了一下,是我安装时导入的.sql文件,错用了前个版本的目录下的,重新导入安装后已没有问题- -!
  5. 2010-01-20 22:35:09, Closed by 王春生.
    :)
Confirm Resolve Close Activate To story Back
Basic info
Product Z:禅道项目管理系统
Module
Type Code error
Severity 2
Priority
Status Closed
Activated count 0
Confirmed Confirmed
Assigned to Closed at 2010-01-21 13:35:09
OS Windows XP
Browser IE6
Keywords
Lifetime
Opened By sophia at 2010-01-21 10:45:48
Opened Build Trunk
Resolved sophia at 2010-01-21 11:55:02
Resolved Build Trunk
Resolution Won't fix
Closed By 王春生 at 2010-01-21 13:35:09
Last edited 王春生 at 2010-01-21 13:35:09
Project, story & task
Project 禅道项目管理第六期
Story
Task
Misc
Mailto
Related
Case
To story
To task