Guest Posted June 8, 2004 Share Posted June 8, 2004 Hi We've been using this system for our online store over a year now with no problems but suddenly the prices being displayed have changed from ?00.00 to ?0000 so stuff originally at ?14.99 now show up as ?1499 .Any ideas, we've tried changing the products price at admin panel but to no joy!! Please help! Link to comment Share on other sites More sharing options...
Acheron Posted June 8, 2004 Share Posted June 8, 2004 Have you checked the SQL DB to make sure it is still using 2 decimal places? With no decimal places in use, the problem you describe above would occur. Link to comment Share on other sites More sharing options...
Guest Posted June 8, 2004 Share Posted June 8, 2004 Stupid question but how would I check this? John Link to comment Share on other sites More sharing options...
Guest Posted June 8, 2004 Share Posted June 8, 2004 I've just gone to our database manager and phpadmin and we've got 2 databases-both seem to have the same tables in them. Under the Products table theres a line marked product-price. This is set as Not Null, decimal, 15,4 and default 0.0000 Changing this in either/both tables does not alter the problem. We're also getting ?2.50 p&p as ?250!! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.