On Mon, Jul 16, 2012 at 2:59 PM, Nick Prater
<..hidden..> wrote:
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:
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
LEFT JOIN
(tax t JOIN taxmodule m
ON (t.taxmodule_id = m.taxmodule_id))
ON (c.id = t.chart_id)
WHERE c.tax
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.
Best wishes,
Chris Travers