统一服务热线 4006-8899-23
English
升级12开源版

通过源代码方式升级(通用) 分享链接 /book/zentaopms/67.html?releaseID=1

作者：王春生 最后编辑：薛才杰 于 2024-06-19 11:11:19 浏览量：201784
摘要：本篇文章讲述如何通过源代码来升级禅道，适用于各种安装方式。

升级是为了保留旧版本中的数据，所以升级前一定要做好数据备份，以免升级过程中出现意外导致数据丢失。停止服务后，复制禅道代码目录作为备份以及数据库备份。

《通过源代码方式升级》视频链接：https://www.zentao.net/zentao-install/zentao-source-code-package-upgrade-80529.html



下面是通用的升级步骤：

一、升级步骤

  1. 在我们网站下载新版本的源码包，以.zip结尾。（开源版16.5以后的版本，根据php版本选择安装包）
  2. 解压缩新的程序，覆盖到原来的目录。比如之前禅道安装的目录是在c:\xampp\zentao下面，则将代码覆盖到c:\xampp\zentao，操作方法：zentaopms/ 下面复制所有的文件到 xampp/zentao/ 下面粘帖。
  3. 执行升级程序。假设禅道的访问路径是http://192.168.1.99/zentao/，升级路径为http://192.168.1.99/zentao/upgrade.php。
  4. 根据向导，选择对应的版本，按照提示进行即可。
注意：不要将原来的程序移走，再解压缩新的版本，注意是覆盖！不要拷贝成c:\xampp\zentao\zentao

          不要下载.exe结尾的程序进行升级，那样子会覆盖原来的数据！

二、插件兼容问题

如果升级之前有安装过第三方朋友开发的插件，需要注意检查下是否和新版本的禅道兼容。如果发现升级之后无法访问，可以替换一下禅道运行代码：

1、把禅道当前运行代码文件夹改名（一般默认是 zentao 或者 zentaopms）；

2、到禅道官网下载相同版本禅道的源码，解压后放在同目录下面，保持文件夹名字和之前禅道运行代码文件夹名称相同 。

3、把原先文件夹中的  config/my.php  www/data/upload/1  www/.ztaccess   www/.htaccess 拷贝到新禅道文件夹对应目录,再访问禅道试试。

