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

回贴
回帖数 1
阅读数 474
发表时间 2023-05-05 11:35:04
🍚
石先生 楼主


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
1个回复
禅道-阿龙 沙发
报错应该和升级程序判断有关,您应该在QQ技术交流群中沟通过,后续在群里协助您解决问题。
2023-05-05 15:54:44 禅道-阿龙 回帖
返回顶部
张淑钧
高级客户经理
13156280939
2082428410
统一服务热线 4006-8899-23
我要提问提问有任何问题,您都可以在这里提问。 问题反馈反馈点击这里,让我们聆听您的建议与反馈。