Thank you Chris. -- Mike Marseglia [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> wrote: >> This does seem awefully familiar, as if we just did a fix, however.... >> >> On 7/9/07, Chris Travers <[EMAIL PROTECTED]> wrote: >> > Thanks for the update. I am looking into the problem right now. >> > >> > On 7/9/07, Mike Marseglia <[EMAIL PROTECTED]> 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 >> > > [EMAIL PROTECTED] >> > > 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 >> > > > [EMAIL PROTECTED] >> > > > 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 >> > > > [email protected] >> > > > 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 >> > > [email protected] >> > > 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
