[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.