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

Re: column "crdate" of relation "ar" does not exist

It's 1.4, evidenty part of my merge of your changes didn't go according to plan.  I am correcting it now.

On Thu, Nov 21, 2013 at 11:46 PM, Pongrácz István <..hidden..> wrote:

----------------eredeti üzenet-----------------
Feladó: ..hidden..
Címzett: ..hidden..
Dátum: Thu, 21 Nov 2013 14:20:39 -0800

> Working in svn Revision: 6305
> I get the following error when posting an ar transaction to an mostly
> empty db:
> ERROR: column "crdate" of relation "ar" does not exist
> LINE 17: crdate = '2013-11-21',
> I did a grep -r of the sql directory for 'crdate' and came up with nothing.
> Doing a
> ALTER TABLE ONLY ar ADD crdate date;
> Fixes the issue.
> Is there a file should be run on the database after a svn update?
> Cheers
> turtle


Do you use the 1.4 or 1.3 ?

The crdate come up in 1.3.3x and means invoice creation date.

In the 1.3 series it should work without problem, in other words, the upgrade to using crdate is working.

Check this commit:

Here you can see the database, search for crdate, comment included:

Here you can see the fixes (for upgrade from previous 1.3 version):

I hope you can fix it quickly. I will check the database in trunk, maybe in the weekend I will have time.


Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
Ledger-smb-devel mailing list

Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.