View Full Version : I broke the bank! (Value of Items Sold)
January 31st, 2008, 12:52 AM
My site has slowly pushed up to the $1,000,000 mark, but when it got there, all of a sudden we are at $10,000,000,000.
Did I hit a limit?
January 31st, 2008, 06:50 AM
The field I think has a 12 digit limit. You can change that like this in phpmyadmin or such database manager.
ALTER TABLE cp_stats amt_sold amt_sold float(15,2) NOT NULL default '0';
February 1st, 2008, 12:03 AM
I'd like 10 billion in sales, but I really don't think I hit 12 digits. My sales should have only moved past 999,999 to 1,000,000 but instead it made a big jump to 10,000,000,000.
I'll need to fix it or I suppose remove it from the front page.
February 1st, 2008, 07:49 AM
All we do is add the cost of the auction that ends or the ad that is sold to the stats table so there are no mistakes there. You can edit your stats table all you like in phpmyadmin etc and change the amount to what you wish.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.