Thanks I hope my tests are helpful. Just running tests here on 1.4. Cheers Turtle
> 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 > <[email protected]>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 < >> [email protected]> wrote: >> >>> >>> >>> ----------------eredeti üzenet----------------- >>> Feladó: [email protected] >>> Címzett: [email protected] >>> 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 >>> [email protected] >>> 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. >> http://www.efficito.com/learn_more.shtml >> > > > ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
