Forum

Errors in Reports (...
 
Notifications
Retirer tout

Errors in Reports (v. 5.4.4)

4 Posts
2 Utilisateurs
0 Reactions
10.8 {numéro}K Vu
(@maged-mostafa)
Posts: 16
Active Member
Début du sujet
 
[#3644]

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]

 
Posté : 6 Sep PM 17:099
(@maged-mostafa)
Posts: 16
Active Member
Début du sujet
 

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


 
Posté : 6 Sep PM 18:099
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 6 Sep PM 20:099
(@maged-mostafa)
Posts: 16
Active Member
Début du sujet
 

Hi,

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


 
Posté : 6 Sep PM 20:099
Share:
Retour en haut