Re: Error creating invoice LSMB 1.3.39.

[Pongrácz István <..hidden..>]

In other words: you should run setup.pl via the web browser and rebuild your DB.

Backup, please :)

Cheers,
István 
 

----------------eredeti üzenet-----------------
Feladó: "Arne Hanssen" 
Címzett: "Ledger SMB" ..hidden.. 
Dátum: Sun, 06 Apr 2014 19:35:11 +0200
-------------------------------------------------
 
 
> After [Post]-ing a sales invoice I can't print the invoice from the next 
> screen. When I click [Print] I get this error:
> 
> Internal Server Error
> The server encountered an internal error or misconfiguration and was 
> unable to complete your request.
> 
> Apache log shows:
> [Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] DBD::Pg::st 
> execute failed: ERROR: column "remark" does not exist, referer: 
> http://ledgersmb.kingel.net/is.pl
> [Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] LINE 8: ... 
> '' AS customertaxnumber, sic_code AS sic, iban, remark,, referer: 
> http://ledgersmb.kingel.net/is.pl
> [Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] 
> ^ at LedgerSMB/IS.pm 
> line 909., referer: http://ledgersmb.kingel.net/is.pl
> [Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] DBD::Pg::st 
> execute failed: ERROR: current transaction is aborted, commands ignored 
> until end of transaction block at LedgerSMB.pm line 834., referer: 
> http://ledgersmb.kingel.net/is.pl
> [Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] 2014/04/06 
> 19:14:48 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1102) -- Logging SQL 
> State 25P02, error 7, string ERROR: current transaction is aborted, 
> commands ignored until end of transaction block, referer: 
> http://ledgersmb.kingel.net/is.pl
> [Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] Can't use string 
> ("LedgerSMB::Setting") as a HASH ref while "strict refs" in use at 
> LedgerSMB.pm line 942., referer: http://ledgersmb.kingel.net/is.pl
> [Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] Compilation 
> failed in require at /home/httpd/ledgersmb/is.pl line 7., referer: 
> http://ledgersmb.kingel.net/is.pl
> [Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] Premature end of 
> script headers: is.pl, referer: http://ledgersmb.kingel.net/is.pl
> 
> Seems like column "remark" is missing. How do I fix this? Invoicing 
> worked fine up to version 1.3.37 (1.3.38 was used only briefly before 
> upgrading to 1.3.39).
> 
> -- 
> Vennlig hilsen / Best regards |\ ___,,--, _
> Arne Hanssen, Senja, Norway /,`--'' \-,,__,'/
> [ Linux counter #102028 @ ] |,4 ) )_ ) /~-----'
> [ http://linuxcounter.net ]------'---^~(_/-_)--(_/_)-------
> 
> 
> --------------------------------------------------------------------
> ----------
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden.. 
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> 



------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users