PhotoPost Community - View Single Post

mferguson · October 13th, 2008, 10:11 AM

We had a user post a classified with a price of $10,000,000,000 and then marked it sold. It, obviously, trashed any meaningful information that was showing in the stats table for the number of items sold and the value of items sold. We've since deleted the ad so that it is no longer in the system but the stats cache has not been updated to reflect this. Is there a mysql query I can run to force a rebuild of the status table?

Thanks!

Mark

October 13th, 2008, 10:11 AM	#1 (permalink)
mferguson Junior Member Verified Customer Join Date: Feb 2003 Posts: 16	How to rebuild stats? We had a user post a classified with a price of $10,000,000,000 and then marked it sold. It, obviously, trashed any meaningful information that was showing in the stats table for the number of items sold and the value of items sold. We've since deleted the ad so that it is no longer in the system but the stats cache has not been updated to reflect this. Is there a mysql query I can run to force a rebuild of the status table? Thanks! Mark Last edited by mferguson; October 13th, 2008 at 10:28 AM.