Pruning Stats - Does It Work For You? Options

[GoleyC]

It has been brought to our attention that possibley the 'Prune statistics' from the DB function isn't working.

We'are taking a survey from user who have the 'Prune statistics' turned on in the ACP.

Can these users check their User Logs to see if they have a log showing that Statistics have been pruned and report that back to us in the poll.

You may also reply to this topic if you find that the 'Prune statistics' isn't working for you and possible provide us a time line as to when it might have stopped working.

[Burgy]

Before I get to the point, I need to point out that I do apretiate your Work and the phpAdsNew / pgAdsNew and or future OpenAds. Thank you for the professional tool.

Second I am not sure what prune means and interpret it as cleaning up the statistics after a certain amount of time (settings) as a maintenance job. What is even less clear to me (german languaged) is, what the protokoll thing is about. I beleave you talk about the user logs and I can´t remember seeing an prune entry there, therefore I said No to that question in your servey.


The Error Report itself.

Enviroment:
mysql 4.0.24-10sarge1
php 4:4.3.10-16
Plesk 7.5.4 and formerly pd-Admin2 (which is rubbish and unsecure)
phpAdsNew 2.0.7 upgradet to 0.8 today

Whereas I changed the server in November I still habe a 40mb table with 1700 entries of user logs
and about 200.000 entries in the statistic table with about 12mb.

The statistic stopped working some weeks ago and some campains which were shown in the web did not get counts and clicks regarding the actual traffic but stayed 0.

Customer became angry and we noticed that at first only some comains had that problem and as it seems later the rest.


0> On the new and old server there was no statistic pruned and they flow eventually over.

As I hope my information helps you to improve your AdsSolution to an even better one.

For the moment I upgraded and copied the structure of both tables without taking the data with me and now are useing two brand new and empty tables. Strangely the statistic table stays empty but in the admin Statistic area I can see the first views and hits directly after switching to the empty tables.


With best Greatings from Berlin

[Erik Geurts]

To clarify things, in PAN you're going to have to go to the 'Settings' tab, and then select subtab 'User Log'.

Next, look for the most recent entry labeled "Auto clean of database" which usually happens around midnight. Click details on that line.

You'll see a short log, and user_log is shown as the last line in the log.

On my test system, this is what it shows for today:

CODE

Table phpads_adstats: deleted 0 rows
Table phpads_adviews: deleted 9638 rows
Table phpads_adclicks: deleted 11 rows
Table phpads_userlog: deleted 25 rows

I have PAN 2.0.8.

[mrbill]

I just turned on "Prune Statistics" today after realizing that my adview counts havent been kept correctly since March 1st.

The system says:

CODE

There are currently 1826 days worth of statistics available from where phpAdsNew can base its daily prediction on. The prediction is based on data from this week and last week. It isn't clear wether there will be enough AdViews served today to satisfy the target all high priority campaigns.

I told it to prune all but the last year (52 weeks) of stats, so hopefully that will solve the problem. Maybe PAN reaches a point where the stats "overflow" and start messing things up?

Update: Looks like the prune worked:

CODE

There are currently 362 days worth of statistics available from where phpAdsNew can base its daily prediction on. The prediction is based on data from this week and last week. It isn't clear wether there will be enough AdViews served today to satisfy the target all high priority campaigns.

I still don't know why direct-invocation adviews aren't being counted...

[whats_up_skip]

I am finding that the prune function is not working. I have tried everything that I have read in all the other threads about this. There is no record in the user log about it.
I am running 2.0.7.

I also tried to run a delete query on the "phpads_adstats" table to attempt a manual prune, but it will not let me it "Delete command denied to user ...". I am not sure if this has anything to do with the prune problem.

[GoleyC]

I am finding that the prune function is not working. I have tried everything that I have read in all the other threads about this. There is no record in the user log about it.
I am running 2.0.7.

I also tried to run a delete query on the "phpads_adstats" table to attempt a manual prune, but it will not let me it "Delete command denied to user ...". I am not sure if this has anything to do with the prune problem.

Sounds to me like you don't have enough permission. Check the User for that DB and see what permissions they have on that DB... PAN should have full access.

[whats_up_skip]

Turns out the problem was a corrupt table in the database. Once this was fixed it all worked properly.

Thanks for your help.