Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hi,
Here the log
2019-03-27 18:06:51.256 ** ERROR ** [V7.4.3] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wesum.idActivty' in 'where clause'
2019-03-27 18:06:51.256 ** ERROR ** [V7.4.3] For query : SELECT pe.refType as reftype, pe.refId as refid, pe.realWork as realwork, pe.leftWork as leftwork, pe.plannedWork as plannedwork, coalesce((select sum(work) from work w where w.refType=pe.refType and w.refId=pe.refId),0)+coalesce((select sum(pesum.realWork) from planningelement pesum where pesum.topId=pe.id),0)+coalesce((select sum(wesum.realWork) from workelement wesum where pe.refTYpe='Project' and wesum.idProject=pe.id and wesum.idActivty is null),0) as sumwork FROM planningelement pe WHERE pe.isManualProgress=0 and realwork!=coalesce((select sum(work) from work w where w.refType=pe.refType and w.refId=pe.refId),0)+coalesce((select sum(pesum.realWork) from planningelement pesum where pesum.topId=pe.id),0) +coalesce((select sum(wesum.realWork) from workelement wesum where pe.refTYpe='Project' and wesum.idProject=pe.id and wesum.idActivty is null),0) OR (pe.realWork+pe.leftWork)!=pe.plannedWork
2019-03-27 18:06:51.256 ** ERROR ** [V7.4.3] Strack trace :
2019-03-27 18:06:51.256 ** ERROR ** [V7.4.3] #0 Sql->query called at [C:ProjeqtorAppmodelConsistency.php:367]
2019-03-27 18:06:51.256 ** ERROR ** [V7.4.3] #1 Consistency->checkWorkOnActivity called at [C:ProjeqtorApptooladminFunctionalities.php:104]
2019-03-27 18:06:51.256 ** ERROR ** [V7.4.3] #2 include called at [C:ProjeqtorAppviewprint.php:219]
Problem in database ?
Thanks
No, it is a minor issue that occurs during consistency check.
Only effect is that some unconsistency may not be found.
The issue is fixed and will be deployed on patch V7.4.4