Re: Internal Server Error - LedgerSMB 1.3.37

On Sat, Feb 15, 2014 at 1:01 AM, Arne Hanssen <..hidden..> wrote:

After upgrading to 1.3.37 I get this error doing 'AP -> Add Transaction':

This sounds like the relevant fixes didn't get applied. Maybe they were partially applied at some point and didn't go through the second time?

Try this in psql as postgres:

ALTER TABLE ap ADD crdate date;

ALTER TABLE ar ADD crdate date;

Internal Server Error
The server encountered an internal error or misconfiguration and was
unable to complete your request. [....]

/var/log/apache2/error.log shows:
[Sat Feb 15 09:45:09 2014] [error] [client 192.168.1.1] DBD::Pg::st
execute failed: ERROR: column "crdate" of relation "ap" does not exist,
referer: http://ledgersmb.kingel.net/ap.pl
[Sat Feb 15 09:45:09 2014] [error] [client 192.168.1.1] LINE 17:
crdate = '',, referer: http://ledgersmb.kingel.net/ap.pl
[Sat Feb 15 09:45:09 2014] [error] [client 192.168.1.1] ^ at
LedgerSMB/AA.pm line 403., referer: http://ledgersmb.kingel.net/ap.pl
[Sat Feb 15 09:45:09 2014] [error] [client 192.168.1.1] DBD::Pg::st
execute failed: ERROR: current transaction is aborted, commands ignored
until end of transaction block at LedgerSMB.pm line 833., referer:
http://ledgersmb.kingel.net/ap.pl
[Sat Feb 15 09:45:09 2014] [error] [client 192.168.1.1] 2014/02/15
09:45:09 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1099) -- Logging SQL
State 25P02, error 7, string ERROR: current transaction is aborted,
commands ignored until end of transaction block, referer:
http://ledgersmb.kingel.net/ap.pl
[Sat Feb 15 09:45:09 2014] [error] [client 192.168.1.1] Can't use string
("LedgerSMB::Setting") as a HASH ref while "strict refs" in use at
LedgerSMB.pm line 941., referer: http://ledgersmb.kingel.net/ap.pl
[Sat Feb 15 09:45:09 2014] [error] [client 192.168.1.1] Compilation
failed in require at /home/httpd/ledgersmb/ap.pl line 7., referer:
http://ledgersmb.kingel.net/ap.pl
[Sat Feb 15 09:45:09 2014] [error] [client 192.168.1.1] Premature end of
script headers: ap.pl, referer: http://ledgersmb.kingel.net/ap.pl

How do I fix this? I guess the first message is the cause, but I my
knowledge of PostgreSQL and LSMB is far to limited to solve this on my own.

--
Vennlig hilsen / Best regards |\ ___,,--, _
Arne Hanssen, Senja, Norway /,`--'' \-,,__,'/
[ Linux counter #102028 @ ] |,4 ) )_ ) /~-----'
[ http://linuxcounter.net ]------'---^~(_/-_)--(_/_)-------

------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience. Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
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.shtml