Forum

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.

KPI : SQL error
 
Notifications
Clear all

KPI : SQL error

3 Posts
2 Users
0 Reactions
3,214 Views
(@louisc)
Posts: 58
Active Member
Topic starter
 
[#4268]

Hello,

Looking at the logs while I can't manage to get consolidated KPI, I found a lot of Exceptions concerning essentially h.year and h.month column not found in the database.

2017-04-12 17:38:11.508 ** ERROR ** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.y
ear' in 'where clause'
2017-04-12 17:38:11.508 ** ERROR ** For query : select * from deliverable where idProject=420 and h.year='2016' and deliverable.scope = 'Deliverable' order by plannedDate asc
2017-04-12 17:38:11.508 ** ERROR ** Strack trace :
2017-04-12 17:38:11.508 ** ERROR ** #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1840]
2017-04-12 17:38:11.508 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor/report/kpiDeliverable.php:246]

I wonder if the problems comes from a bad database update when migrating to 6.1.3 or if the problem comes from elsewhere.

Thanks for your help.


 
Posted : 13 Apr 2017 16H27
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,

Could you please post the whole error stack ?


 
Posted : 14 Apr 2017 22H38
(@louisc)
Posts: 58
Active Member
Topic starter
 

Hi,

This was due to Organization not configured correctly.
When everything is well configured there are no more problems.


 
Posted : 07 Jul 2017 1H07
Share:

Scroll to Top