[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: System->taxes Database error

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: 


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)
WHERE c.tax
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