[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Upgrade Error
- Subject: Re: Upgrade Error
- From: "Angus Jordan" <..hidden..>
- Date: Thu, 12 Apr 2007 18:43:57 -0700
On 4/12/07, Leah Kubik <..hidden..> wrote:
> 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.
> 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...
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!