Re: Upgrade Error

["Angus Jordan" <..hidden..>]

On 4/12/07, Leah Kubik <..hidden..> wrote:

Hi Angus,

<snip>

> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "tax_pkey" for table "tax"
> ERROR:  could not create unique index
> DETAIL:  Table contains duplicated values.

<snip>

> chart_id | rate |    taxnumber    |  validto
> ----------+------+-----------------+------------
>     10019 |    0 |                 | 2006-06-30
>     10019 | 0.06 | GSTNUMBER |
>     10020 | 0.07 | PSTNUMBER         |

I had a similar issue when I did my update.  In my case I just had some random
null entries below valid ones with the same ID.  I just deleted the. But in
your case it sounds like somthing needs to be done to deal with making sure
that you still have the 0 rate prior to 2006-06-30.  Maybe the chart_id can
be updated for this entry to something else, but I don't know the software
well enough to know if that would cause problems elsewhere (probably) so I'd
wait for an answer from Chris or someone who knows for sure...

Leah

Hi Leah,

I do need that "0" tax entry in there since I didn't have a GST number when we started the business.  We've always had a PST number though, that's why there's no second entry for the PST tax account..

I'd really appreciate a reply on this from someone who can help, it is a show stopper for me to even try this software with "real data."

I sure hope someone can help!

Regards,
Angus Jordan