category: real work
report: detailed work per resource - weekly
show report: works
export to PDF format: throws an error on screen:
ERROR : An error occurred on 2016-09-06 at 14:56:20
and in log:
2016-09-06 14:56:20.931 ***** ERROR ***** ERROR *****
2016-09-06 14:56:20.931 ***** ERROR ***** on file '/var/www/html/projeqtor/external/html2pdf/html2pdf.class.php' at line (2171)
2016-09-06 14:56:20.931 ***** ERROR ***** cause = Undefined offset: 5
category: costs
report: total expense and cost per month
show report: shows up but
there is no graph and
with errors in log:
2016-09-06 15:00:52.934 ***** ERROR ***** 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 group by exp.month, exp.idProject order by t2.sortOrd...
^
2016-09-06 15:00:52.934 ***** ERROR ***** For query : select sum(exp.realAmount) as sumCost, exp.month as scale , exp.idProject from expense exp, Project t2 where (exp.idProject not in (0) or exp.idProject is null ) and (exp.idProject not in (0) or exp.idProject is null or (1=4) ) and (exp.idProject not in (0) or exp.idProject is null or (1=3) ) and exp.idProject not in (0) and exp.expenseRealDate is not null AND t2.id=exp.idProject group by exp.month, exp.idProject order by t2.sortOrder asc
2016-09-06 15:00:52.934 ***** ERROR ***** Strack trace :
2016-09-06 15:00:52.934 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/report/expenseCostTotalPlan.php:113]
2016-09-06 15:00:52.935 ***** ERROR ***** 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 group by exp.month, exp.idProject order by t2.sortOrd...
^
2016-09-06 15:00:52.936 ***** ERROR ***** For query : select sum(exp.plannedAmount) as sumCost, exp.month as scale , exp.idProject from expense exp, Project t2 where (exp.idProject not in (0) or exp.idProject is null ) and (exp.idProject not in (0) or exp.idProject is null or (1=4) ) and (exp.idProject not in (0) or exp.idProject is null or (1=3) ) and exp.idProject not in (0) and exp.expenseRealDate is null AND t2.id=exp.idProject group by exp.month, exp.idProject order by t2.sortOrder asc
2016-09-06 15:00:52.936 ***** ERROR ***** Strack trace :
2016-09-06 15:00:52.936 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/report/expenseCostTotalPlan.php:113]
export to PDF format: shows up
with graph and with error in log:
2016-09-06 15:05:43.234 ***** ERROR ***** 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 group by exp.month, exp.idProject order by t2.sortOrd...
^
2016-09-06 15:05:43.234 ***** ERROR ***** For query : select sum(exp.realAmount) as sumCost, exp.month as scale , exp.idProject from expense exp, Project t2 where (exp.idProject not in (0) or exp.idProject is null ) and (exp.idProject not in (0) or exp.idProject is null or (1=4) ) and (exp.idProject not in (0) or exp.idProject is null or (1=3) ) and exp.idProject not in (0) and exp.expenseRealDate is not null AND t2.id=exp.idProject group by exp.month, exp.idProject order by t2.sortOrder asc
2016-09-06 15:05:43.234 ***** ERROR ***** Strack trace :
2016-09-06 15:05:43.234 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/report/expenseCostTotalPlan.php:113]
2016-09-06 15:05:43.234 ***** ERROR ***** #1 include called at [/var/www/html/projeqtor/view/print.php:175]
2016-09-06 15:05:43.235 ***** ERROR ***** 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 group by exp.month, exp.idProject order by t2.sortOrd...
^
2016-09-06 15:05:43.235 ***** ERROR ***** For query : select sum(exp.plannedAmount) as sumCost, exp.month as scale , exp.idProject from expense exp, Project t2 where (exp.idProject not in (0) or exp.idProject is null ) and (exp.idProject not in (0) or exp.idProject is null or (1=4) ) and (exp.idProject not in (0) or exp.idProject is null or (1=3) ) and exp.idProject not in (0) and exp.expenseRealDate is null AND t2.id=exp.idProject group by exp.month, exp.idProject order by t2.sortOrder asc
2016-09-06 15:05:43.235 ***** ERROR ***** Strack trace :
2016-09-06 15:05:43.235 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/report/expenseCostTotalPlan.php:113]
2016-09-06 15:05:43.235 ***** ERROR ***** #1 include called at [/var/www/html/projeqtor/view/print.php:175]