Re: Credit remaining "NaN" and relation vc does not exist

["Mike Marseglia" <..hidden..>]

I would like to update this:

Evidently my transactions were being processed despite the error.  I now
have three of the same transactions.  When I delete the transaction I get
the same error, but it still deletes the transaction.

Is this a known thing?  Did my DB upgrade not go so well?

Also, the "NaN" went away.

-- 
Mike Marseglia
..hidden..
http://www.marseglia.org

On Mon, July 9, 2007 10:32 pm, Mike Marseglia wrote:
> Hi!
>
>   I was using SQL Ledger as part of the Debian stable distribution.  I
> converted to Ledger SMB.  The DB upgrade did not error.  I am using
> version  1.2.6.
>
>   I entered an AR Transaction and it did not seem to go through.  I
> re-entered the transaction and I got the following error:
>
> DBD::Pg::st execute failed: ERROR: relation "vc" does not exist
> Error!
>
>
> SELECT a.id, a.invnumber, a.ordnumber, a.transdate,
> a.duedate, a.netamount, a.amount, (
> SELECT SUM(ac.amount) * -1 * 1
> FROM acc_trans ac
> JOIN chart c ON (c.id = ac.chart_id)
> WHERE ac.trans_id = a.id
> AND (c.link LIKE '%AR_paid%'
> OR c.link = '')) AS paid,
> a.invoice, a.datepaid, a.terms, a.notes,
> a.shipvia, a.shippingpoint, e.name AS employee,
> vc.name,
> a._id, a.till, m.name AS manager, a.curr,
> ex.buy AS exchangerate,
> d.description AS department,
> a.ponumber
> FROM ar a
> JOIN vc ON (a._id = vc.id)
> LEFT JOIN employee e ON (a.employee_id = e.id)
> LEFT JOIN employee m ON (e.managerid = m.id)
> LEFT JOIN exchangerate ex ON (ex.curr = a.curr
> AND ex.transdate = a.transdate)
> LEFT JOIN department d ON (a.department_id = d.id)
> WHERE 1 = 1
> ORDER BY 4 ASC,2,16
> ERROR: relation "vc" does not exist
>
>
>   Also, I noticed their "credit remaining" is now displayed as "NaN" which
> I'm assuming means "Not a Number".
>
>   Not sure what happened here.  The first AR Transaction I processed went
> through fine.
>
> --
> Mike Marseglia
> ..hidden..
> http://www.marseglia.org
>
>
>
>
> -------------------------------------------------------------------------
> 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
>