Re: Internal Server Error - LedgerSMB 1.3.37

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

Den 15. feb. 2014 10:50, skrev Chris Travers:

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

> <mailto:..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;

acmedb=# ALTER TABLE ap ADD crdate date;
ALTER TABLE
acmedb=# ALTER TABLE ar ADD crdate date;
ALTER TABLE

Stille error message. Did setup.pl again. Still error message. Filled in
'Invoice Created' field with same date as 'Invoice Date' (tried that
also before I asked for help), and then it worked. Thanks a lot! :-)

If the error is saying that crdate doesn't exist then it must be a different db or a different table. What error are you still getting? I mean now you can be sure the field exists, right?

Best Wishes,

Chris Travers

I didn't have to to that before. Is this something new? I'm okay with
that, but out of curiosity: what's difference / purpose of two date
fields for Invoice? (Or may I wish for automatic copying value from
'Invoice Date' if 'Invoice Created' is left blank?)

>
> /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
> [...]

--
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