Ads sold

WarDog · January 28th, 2011, 03:06 PM

Chuck

When a member sells their ad and they mark it sold it stays showing for 3 days as sold. Now this is correct and working correctly because I have the setups set for 3 days, but the number of items sold and value of items sold never updates, it always stays 0 and n/a, why?

WD

Chuck S · January 28th, 2011, 03:37 PM

The stats should update there is a query that updates that when you mark it sold

Have you turned off the category cache?

WarDog · January 28th, 2011, 05:04 PM

I had cache set to no, but I've turned it on now and the caching is set for every 10 minutes but nothing has upgraded. Have I lost everything prior to turning it on?

Chuck S · January 28th, 2011, 07:47 PM

whether or not you use a cache has nothing to do with losing anything.

I really cant comment without seeing a url.

I know if I mark an ad sold the stats are updated.

WarDog · January 28th, 2011, 08:24 PM

Here is the url to the site or do need another url?

Main Index - NFMI Classifieds

Chuck S · January 28th, 2011, 11:18 PM

You can send a test login for me to try through the contact us link.

This query is most definitely in the editproduct.php file under the sold clause

Code:

Content visible to verified customers only.

WarDog · January 29th, 2011, 03:56 PM

Chuck

I sent you login info via contact us form.

Chuck S · January 29th, 2011, 07:03 PM

No problem will see what I can find.

WarDog · January 29th, 2011, 07:12 PM

I forgot to give you the URL: NFMI.org/classified

Chuck S · January 29th, 2011, 07:18 PM

yeah you definately need to send your cpanel I have to see that database

Something is not right in denmark I would bet my bottom dollar your stats table insert is missing. That would explain why an update query would not work. I also notice you have some code in your footer you have been modifying something.

WarDog · January 29th, 2011, 07:32 PM

I just sent you login info for cpanel.

Chuck S · January 30th, 2011, 12:35 AM

No problem

WarDog · January 30th, 2011, 09:36 AM

Chuck

Did you get my cpanel login info?

Chuck S · January 30th, 2011, 12:17 PM

Yep you should be all fixed. As I figured your stats table was missing its insert.

WarDog · January 30th, 2011, 10:14 PM

Thanks Chuck and when should the statistics start showing how many items and dollar amount that has been sold?
Everything is still 0 and n/a.

Chuck S · January 31st, 2011, 06:24 AM

Everything would be 0 until you mark something sold etc

Your been running your site with no stats table insert for some reason.

WarDog · February 9th, 2011, 04:53 PM

Chuck

I now have -2 items sold and -$90.00 value of items sold. What is causing this and where do I go to correct it?

Chuck S · February 10th, 2011, 07:30 AM

did someone relist two ads and maybe since you never had the stats query entry there before the original queries to add stats did not work

Your only recourse would be to 0 them under the stats table in phpmyadmin.

WarDog · February 10th, 2011, 07:46 AM

Hey Chuck

I'm sure that is what probably has happen. There were a few ads marked sold a ways back before you corrected the stats table.

When I zero it out, in the dollar amount column do I put 0 or 0.00

Chuck S · February 10th, 2011, 07:49 AM

yes 0 for both works and thats the only way it could have happened. The stats table is only adjusted for very few actions so its an easy question to answer.