Forum

[SOLVED] Scan for i...
 
Notifications
Retirer tout

[SOLVED] Scan for issues

2 Posts
2 Utilisateurs
0 Reactions
2,604 Vu
 DEV
(@lee)
Posts: 57
Estimable Member
Début du sujet
 
[#5874]

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


 
Posté : 27/03/2019 9:10 pm
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 28/03/2019 1:13 am
Share:
Retour en haut