View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - error WBS project-Periode Absence - Page 2 - ProjeQtOr
 
 

error WBS project-Periode Absence

More
25 Sep 2023 15:34 #7 by loicr
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 )

lr

Please Log in or Create an account to join the conversation.

More
28 Sep 2023 18:48 #8 by babynus
First, this is not the same issue.
Second, please do not post an issue on a SOLVED thread (you take the risk it is never read).

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
28 Sep 2023 19:03 #9 by babynus
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.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
29 Sep 2023 08:17 #10 by loicr
Dear Babynus,

we are under mysql , the only thing we've done is migrate last week to v11.0.0 and update our ressources ( expecialy end of contract for 2 of them )

mysql --version
mysql Ver 8.0.34-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

Sincerely
LR

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.046 seconds

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.