企业版 8.3 升级 8.4.alpha.1 报错视图无权限,但是视图存在,字段也存在

2023-05-05 11:35:04
石先生
  • 访问次数: 23
  • 注册日期: 2018-11-02
  • 最后登录: 2023-11-24
  • 我的积分: 104
  • 门派等级: 释迦 等级1 居士


11:30:39 ERROR: SQLSTATE[HY000]: General error: 1356 View 'enpmsm_nslemons.ztv_projectteams' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them <p>The sql is: select t1.id,t5.name as project,IF(t5.multiple="1",t1.name,"") as execution,CONCAT(t1.begin,' ~ ',t1.end) as timeLimit,t2.teams,t3.stories,round(t4.consumed,1) as consumed,t4.number, t1.status as projectstatus
from zt_project as t1
left join ztv_projectteams as t2 on t1.id=t2.execution
left join ztv_projectstories as t3 on t1.id=t3.execution
left join ztv_executionsummary as t4 on t1.id=t4.execution
left join zt_project as t5 on t1.project=t5.id
where t1.deleted='0' and t1.type in ('sprint','stage') and if(''='',1,t5.id='') and if(''='',1,t1.status='') and if('2023-05-01'='',1,t1.begin>='2023-05-01') and if('2023-05-31'='',1,t1.end<='2023-05-31')</p> in lib/base/dao/dao.class.php on line 1476, last called by lib/base/dao/dao.class.php on line 762 through function sqlError.
in framework/base/router.class.php on line 2794 when visiting /upgrade.php?m=upgrade&f=execute
沙发
2023-05-05 15:54:44
禅道-阿龙
  • 访问次数: 1037
  • 注册日期: 2021-09-06
  • 最后登录: 2024-04-23
  • 我的积分: 4126
  • 门派等级: 无门派
报错应该和升级程序判断有关,您应该在QQ技术交流群中沟通过,后续在群里协助您解决问题。
1/1 1