On Wed, Feb 4, 2009 at 6:17 AM, Stroller <[email protected]> wrote: > Amending an existing customer's details to add their email address > today, I got the following error when pressing the save button: > > 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, (a.paid) 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 AND a.transdate >= '1/12/8' > ORDER BY 4 ASC,2,16 > ERROR: relation "vc" does not exist > > I am using the venerable version 1.2.8 of LedgerSMB, but I'm inclined > to think I may have missed running a database upgrade script during an > earlier update. The email address has been correctly saved to the > account's details if I search for that customer once again. > > Any thoughts?
This is not a schema issue but a query issue. I believe that a variable is not getting set. vc is supposed to be a table alias. We have fixed a LOT of bugs since 1.2.8. You might try upgrading and see if that corrects the issue. Best Wishes, Chris Travers ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
