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

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

Thank you Chris.

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

On Tue, July 10, 2007 12:13 am, Chris Travers wrote:
> Ok.  The problem is that you post the transaction and then a variable
> is not being set properly when it returns you to an ar transaction
> report screen.
>
> This error is an annoyance but it occurs after the transaction commits
> (it is a display issue).  I will see if we can get a fix in for 1.2.7.
>
> Best Wishes,
> Chris Travers
>
> On 7/9/07, Chris Travers <..hidden..> wrote:
>> This does seem awefully familiar, as if we just did a fix, however....
>>
>> On 7/9/07, Chris Travers <..hidden..> wrote:
>> > Thanks for the update. I am looking into the problem right now.
>> >
>> > On 7/9/07, Mike Marseglia <..hidden..> wrote:
>> > > 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
>> > > >
>> > >
>> > >
>> > >
>> > > -------------------------------------------------------------------------
>> > > 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
>> > >
>> >
>>
>
> -------------------------------------------------------------------------
> 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
>