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

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

The change has been committed.

Generally what to do is to run the setup.pl file again on your db.  It will detect the version, load schema changes, and reload stored procedures.

Since you partially fixed this on your own, you will want to take a look at the final transaction in sql/modules/Fixes.sql and apply those changes you have not yet applied to your database.

Best Wishes,
Chris Travers


On Fri, Nov 22, 2013 at 1:21 AM, Chris Travers <..hidden..> wrote:
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


Hi,

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:
sourceforge.net/p/ledger-smb/code/6070

Here you can see the database, search for crdate, comment included:
https://sourceforge.net/p/ledger-smb/code/HEAD/tree/branches/1.3/sql/Pg-database.sql

Here you can see the fixes (for upgrade from previous 1.3 version):
https://sourceforge.net/p/ledger-smb/code/HEAD/tree/branches/1.3/sql/modules/Fixes.sql

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

Cheers,
István



------------------------------------------------------------------------------
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.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel



--
Best Wishes,
Chris Travers

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



--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.
http://www.efficito.com/learn_more.shtml