Forum

BUG : Production of...
 
Notifications
Retirer tout

BUG : Production of the report of work per resource (PDF)

11 Posts
2 Utilisateurs
0 Reactions
15.9 {numéro}K Vu
(@hammurabi)
Posts: 26
Active Member
Début du sujet
 
[#517]

Hello,

I have this error "ERROR : An error occured on 2012-05-14 at 15:12:09" when i try to produce the PDF report of the detailed work per resource (weekly, montly or annualy).

Regards


 
Posté : 14 Mai PM 23:055
(@babynus)
Posts: 14952
Membre Admin
 

There must be an error logger in the log file.
Can you post it here please ?


 
Posté : 15 Mai AM 00:055
(@hammurabi)
Posts: 26
Active Member
Début du sujet
 

I'll post it soon cause i'm wainting for the technical support.
By the way, i want understand why we can't select a resource in this report ?

Thx


 
Posté : 15 Mai PM 17:055
(@babynus)
Posts: 14952
Membre Admin
 

By the way, i want understand why we can't select a resource in this report ?

Just because it was not concidered usefull.


 
Posté : 15 Mai PM 17:055
(@hammurabi)
Posts: 26
Active Member
Début du sujet
 

All right.

but this report will be unreadble if we look over a huge collection of resources.

Thx


 
Posté : 15 Mai PM 17:055
(@hammurabi)
Posts: 26
Active Member
Début du sujet
 

2012-05-14 09:14:10 ** ERROR ** [1064] Erreur SQL : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and v
p.idVersion=projectorria1version.id)) order by projectorria1version.name' at line 1

select id as id, name as name from projectorria1version where (idle=0 and projectorria1version.isEis='0' a
nd exists (select 'x' from projectorria1versionproject vp where vp.idProject in () and vp.idVersion=projectorria1version.id)) order by projectorria1version.name
2012-05-14 09:17:22 ===== TRACE ===== DISCONNECTED USER 'SHQRCR'
2012-05-14 09:17:28 ===== TRACE ===== NEW CONNECTED USER 'admin'
2012-05-14 09:36:59 ** ERROR ** [1064] Erreur SQL : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and v
p.idVersion=projectorria1version.id)) order by projectorria1version.name' at line 1

select id as id, name as name from projectorria1version where (idle=0 and projectorria1version.isEis='0' a
nd exists (select 'x' from projectorria1versionproject vp where vp.idProject in () and vp.idVersion=projectorria1version.id)) order by projectorria1version.name
2012-05-14 15:08:58 ** ERROR ** ERROR **
2012-05-14 15:08:58
** ERROR ** on file '/var/www/vh/projector_tst/public/projectorria/external/html2pdf/html2pdf.class.php' at line (2133)
2012-05-14 15:08:58
** ERROR ** cause = Undefined offset: 5
2012-05-14 15:09:03
** ERROR ** ERROR **
2012-05-14 15:09:03 ** ERROR ** on file '/var/www/vh/projector_tst/public/projectorria/external/html2pdf/html2pdf.class.php' at line (2133)
2012-05-14 15:09:03 ** ERROR ** cause = Undefined offset: 5
2012-05-14 15:09:28 ** ERROR ** ERROR **
2012-05-14 15:09:28
** ERROR ** on file '/var/www/vh/projector_tst/public/projectorria/external/html2pdf/html2pdf.class.php' at line (2133)
2012-05-14 15:09:28
** ERROR ** cause = Undefined offset: 5
2012-05-14 15:09:40
** ERROR ** ERROR **
2012-05-14 15:09:40 ** ERROR ** on file '/var/www/vh/projector_tst/public/projectorria/external/html2pdf/html2pdf.class.php' at line (2133)
2012-05-14 15:09:40 ** ERROR ** cause = Undefined offset: 5
2012-05-14 15:10:14 ** ERROR ** ERROR **
2012-05-14 15:10:14
** ERROR ** on file '/var/www/vh/projector_tst/public/projectorria/external/html2pdf/html2pdf.class.php' at line (2133)
2012-05-14 15:10:14
** ERROR ** cause = Undefined offset: 5
2012-05-14 15:10:19
** ERROR ** ERROR **
2012-05-14 15:10:19 ** ERROR ** on file '/var/www/vh/projector_tst/public/projectorria/external/html2pdf/html2pdf.class.php' at line (2133)
2012-05-14 15:10:19 ** ERROR ** cause = Undefined offset: 5
2012-05-14 15:10:25 ** ERROR ** ERROR **
2012-05-14 15:10:25
** ERROR ** on file '/var/www/vh/projector_tst/public/projectorria/external/html2pdf/html2pdf.class.php' at line (2133)
2012-05-14 15:10:25
** ERROR ** cause = Undefined offset: 5
2012-05-14 15:12:09
** ERROR ** ERROR **
2012-05-14 15:12:09 ** ERROR ** on file '/var/www/vh/projector_tst/public/projectorria/external/html2pdf/html2pdf.class.php' at line (2133)


 
Posté : 15 Mai PM 17:055
(@babynus)
Posts: 14952
Membre Admin
 

but this report will be unreadble if we look over a huge collection of resources.

You're right. Maybe a "team" criteria parameter could be interesting ...
... it is subject of Ticket #646 😉


 
Posté : 15 Mai PM 19:055
(@babynus)
Posts: 14952
Membre Admin
 

About PDF issue, it is very strange, as the issue is in some external library, and I never met this case.

Could you please :
1) post a screenshot of result in standard html format (normal print)
2) try and change line 2133 in external/html2pdf/html2pdf.class.php
from

$s = 0; for ($i=0; $i<$corr[$y][$x][2]; $i++) $s+= $sw[$x+$i]);

to

$s = 0; for ($i=0; $i<$corr[$y][$x][2]; $i++) $s+= (isset($sw[$x+$i])?$sw[$x+$i]:0);

 
Posté : 15 Mai PM 20:055
(@babynus)
Posts: 14952
Membre Admin
 

You we also have to replace line 2156 in external/html2pdf/html2pdf.class.php
from

$s+= sw[$x+$i];

to

$s+= (isset($sw[$x+$i])?$sw[$x+$i]:0);

 
Posté : 15 Mai PM 20:055
(@hammurabi)
Posts: 26
Active Member
Début du sujet
 

Hello Babynus,

I'll ask a technical support to insert your suggestion ... As u can see, i'm working for an organization and i'm trying to identify a project manager tool for our realizations ...

Regards


 
Posté : 15 Mai PM 21:055
(@babynus)
Posts: 14952
Membre Admin
 

hi,

You may wait for V2.2.3, including fixing...
Coming soon.


 
Posté : 15 Mai PM 21:055
Share:
Retour en haut