Postage problem

[pinkequine]

Hi, I was trying to change the postage weights/prices under the heading first class mail, to increments of 0.25 kg starting at 0.50 kg. I have tried several times. I get this error message and then the program crashes out on me.

There was a problem with the database

Operation: Editing a record in the [Bands] table sorted by [ZoneID], [ClassID], [CalculationBasis], [BandWeight]

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

SELECT `BandID`,`ZoneID`,`ClassID`,`BandWeight`,`BandCost`,`CalculationBasis` FROM `Bands` ORDER BY `ZoneID`, `ClassID`, `CalculationBasis`, `BandWeight`

Action: Contact your Actinic reseller or Actinic Support as appropriate


Any thoughts?

[pinbrook]

try compacting the database

[pinkequine]

Thanks

Many thanks jo, that did the trick.

[los_design]

try compacting the database

Make this your first port of call when you have any issue and if need be, refresh the site.

Usually blows away any cob-webs

[pinkequine]

Thanks Los.... seeing as it was such a new site, I didn't even think I'd need to start dusting...

Thanks to all for your help, I'm learning loads all the time.