Re: Upgrade to 1.2.5 trouble

["Chris Travers" <..hidden..>]

Hotfix email forthcoming.  For those who have not upgraded yet, I
suggest upgrading to 1.2.5 only if you require fixes for those areas
specifically listed in the changelog.  Otherwise wait for 1.2.6.  THe
fixes in 1.2.5 are major for some users, but do not affect everyone.

On 5/18/07, Charley Tiggs <..hidden..> wrote:
> I just upgraded to 1.2.5.  It seems that, in that upgrade, I should have
> run a particular script to upgrade the database first.  Yet, I have no
> idea where that script is located. Specifically, when I try to go to AP
> -> Add Transaction, I get the following error:
>
>   SELECT ct.name AS vendor, ct.curr AS currency, ct.id AS vendor_id,
> current_date + ct.terms AS duedate,
> ct.notes,
> ct.curr AS currency
> FROM vendor ct
> WHERE ct.id = (select customer_id from ap where 1 = 1 AND vendor_id IS
> NOT NULL order by id DESC limit 1)
> ERROR: column "customer_id" does not exist
> LINE 7: WHERE ct.id = (select customer_id from ap where 1 = 1 AND ...
>
>
> Can someone point me in the right direction to get this fixed?
>
> Thanks,
> Charley
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users