Re: import .tex template and PDF print error (was: Re: 1.4 UI: default template directory drop menu missing)

On Fri, Jun 6, 2014 at 3:04 AM, Max van Biezen <..hidden..> wrote:

Hi,

>> LSMB 1.4 does not show a drop down box to select the templates.
>> Has this changed from 1.3 which shows this in menu "system defaults /
>> templates directory / <drop down>"?
>
> Yes. These are now imported into the db at db creation time. They can be
> reloaded using the setup.pl.

That is good.

When trying to import the templates that worked for 1.3.39 I get an
error from LSMB 1.4

DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding
"UTF8": 0x89 at LedgerSMB.pm line 581, <TEMP> line 17.
2014/06/06 09:18:41 - ERROR - LedgerSMB::dberror LedgerSMB.pm (768) --
Logging SQL State 22021, error 7, string ERROR: invalid byte sequence
for encoding "UTF8": 0x89
2014/06/06 09:18:41 - ERROR - LedgerSMB::_error LedgerSMB.pm (645) --
22021:ERROR: invalid byte sequence for encoding "UTF8": 0x89 at
LedgerSMB.pm line 777, <TEMP> line 17.
2014/06/06 09:18:41 - ERROR - LedgerSMB::_error LedgerSMB.pm (646) --
dbversion: 1.4.0, company:
Died at LedgerSMB.pm line 659, <TEMP> line 17.
Compilation failed in require at /usr/local/lsmb14/setup.pl line 8,
<TEMP> line 17.

I have limited the import to one language and only invoice.tex that
does refer to a4bottom.tex and a4head.tex which in turn refer to two
.png files holding the logo and some nice looking footer.

The .pngs are probably where the problem lies. I am working on a file redirection layer to the database (using our in-db file attachments) but that's not really ready right now. The pngs will have to remain in the filesystem for now.

1. When I simply delete the two .PNG files from invoice.tex and make
no changes to invoice.tex then it seems to finish its import
correctly. At least no error is produced. However with the .PNG files
in the import subdir then I get the error:

Templates are stored as text fields, so PostgreSQL checks for UTF8-correctness. Again, working on binary support but it isn't there yet.

DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding
"UTF8": 0x89 at LedgerSMB.pm line 581, <TEMP> line 17.
2014/06/06 09:18:41 - ERROR - LedgerSMB::dberror LedgerSMB.pm (768) --
Logging SQL State 22021, error 7, string ERROR: invalid byte sequence
for encoding "UTF8": 0x89
2014/06/06 09:18:41 - ERROR - LedgerSMB::_error LedgerSMB.pm (645) --
22021:ERROR: invalid byte sequence for encoding "UTF8": 0x89 at
LedgerSMB.pm line 777, <TEMP> line 17.
2014/06/06 09:18:41 - ERROR - LedgerSMB::_error LedgerSMB.pm (646) --
dbversion: 1.4.0, company:
Died at LedgerSMB.pm line 659, <TEMP> line 17.
Compilation failed in require at /usr/local/lsmb14/setup.pl line 8,
<TEMP> line 17.

I have limited the import to one language and only invoice.tex that
does refer to a4bottom.tex and a4head.tex which in turn refer to two
.png files holding the logo and some nice looking footer.

2. Using the import steps from point 1 and having deleted the two .PNG
files then when I try to print a PDF to screen then I get the
following error. Btw on this same server I have 1.3 running which
produces the PDF's correct.

2014/06/06 11:59:09 - ERROR - Form::_error LedgerSMB/Form.pm (437) --
'Attempt to reload LedgerSMB/Template/LaTeX.pm aborted.
Compilation failed in require at (eval 1401) line 2
eval 'require LedgerSMB::Template::LaTeX
;' called at LedgerSMB/Template.pm line 321
LedgerSMB::Template::render('LedgerSMB::Template=HASH(0x6ae38d0)',
'Form=HASH(0x1fa6ac8)') called at bin/io.pl line 1994
lsmb_legacy::print_form(undef) called at bin/io.pl line 1574
lsmb_legacy::print called at old-handler.pl line 207
lsmb_legacy::__ANON__() called at /usr/share/perl5/Try/Tiny.pm line 76
eval {...} called at /usr/share/perl5/Try/Tiny.pm line 67
Try::Tiny::try('CODE(0x20c2228)',
'Try::Tiny::Catch=REF(0x646f748)') called at old-handler.pl line 224
require old-handler.pl called at LedgerSMB/Template.pm line 323
LedgerSMB::Template::render('LedgerSMB::Template=HASH(0x6ae38d0)',
'Form=HASH(0x1fa6ac8)') called at bin/io.pl line 1994
lsmb_legacy::print_form(undef) called at bin/io.pl line 1574
lsmb_legacy::print called at old-handler.pl line 207
lsmb_legacy::__ANON__() called at /usr/share/perl5/Try/Tiny.pm line 76
eval {...} called at /usr/share/perl5/Try/Tiny.pm line 67
Try::Tiny::try('CODE(0x20c2228)',
'Try::Tiny::Catch=REF(0x646f748)') called at old-handler.pl line 224
require old-handler.pl called at /usr/local/lsmb14/is.pl line 7

That sounds like a compile error with the module. Please try this in your LedgerSMB root dir:

perl -MLedgerSMB::Template::LaTeX -e print

Please send me the resulting output.

'
2014/06/06 11:59:09 - ERROR - Form::_error LedgerSMB/Form.pm (438) --
dbversion: 1.4.0, company: Company Name
exit at LedgerSMB.pm line 627
LedgerSMB::finalize_request() called at LedgerSMB/Form.pm line 468
Form::finalize_request('Form=HASH(0x1fa6ac8)') called at
LedgerSMB/Form.pm line 445
Form::_error('Form=HASH(0x1fa6ac8)', '\'Attempt to reload
LedgerSMB/Template/LaTeX.pm aborted.\x{a}Comp...') called at
old-handler.pl line 222
lsmb_legacy::__ANON__('Attempt to reload
LedgerSMB/Template/LaTeX.pm aborted.\x{a}Compil...') called at
/usr/share/perl5/Try/Tiny.pm line 100
Try::Tiny::try('CODE(0x20c2228)',
'Try::Tiny::Catch=REF(0x646f748)') called at old-handler.pl line 224
require old-handler.pl called at /usr/local/lsmb14/is.pl line 7
Compilation failed in require at /usr/local/lsmb14/is.pl line 7

What is LSMB telling me when it fails to print the PDF to screen?
Should I update/add specific perl packages for 1.4 (which I have not)?

Maybe we are missing a dependency from the makefile?

Best Wishes,

Chris Travers

Max

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more