Repport / Planning / synthesis of availability

Hello,
after an other test with the last version, i have this trace in log: (You can send me an email This email address is being protected from spambots. You need JavaScript enabled to view it. for some precisions in french for this use case complex)

2019-05-23 14:49:50.148 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table
2019-05-23 14:52:16.908 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table
2019-05-23 14:53:34.550 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table
2019-05-23 14:57:40.366 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table
2019-05-23 15:02:30.513 ===== TRACE ===== sendMailIfMailable : Mails without dest
2019-05-23 15:02:40.515 ===== TRACE ===== sendMailIfMailable : Mails without dest
2019-05-23 15:04:38.498 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table
2019-05-23 16:36:53.127 ***** ERROR ***** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:36:53.127 ***** ERROR ***** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from work t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 33) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:36:53.127 ***** ERROR ***** [V8.0.3] Strack trace :
2019-05-23 16:36:53.127 ***** ERROR ***** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:36:53.127 ***** ERROR ***** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:36:53.127 ***** ERROR ***** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from plannedwork t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 33) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:36:53.127 ***** ERROR ***** [V8.0.3] Strack trace :
2019-05-23 16:36:53.127 ***** ERROR ***** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:36:57.311 ***** ERROR ***** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:36:57.311 ***** ERROR ***** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from work t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 33) and t1.idProject not in (0, 39) and year='2019' and month='201905' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:36:57.311 ***** ERROR ***** [V8.0.3] Strack trace :
2019-05-23 16:36:57.311 ***** ERROR ***** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:36:57.311 ***** ERROR ***** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:36:57.311 ***** ERROR ***** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from plannedwork t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 33) and t1.idProject not in (0, 39) and year='2019' and month='201905' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:36:57.311 ***** ERROR ***** [V8.0.3] Strack trace :
2019-05-23 16:36:57.311 ***** ERROR ***** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:37:52.081 ***** ERROR ***** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:37:52.081 ***** ERROR ***** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from work t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:37:52.081 ***** ERROR ***** [V8.0.3] Strack trace :
2019-05-23 16:37:52.081 ***** ERROR ***** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:37:52.081 ***** ERROR ***** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:37:52.081 ***** ERROR ***** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from plannedwork t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:37:52.081 ***** ERROR ***** [V8.0.3] Strack trace :
2019-05-23 16:37:52.081 ***** ERROR ***** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:37:54.206 ***** ERROR ***** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:37:54.206 ***** ERROR ***** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from work t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and month='201905' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:37:54.206 ***** ERROR ***** [V8.0.3] Strack trace :
2019-05-23 16:37:54.206 ***** ERROR ***** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:37:54.207 ***** ERROR ***** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:37:54.207 ***** ERROR ***** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from plannedwork t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and month='201905' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:37:54.207 ***** ERROR ***** [V8.0.3] Strack trace :
2019-05-23 16:37:54.207 ***** ERROR ***** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:39:07.603 ===== TRACE ===== DISCONNECTED USER 'Thomas'
2019-05-23 16:40:01.956 ***** ERROR ***** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...oject=t2.id group by week, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:40:01.956 ***** ERROR ***** [V8.0.3] For query : select sum(work) as sumWork, week as scale , t1.idProject as idproject from work t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by week, t1.idProject order by t2.sortOrder asc
2019-05-23 16:40:01.956 ***** ERROR ***** [V8.0.3] Strack trace :
2019-05-23 16:40:01.956 ***** ERROR ***** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:40:01.956 ***** ERROR ***** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...oject=t2.id group by week, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:40:01.957 ***** ERROR ***** [V8.0.3] For query : select sum(work) as sumWork, week as scale , t1.idProject as idproject from plannedwork t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by week, t1.idProject order by t2.sortOrder asc
2019-05-23 16:40:01.957 ***** ERROR ***** [V8.0.3] Strack trace :
2019-05-23 16:40:01.957 ***** ERROR ***** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]