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

[..hidden..]

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
> <..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.
>> http://www.efficito.com/learn_more.shtml
>>
>
>
>