Dear Projeqtor Team,
we have same problem since last week ( same red errors ! ) with following logs error :
2023-09-25 13:52:09.121 ***** ERROR ***** [V11.0.0] Exception-[HY000] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'projeqtor.st.sortOrder' which is not in SELECT list; this is incompatible with DISTINCT
2023-09-25 13:52:09.121 ***** ERROR ***** [V11.0.0] For query : SELECT DISTINCT st.name from status as st
left JOIN workflow as wf on wf.isLeaveWorkflow = 1
left join workflowstatus as wfs on wfs.idWorkflow = wf.id
where st.id = wfs.idStatusFrom or st.id = wfs.idStatusTo ORDER by st.sortOrder;
2023-09-25 13:52:09.121 ***** ERROR ***** [V11.0.0] Strack trace :
2023-09-25 13:52:09.122 ***** ERROR ***** [V11.0.0] #0 Sql->query called at [/var/www/projeqtor/model/LeaveTypeMain.php:736]
2023-09-25 13:52:09.122 ***** ERROR ***** [V11.0.0] #1 LeaveTypeMain->drawSendInfo called at [/var/www/projeqtor/model/LeaveTypeMain.php:1080]
2023-09-25 13:52:09.122 ***** ERROR ***** [V11.0.0] #2 LeaveTypeMain->drawSpecificItem called at [/var/www/projeqtor/view/objectDetail.php:1184]
2023-09-25 13:52:09.122 ***** ERROR ***** [V11.0.0] #3 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:368]
2023-09-25 13:52:12.230 ***** ERROR ***** [V11.0.0] Exception-[HY000] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'projeqtor.st.sortOrder' which is not in SELECT list; this is incompatible with DISTINCT
2023-09-25 13:52:12.230 ***** ERROR ***** [V11.0.0] For query : SELECT DISTINCT st.name from status as st
left JOIN workflow as wf on wf.isLeaveWorkflow = 1
left join workflowstatus as wfs on wfs.idWorkflow = wf.id
where st.id = wfs.idStatusFrom or st.id = wfs.idStatusTo ORDER by st.sortOrder;
2023-09-25 13:52:12.230 ***** ERROR ***** [V11.0.0] Strack trace :
2023-09-25 13:52:12.230 ***** ERROR ***** [V11.0.0] #0 Sql->query called at [/var/www/projeqtor/model/LeaveTypeMain.php:736]
2023-09-25 13:52:12.230 ***** ERROR ***** [V11.0.0] #1 LeaveTypeMain->drawSendInfo called at [/var/www/projeqtor/model/LeaveTypeMain.php:1080]
2023-09-25 13:52:12.231 ***** ERROR ***** [V11.0.0] #2 LeaveTypeMain->drawSpecificItem called at [/var/www/projeqtor/view/objectDetail.php:1184]
2023-09-25 13:52:12.231 ***** ERROR ***** [V11.0.0] #3 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:368]
2023-09-25 13:52:14.385 ***** ERROR ***** [V11.0.0] Exception-[HY000] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'projeqtor.st.sortOrder' which is not in SELECT list; this is incompatible with DISTINCT
2023-09-25 13:52:14.385 ***** ERROR ***** [V11.0.0] For query : SELECT DISTINCT st.name from status as st
left JOIN workflow as wf on wf.isLeaveWorkflow = 1
Thanks for your support.
I'm not able to move project "leave" cause it is hiden ... and modification on WBS on database doesn't work. ( actualy NULL )
Hi,
The error logged concerns some code that has not change for long...
Moreover, the SQL query pointed out in error runs fine on MySql.
So I guess you are using PostgreSql.
Did you migrate DB recently ?
Please indicate used DB / Version.
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
Cookies settings
×
Functional Cookies
Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.
Session
Please login to see yours activities!
Other cookies
Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.