----------------eredeti üzenet-----------------
Feladó: ..hidden..
Címzett: ..hidden..
Dátum: Thu, 21 Nov 2013 14:20:39 -0800
-------------------------------------------------
Hi,
> 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:
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