[ic] All prices are zero.. db corruption ?

interchange-users@interchange.redhat.com interchange-users@interchange.redhat.com
Sat Sep 29 11:25:00 2001


Quoting Jim Balcom <jim@idk-enterprises.com>:

> On 28 Sep 2001, Eduardo Dominguez wrote:
> 
> ED>>After changing the products database to my own, all product prices
> are
> ED>>now zero. Could this be a database corruption ? I check the DB
> ED>>and the UI and I see that the prices are OK. Everything else is
> fine.
> ED>>Just the the prices are zero.
> ED>>
> ED>>What should I check to verify the DB is corrupted ? Are there
> other
> ED>>possible causes of this behaviour ?
> 
> Since I don't know how you generated the new one, one thought that comes
> to
> mind is that perhaps the fields are not tab-delimited, and perhaps you
> have
> spaces, instead of tabs, between the fields.
> 
> Did you click on 'Apply Changes'? Did you restart the server?
> 
> If you did all of those things, delete products.gdbm and then go back
> into
> the web page. The gdbm file should re-generate and you should have
> your
> prices.
> 
> -= Jim =-

Other possible causes which I have seen:

- Changing the name of the price column without updating the catalog.cfg;
- Carriage returns embedded in the file, usually caused by editing it on a 
Windows box;
- Including the currency symbol in the database;

...and no doubt there are others.

- Ed L.