Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Errors in Reports (...
 
Notifications
Clear all

Errors in Reports (v. 5.4.4)

4 Posts
2 Users
0 Reactions
10.8 K Views
(@maged-mostafa)
Posts: 16
Active Member
Topic starter
 
[#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]

 
Posted : 06 Sep 2016 17H45
(@maged-mostafa)
Posts: 16
Active Member
Topic starter
 

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


 
Posted : 06 Sep 2016 18H07
babynus
(@babynus)
Posts: 14953
Main Contributor 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.


 
Posted : 06 Sep 2016 20H31
(@maged-mostafa)
Posts: 16
Active Member
Topic starter
 

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


 
Posted : 06 Sep 2016 20H56
Share:

Scroll to Top