
[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] All prices are zero.. db corruption ?
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.
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users