Re: gst change

[Barry Clearwater <..hidden..>]

Thanks for the brief but accurate response Chris.
As mailing lists have become the fallback for documentation, my steps below.

In a command line I changed user to ledgersmb, then executed:
psql -f tax_pkey_duplicate.sql bcsystems
PSQL responded:

ALTER TABLE
psql:tax_pkey_duplicate.sql:7: NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index "tax_unique" for table "tax"
ALTER TABLE
COMMENT
CREATE INDEX
COMMENT

I then get the error,

DBD::Pg::st execute failed: ERROR:  invalid input syntax for integer: ""

Error!

INSERT INTO tax (chart_id, rate, taxnumber, validto,
pass, taxmodule_id)
VALUES (?, ?, ?, ?, ?, ?)
ERROR: invalid input syntax for integer: ""

There is no instruction or hint as to why the ORDER integer is required, or what to put in there.  I guessed at a 0 for the old tax and a 1 for the new
This seems to do the trick
What is the order field for?

Regards
Barry

On 4 October 2010 19:01, Chris Travers <..hidden..> wrote:

Load the fixes in sql/fixes/ into the database.

Best Wishes,
Chris Travers

On Sun, Oct 3, 2010 at 5:34 PM, Barry Clearwater <..hidden..> wrote:
> As New Zealand changed its GST from 12.5% to 15% on Friday, (And I had a
> practise look at it some months ago - it seemed easy and logical) I entered
> an end date for the 12.5% and each new field came up, 1 for payable 1 for
> refund, for me to enter in the new amount.
> Unfortunately, it won't let me post the change, citing a
> DBD::Pg::st execute failed: ERROR: duplicate key value violates unique
> constraint "tax_pkey"
>
> I am at a loss, is this a bug, or am I supposed to fill in another field?
> Urgently requiring solution
>
> Many thanks
> --
>
> Barry Clearwater
>
> Managing director
> BC Systems Consultancy Limited
> ___________________________
> 18 Shaw Street
> Mosgiel
> Dunedin 9024
> Phone: +64 3 489 3915
> Mobile: +64 27 221 9338
> Email: ..hidden..
>
> skype: bctechnzl
>
>

> ------------------------------------------------------------------------------
> Virtualization is moving to the mainstream and overtaking non-virtualized
> environment for deploying applications. Does it make network security
> easier or more difficult to achieve? Read this whitepaper to separate the
> two and get a better understanding.
> http://p.sf.net/sfu/hp-phase2-d2d
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>

------------------------------------------------------------------------------
Virtualization is moving to the mainstream and overtaking non-virtualized
environment for deploying applications. Does it make network security
easier or more difficult to achieve? Read this whitepaper to separate the
two and get a better understanding.
http://p.sf.net/sfu/hp-phase2-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

--

Barry Clearwater

 

Managing director
BC Systems Consultancy Limited
___________________________
18 Shaw Street
Mosgiel
Dunedin 9024 
Phone: +64 3 489 3915
Mobile: +64 27 221 9338
Email: ..hidden..

skype: bctechnzl