Hi, I am trying to figure out the the latex differences between the templates I used in 1.3 and now fail in 1.4.
In order to do some trial&error debugging I want to edit the system/Latex templates/invoice, however when I want to save then it is denied. I have set the option "edit template" for the user, though that made no difference. What sql statement do I need to make to manually set the permission so I can edit and save the latex templates in the GUI? question on the side: how relate an invoice.tex file to a language? It is not a problem but LSMB complains it is not set to a language and I wonder how I could correct that. from error.log: 2014/09/21 17:07:58 - DEBUG - LedgerSMB::new LedgerSMB.pm (199) -- Begin called from $filename=lsmb-request.pl $line=51 $type=LedgerSMB $argstr= ref argstr= 2014/09/21 17:07:58 - DEBUG - LedgerSMB::new LedgerSMB.pm (227) -- params=$VAR1 = { 'template_name' => 'invoice', 'template' => '<?lsmb FILTER latex -?> . . . \\end{document} <?lsmb END ?> ' }, 'LedgerSMB::DBObject' ); DBD::Pg::st execute failed: ERROR: permission denied for relation template CONTEXT: SQL statement "UPDATE template SET template = in_template WHERE template_name = in_template_name AND format = in_format AND language_code IS NOT DISTINCT FROM in_language_code" PL/pgSQL function "template__save" line 4 at SQL statement at LedgerSMB.pm line 583. 2014/09/21 17:07:58 - ERROR - LedgerSMB::dberror LedgerSMB.pm (770) -- Logging SQL State 42501, error 7, string ERROR: permission denied for relation template CONTEXT: SQL statement "UPDATE template SET template = in_template WHERE template_name = in_template_name AND format = in_format AND language_code IS NOT DISTINCT FROM in_language_code" PL/pgSQL function "template__save" line 4 at SQL statement 2014/09/21 17:07:58 - ERROR - LedgerSMB::_error LedgerSMB.pm (647) -- Access Denied More information has been reported in the error logs at LedgerSMB.pm line 773. 2014/09/21 17:07:58 - ERROR - LedgerSMB::_error LedgerSMB.pm (648) -- dbversion: 1.4.0, company: company_name Died at LedgerSMB.pm line 661. Compilation failed in require at /usr/local/lsmb14/template.pl line 8. ------------------------------------------------------------------------------ Slashdot TV. Video for Nerds. Stuff that Matters. http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users