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
There must be an error logger in the log file.
Can you post it here please ?
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
By the way, i want understand why we can't select a resource in this report ?
Just because it was not concidered usefull.
All right.
but this report will be unreadble if we look over a huge collection of resources.
Thx
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)
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 😉
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);
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);
hi,
You may wait for V2.2.3, including fixing...
Coming soon.