One way to fix this :

• Change project type, so that your roject is not administrative any more
• On gantt chart, move your project to change its WBS.
• Move it back to expected place
• Change back project type to administrative.

I could not change type project
It doesn't appears on project list and gantt chart...
It only appears on Imputation

So it is you Leave Management Project...
This was fixed recently, as this project now gets WBS 0.
Which version are you using ?

I try to change the WBS to 0 for the leave project, system don't want! so the leave project is on WBS 16 (the last)
I discovered another strange phenomenon: in the allocation sheet, all the projects that are under a project with a padlock are grayed out, impossible to enter time.
see attached screenshot, under BSEAxxxxx-Project Name all are grayed

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

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).

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.

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