[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Internal Server Error - LedgerSMB 1.3.37




 Hi, 

This issue is fixed in the latest svn, just pull the latest svn from sourceforge or apply the patch if it is critical:

Bye,

István

----------------eredeti üzenet-----------------
Feladó: "Chris Travers" <..hidden..>
Címzett: "LedgerSMB Users" <..hidden..>
Dátum: Mon, 17 Feb 2014 04:15:06 -0800
----------------------------------------------------------





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


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

 

 

------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users