评论列表
🦊
王晓晨 2025-03-10 11:04:08 回复
开源版从16.5升级到最新更新顺序是什么
回复
16.5可以直接升级到最新版本，如果担心版本跨度比较大，可以中间找个18.12版本过渡下。
升级不会影响数据的，但建议先做好备份
升级前请做好数据备份
升级请参考文档：http://www.zentao.net/book/zentaopmshelp/41.html
备份请参考文档：http://www.zentao.net/book/zentaopmshelp/42.html
回复
ok
回复
你好，升级到最新版本后切换每个界面都要加载3秒所有时间，是什么问题
回复
对于禅道里的页面性能优化 可以先从系统里配置看下，看下后台-系统设置-表引擎界面的数据库表引擎是否都是innodb，如果不是可以切换到innodb引擎，另外 系统设置里有个缓存的配置也可以开启下看看。
📪
王先生 2024-10-30 16:02:27 回复
开源版从16.3升级到16.5，数据库报错
回复
具体报错的信息可以粘贴出来看看。
另外如果升级过程中遇到了报错，一般情况下需要恢复版本的数据和代码，再次走一般升级流程。
如果不能解决问题，可以通过网站的联系我们，邀请您加入技术交流群沟通，即时性会更好一些。
回复
Fatal error: Uncaught Error: Call to a member function loadModel() on boolean in /opt/zbox/app/zentao/www/upgrade.php:65 Stack trace: #0 {main} thrown in /opt/zbox/app/zentao/www/upgrade.php on line 65
回复
每次显示的都不一样
回复
需要根据具体的提示信息判断问题的。可以联系官网商务同事的QQ，申请加入技术交流群，群里贴下报错信息，方便排查问题。
回复
技术交流群，到目前为止还没加进去，事比较着急
回复
开源版16.4能直接升级到17.0，或者直接升级18.0吗？
这个升级过程台漫长了
回复
可以升级到17.0版本
回复
刚才我就是从16.4直接升级到17.0，报错就是上面的那个
回复
具体的错误，需要远程看看了，先进群吧。
回复
从16.4升级到16.5报的是数据库的错；
16.4升级到17.0报的是这个php的错
🌴
禅道2271 2023-12-20 07:51:36 回复
18.0-18.9升级后一直卡在1%不动该怎么处理
回复
您好，可以打开debug，查看一下报错日志
（1）zentao/config/my.php 中debug的值改成true
（2）重新操作一下有问题的页面
（3）查看日志 zentao/tmp/log/文件中php开头的今天的文件有什么报错。注：不要找sql开头的文件。
🌵
禅道1088 2023-09-29 16:49:42 回复
18.3源码升级到18.7时，确认执行SQL语句后，显示升级失败，禅道每个本版本的升级，都让人如履薄冰
回复
需要根据具体的提示信息判断问题的。可以联系官网顶部商务QQ，申请加入技术交流群，群里贴下报错信息，方便排查问题。
wei luo 2023-04-02 17:25:37 回复
15.3升级到16.0报如下错误，PH5.4
( ! ) Notice: Undefined property: config::$edition in /pms/zentao/config/ext/zentaobiz.php on line 25
Call Stack
# Time Memory Function Location
1 0.0003 267232 {main}( ) ../index.php:0
2 0.0069 1769016 baseRouter::createApp( ) ../index.php:34
3 0.0069 1769464 baseRouter->__construct( ) ../router.class.php:430
4 0.0069 1772248 baseRouter->loadMainConfig( ) ../router.class.php:390
5 0.0072 1825240 include( '/pms/zentao/config/config.php' ) ../router.class.php:2154
6 0.0122 2361184 include( '/pms/zentao/config/ext/zentaobiz.php' ) ../config.php:179
回复
连接mysql服务中出现的问题，可以进我们的技术交流群（1049532049）大家一起看下
可以提供如下的信息方便我们进一步排查问题
1，zentao/config/my.php 文件的内容
2，目前安装的php版本，建议把禅道php版本升级到7.2版本，覆盖7.2版本的源码包，再升级看下
lin 2023-03-07 14:40:26 回复
11.7 升级18.0 报错
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'system-common--CRExecution' for key 'unique'<p>The sql is:
UPDATE `zt_config` SET `key` = 'CRExecution' WHERE `module` = 'common' AND `key` = 'CRProject'</p>
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-bug-exportTemplate' for key 'group'<p>The sql is:
UPDATE `zt_grouppriv` SET `method`='exportTemplate' WHERE `method` = 'exportTemplet'</p>
回复
您好，11.7直接升级到18.0 跨度有点大，建议中间过渡几个版本，11.7->12.5.3->16.5->18，可以使用备份还原，保证禅道可以正常访问之后，重新升级看下。
600 2023-02-06 11:54:09 回复
15版本升级到18版本后没有BI菜单
回复
1、登录admin用户看下页面是否存在BI菜单
2、如何admin用户存在，普通用户不存在应该是权限问题，在后台-人员-权限中，在对应的权限分组中添加的BI部分的权限。
dmax 2023-01-29 15:21:38 回复
能从12版本直接升级到18版本吗
回复
建议过渡几个版本升级呢
升级前请做好数据备份
升级请参考文档：http://www.zentao.net/book/zentaopmshelp/41.html
备份请参考文档：http://www.zentao.net/book/zentaopmshelp/42.html
可以添加上个商务qq，进入技术交流群获取更多支持。
回复
我能不能通过源码升级到18，然后后台-数据-备份一下。再把备份文件拷到我新装的18版上，进行还原啊。
回复
可以的
Cindy 2022-09-21 17:33:23 回复
升级出错。
16:57:58 Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'company' in 'field list'' in E:\xampp\zentao\module\upgrade\model.php:1294
Stack trace:
#0 E:\xampp\zentao\module\upgrade\model.php(1294): PDO->query('UPDATE zt_searc...')
#1 E:\xampp\zentao\module\upgrade\model.php(158): upgradeModel->updateCompany()
#2 E:\xampp\zentao\module\upgrade\model.php(103): upgradeModel->executeOpen('1_0beta', NULL, false, '')
#3 E:\xampp\zentao\module\upgrade\control.php(151): upgradeModel->execute('')
#4 [internal function]: upgrade->execute('')
#5 E:\xampp\zentao\framework\base\router.class.php(2166): call_user_func_array(Array, Array)
#6 E:\xampp\zentao\www\upgrade.php(83): baseRouter->loadModule()
#7 {main}
thrown in E:\xampp\zentao\module\upgrade\model.php on line 1294 when visiting /zentao/upgrade.php?m=upgrade&f=execute
回复
请问是从哪个版本升级到哪个版本？升级前是否做过备份，先还原下备份重新升级，注意升级时不要多次点击执行sql按钮。
升级如果有问题可以添加页面上方联系方式，邀请您进入技术交流群沟通升级。
ocm_dp 2022-08-09 20:32:53 回复
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `get_monday`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `get_monday`(day date) RETURNS date
begin if date_format(day, '%w') = 0 then return subdate(day, date_format(day, '%w') - 6);
else return subdate(day, date_format(day, '%w') -1);
end if;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `get_sunday`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `get_sunday`(day date) RETURNS date
begin
if date_format(day, '%w') = 0 then return day;
else return subdate(day, date_format(day, '%w') - 7);
end if;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_cminited`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION qc_cminited($project int, $category varchar(30)) returns int
begin
declare products int default 0;
declare objects int default 0;
select count(*) from zt_projectproduct where project = $project into products;
select count(distinct product) from zt_object where project = $project and category = $category and type = 'taged' and product in (select product from zt_projectproduct where project = $project) into objects;
IF products = objects THEN
return 1;
ELSEIF products != objects THEN
return 0;
END IF;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_initscale`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION qc_initscale($project int, $category varchar(30), $estimateType varchar(30)) RETURNS float(10,2)
BEGIN
declare $estimate int default 0;
declare $storyEst varchar(30) default 'storyEst';
declare $requestEst varchar(30) default 'requestEst';
if($estimateType = $storyEst) THEN SELECT sum(storyEst) as estimate FROM zt_object WHERE id in(SELECT MIN(id) FROM zt_object WHERE project = $project and category = $category and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
end if;
if($estimateType = $requestEst) THEN SELECT sum(requestEst) as estimate FROM zt_object WHERE id in(SELECT MIN(id) FROM zt_object WHERE project = $project and category = $category and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
end if;
RETURN @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmplanscale`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmplanscale`($project int) RETURNS float(10,2)
BEGIN
declare programScale float (10,2) default 0;
select `scale` from zt_workestimation where project = $project into @programScale;
return @programScale;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmsrinitscale`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmsrinitscale`($project int) RETURNS float(10,2)
begin
declare scale int default 0;
declare inited int default 0;
select qc_cminited($project, 'SRS') into inited;
IF inited = 1 THEN
select qc_initscale($project, 'SRS', 'storyEst') into scale ;
return scale ;
ELSE
return 0;
END IF;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmsrrealscale`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmsrrealscale`($project int) RETURNS float(10,2)
BEGIN
declare totalEstimate float(10,2) default 0;
select CAST(sum(estimate) as DECIMAL(10,2)) as estimate from zt_story where id in (select story from zt_projectstory where project=$project) and type='story' and deleted='0' and closedReason not in ('subdivided', 'duplicate', 'willnotdo', 'cancel', 'bydesign') into totalEstimate;
return totalEstimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmurinitscale`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmurinitscale`($project int) RETURNS float(10,2)
begin
declare scale int default 0;
declare inited int default 0;
select qc_cminited($project, 'URS') into inited;
IF inited = 1 THEN
select qc_initscale($project, 'URS', 'requestEst') into scale;
return scale;
ELSE
return 0;
END IF;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmurrealscale`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmurrealscale`($project int) RETURNS float(10,2)
BEGIN
declare totalEstimate float(10,2) default 0;
select CAST(sum(estimate) as DECIMAL(10,2)) as estimate from zt_story where project=$project and type='requirement' and deleted='0' and closedReason not in ('subdivided', 'duplicate', 'willnotdo', 'cancel', 'bydesign') into totalEstimate;
return totalEstimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmallrequirementstage`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmallrequirementstage`($project int) RETURNS int(1)
BEGIN
select count(*) as products from zt_projectproduct where project = $project into @totalproduct;
select count(*) as product from (select product from zt_projectproduct where project in (select id from zt_project where project = $project and type = 'stage' and attribute = 'request' and deleted = '0') GROUP BY product) as product into @product;
if @totalproduct = @product then return 1;
end if;
RETURN 0;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmdesigntplandays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmdesigntplandays`($project int) RETURNS int(10)
BEGIN
select qc_pgmspecifiedtypeplanneddays($project,'design') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmdesigntrealdays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmdesigntrealdays`($project int) RETURNS int(10)
BEGIN
select qc_pgmspecifiedtypeactualdays($project,'design') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmdevelplandays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmdevelplandays`($project int) RETURNS int(10)
BEGIN
select qc_pgmspecifiedtypeplanneddays($project,'dev') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmdevelrealdays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmdevelrealdays`($project int) RETURNS int(10)
BEGIN
select qc_pgmspecifiedtypeactualdays($project,'dev') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmrequestplandays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmrequestplandays`($project int) RETURNS int(10)
BEGIN
select qc_pgmspecifiedtypeplanneddays($project,'request') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmrequestrealdays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmrequestrealdays`($project int) RETURNS int(10)
BEGIN
select qc_pgmspecifiedtypeactualdays($project,'request') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmspecifiedtypeactualdays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmspecifiedtypeactualdays`($project int,$attribute varchar(50)) RETURNS int(10)
BEGIN
select count(*) from zt_project where project = $project and attribute = $attribute and deleted = '0' and id not in (select parent from zt_project where project = $project and attribute = $attribute and grade = 2 group by parent) into @totalstory;
select count(*) from zt_project where project = $project and attribute = $attribute and deleted = '0' and realDuration > 0 and id not in (select parent from zt_project where project = $project and attribute = $attribute and grade = 2 group by parent) into @setstory;
select sum(realDuration) as realDuration from zt_project where project = $project and attribute = $attribute and deleted = '0' and realDuration > 0 and id not in (select parent from zt_project where project = $project and attribute = $attribute and grade = 2 group by parent) into @days;
if @totalstory != @setstory then
set @days = 0;
end if;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmspecifiedtypeplanneddays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmspecifiedtypeplanneddays`($project int,$attribute varchar(50)) RETURNS int(10)
BEGIN
select sum(planDuration) as planDuration from zt_project where project = $project and attribute = $attribute and deleted = '0' and id not in (select parent from zt_project where project = $project and attribute = $attribute and grade = 2 group by parent) into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmstageactualduration`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmstageactualduration`($product int, $attribute varchar(50)) RETURNS int(10)
BEGIN
select count(*) as totalduration from zt_project where id in (select project from zt_projectproduct where product = $product) and type = 'stage' and attribute = $attribute and deleted = '0' and id not in (select parent from zt_project where id in (select project from zt_projectproduct where product = $product) and attribute = $attribute and grade = 2 group by parent) into @totalduration;
select count(*) as setduration from zt_project where id in (select project from zt_projectproduct where product = $product) and type = 'stage' and attribute = $attribute and deleted = '0' and id not in (select parent from zt_project where id in (select project from zt_projectproduct where product = $product) and attribute = $attribute and grade = 2 group by parent) and realDuration > 0 into @setduration;
select sum(realDuration) as duration from zt_project where id in (select project from zt_projectproduct where product = $product) and type = 'stage' and attribute = $attribute and deleted = '0' and id not in (select parent from zt_project where id in (select project from zt_projectproduct where product = $product) and attribute = $attribute and grade = 2 group by parent) and realDuration > 0 into @duration;
if @totalduration != @setduration then
set @duration = 0;
end if;
return @duration;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmstageplannedduration`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmstageplannedduration`($product int, $attribute varchar(50)) RETURNS int(10)
BEGIN
select sum(planDuration) as duration from zt_project where id in (select project from zt_projectproduct where product = $product) and attribute = $attribute and deleted = '0' and id not in (select parent from zt_project where id in (select project from zt_projectproduct where product = $product) and attribute = $attribute and grade = 2 group by parent) and planDuration > 0 into @duration;
RETURN @duration;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmtestplandays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmtestplandays`($project int) RETURNS int(10)
BEGIN
select qc_pgmspecifiedtypeplanneddays($project,'qa') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmtestrealdays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmtestrealdays`($project int) RETURNS int(10)
BEGIN
select qc_pgmspecifiedtypeactualdays($project,'qa') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_prddesigntplandays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_prddesigntplandays`($project int, $product int) RETURNS int(10)
BEGIN
select qc_pgmstageplannedduration($project, $product, 'design') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_prddesigntrealdays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_prddesigntrealdays`($project int, $product int) RETURNS int(10)
BEGIN
select qc_pgmstageactualduration($project, $product, 'design') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_prddevelplandays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_prddevelplandays`($project int, $product int) RETURNS int(10)
BEGIN
select qc_pgmstageplannedduration($project, $product, 'dev') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_prddevelrealdays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_prddevelrealdays`($project int, $product int) RETURNS int(10)
BEGIN
select qc_pgmstageactualduration($project, $product, 'dev') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_prdrequestplandays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_prdrequestplandays`($project int, $product int) RETURNS int(10)
BEGIN
select qc_pgmstageplannedduration($project, $product, 'request') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_prdrequestrealdays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_prdrequestrealdays`($project int, $product int) RETURNS int(10)
BEGIN
select qc_pgmstageactualduration($project, $product, 'request') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_prdtestplandays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_prdtestplandays`($project int, $product int) RETURNS int(10)
BEGIN
select qc_pgmstageplannedduration($project, $product, 'qa') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_prdtestrealdays`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_prdtestrealdays`($project int, $product int) RETURNS int(10)
BEGIN
select qc_pgmstageactualduration($project, $product, 'qa') as days into @days;
return @days;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmdesgignrealesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmdesgignrealesthours`($project int) RETURNS float(10,2)
BEGIN
return qc_pgmesthoursbytype($project, 'design');
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmdesignrealhours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmdesignrealhours`($project int) RETURNS float(10,2)
BEGIN
return qc_pgmrealhoursbytype($project, 'design');
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmdevelrealesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmdevelrealesthours`($project int) RETURNS float(10,2)
BEGIN
return qc_pgmesthoursbytype($project, 'devel');
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmdevelrealhours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmdevelrealhours`($project int) RETURNS float(10,2)
BEGIN
return qc_pgmrealhoursbytype($project, 'devel');
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmrealesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmrealesthours`($project int) RETURNS float(10,2)
BEGIN
select CAST(sum(estimate) as DECIMAL(10,2)) as estimate from zt_task where project=$project and parent >= 0 and status != 'cancel' and deleted = '0' into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmesthoursbytype`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmesthoursbytype`($project int, $type char(30)) RETURNS float(10,2)
BEGIN
select CAST(sum(estimate) as DECIMAL(10,2)) as estimate from zt_task where project=$project and type = $type and parent >= 0 and status != 'cancel' and deleted = '0' into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmrealhours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmrealhours`($project int) RETURNS float(10,2)
BEGIN
select CAST(sum(consumed) as DECIMAL(10,2)) as consumed from zt_task where project=$project and parent >= 0 and status != 'cancel' and deleted = '0' into @consumed;
return @consumed;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmrealhoursbytype`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmrealhoursbytype`($project int, $type char(30)) RETURNS float(10,2)
BEGIN
select CAST(sum(consumed) as DECIMAL(10,2)) as consumed from zt_task where project=$project and type = $type and parent >= 0 and status != 'cancel' and deleted = '0' into @consumed;
return @consumed;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmrequestrealesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmrequestrealesthours`($project int) RETURNS float(10,2)
BEGIN
return qc_pgmesthoursbytype($project, 'request');
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmrequestrealhours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmrequestrealhours`($project int) RETURNS float(10,2)
BEGIN
return qc_pgmrealhoursbytype($project, 'request');
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmtestrealesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmtestrealesthours`($project int) RETURNS float(10,2)
BEGIN
return qc_pgmesthoursbytype($project, 'test');
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmtestrealhours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmtestrealhours`($project int) RETURNS float(10,2)
BEGIN
return qc_pgmrealhoursbytype($project, 'test');
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_getdevelfirstesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_getdevelfirstesthours`($project int) RETURNS float(10,2)
BEGIN
SELECT sum(devEst) as estimate FROM zt_object WHERE id in(SELECT MIN(id) FROM zt_object WHERE project = $project and category = 'PP' and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_getdesignfirstesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_getdesignfirstesthours`($project int) RETURNS float(10,2)
BEGIN
SELECT sum(designEst) as estimate FROM zt_object WHERE id in(SELECT MIN(id) FROM zt_object WHERE project = $project and category = 'PP' and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_getstoryfirstesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_getstoryfirstesthours`($project int) RETURNS float(10,2)
BEGIN
SELECT sum(requestEst) as estimate FROM zt_object WHERE id in(SELECT MIN(id) FROM zt_object WHERE project = $project and category = 'PP' and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_gettestfirstesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_gettestfirstesthours`($project int) RETURNS float(10,2)
BEGIN
SELECT sum(testEst) as estimate FROM zt_object WHERE id in(SELECT MIN(id) FROM zt_object WHERE project = $project and category = 'PP' and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_getfirstesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_getfirstesthours`($project int) RETURNS float(10,2)
BEGIN
SELECT sum(taskEst) as estimate FROM zt_object WHERE id in(SELECT MIN(id) FROM zt_object WHERE project = $project and category = 'PP' and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_getdevlastesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_getdevlastesthours`($project int) RETURNS float(10,2)
BEGIN
SELECT sum(devEst) as estimate FROM zt_object WHERE id in(SELECT MAX(id) FROM zt_object WHERE project = $project and category = 'PP' and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_getrequestlastesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_getrequestlastesthours`($project int) RETURNS float(10,2)
BEGIN
SELECT sum(requestEst) as estimate FROM zt_object WHERE id in(SELECT MAX(id) FROM zt_object WHERE project = $project and category = 'PP' and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_gettestlastesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_gettestlastesthours`($project int) RETURNS float(10,2)
BEGIN
SELECT sum(testEst) as estimate FROM zt_object WHERE id in(SELECT MAX(id) FROM zt_object WHERE project = $project and category = 'PP' and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_getdesignlastesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_getdesignlastesthours`($project int) RETURNS float(10,2)
BEGIN
SELECT sum(designEst) as estimate FROM zt_object WHERE id in(SELECT MAX(id) FROM zt_object WHERE project = $project and category = 'PP' and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_getlastesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_getlastesthours`($project int) RETURNS float(10,2)
BEGIN
SELECT sum(taskEst) as estimate FROM zt_object WHERE id in(SELECT MAX(id) FROM zt_object WHERE project = $project and category = 'PP' and type = 'taged' and product in (select product from zt_projectproduct where project = $project) group by `product`) into @estimate;
return @estimate;
END</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
DROP FUNCTION IF EXISTS `qc_pgmlastesthours`</p>
SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted<p>The sql is:
CREATE FUNCTION `qc_pgmlastesthours`($project int) RETURNS float(10,2)
BEGIN
declare estimate float(10,2) default 0;
declare inited int default 0;
select qc_cminited($project,'PP') into inited;
IF inited = 1 THEN
select qc_getlastesthours($project) into estimate;
return estimate;
ELSE
return 0;
END IF;
END</p>
回复
是禅道升级过程产生的报错吗，是否对禅道进行过二次开发，可以添加页面上方QQ，邀请您进入技术交流群沟通禅道相关问题。
上一页1 2 3 4 5 6 7 8 9 1/13下一页
魏中显
高级客户经理
18561939726
1746749398
统一服务热线 4006-8899-23
我要提问提问有任何问题，您都可以在这里提问。 问题反馈反馈点击这里，让我们聆听您的建议与反馈。