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]
Other errors:
category: current status
report: status of ongoing work
show report: works but with no graphs
export to PDF format: works with graphs
category: current status
report: status of all work
show report: works but with no graphs
export to PDF format: works with graphs
Note: I noticed that the broken graph image URL for on screen reports has an extra slash maybe it is the cause, for example:
http://projeqtor/var/log/projeqtor/report //user28_statusDetail_20160906_155846_1.png
category: real work
report: detailed work per resource - weekly
show report: works
export to PDF format: throws an error on screen:
Issue recorded as Ticket #2295
category: costs
report: total expense and cost per month
show report: shows up but there is no graph and with errors in log:
Issue recorded as Ticket #2296
category: current status
report: status of ongoing work
show report: works but with no graphs
export to PDF format: works with graphs
Are you sure PHP-GD is installed on your PHP server ?
NB : double slash may not be source of issue.
Can you also check access rights to directrory for reports and be sure that this directory in in the web reach.
Hi,
category: current status
report: status of ongoing work
show report: works but with no graphs
export to PDF format: works with graphsAre you sure PHP-GD is installed on your PHP server ?
NB : double slash may not be source of issue.
Can you also check access rights to directory for reports and be sure that this directory in in the web reach.
PHP-GD extension is installed.
This issue was due to an absolute path /var/log/projeqtor/report/ in the global parameter temporary directory for reports
I followed the above direction by creating a temp directory under the projeqtor web root directory and gave ownership to the apache user and put the relative path ../temp (without a trailing slash) in the temporary directory for reports parameter.
Now, it worked normally and the image URL is valid
Thanks for the help