Re: Internal Server Error - LedgerSMB 1.3.37

[Arne Hanssen <..hidden..>]

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! :-)

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