On Mon, Jul 16, 2012 at 2:59 PM, Nick Prater <[email protected]> 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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
