Hello,
after an other test with the last version, i have this trace in log: (You can send me an email Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser. 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]