[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: System->taxes Database error
- Subject: Re: System->taxes Database error
- From: Chris Travers <..hidden..>
- Date: Mon, 16 Jul 2012 18:21:04 -0700
On Mon, Jul 16, 2012 at 2:59 PM, Nick Prater <..hidden..>
I have just upgraded from 1.3.15 straight to 1.3.19.
Now when I go to System->Taxes, I get the following error:
SELECT c.id, c.accno, c.description,
t.rate * 100 AS rate, t.taxnumber, t.validto,
t.minvalue, t.pass, m.taxmodulename
FROM chart c
(tax t JOIN taxmodule m
ON (t.taxmodule_id = m.taxmodule_id))
ON (c.id = t.chart_id)
ORDER BY 3, 6
ERROR: column t.minvalue does not exist
LINE 4: t.minvalue, t.pass, m.taxmodulename
Hmm... I wonder if sql/modules/Fixes.sql had an error in this section.
Anyway here are the two statements which should have run. Please run them separately in psql or pgAdmin III. If you need step-by-step instructions for how to do this, we can provide that but IRC might be the best approach for interactive help there because it is more back-and-forth (and if nobody is around on #ledgersmb, try #postgresql for help on this topic).
ALTER TABLE tax ADD minvalue numeric;
ALTER TABLE tax ADD maxvalue numeric;
My guess is that for some reason, one of these failed and it aborted the other.