Huge Database?

The tracker table has a running set of rows logging clicks and such. Records older than 24 hours should be automatically purged.

This problem seems to still be on going.

The function adrotate_clean_trackerdata(); isn’t being called so the table is never being purged.

Any ideas?

Thanks

THat function should be called on periodically by wp-cron.
Can you confirm that that doesn’t happen? So far it seems to work for me.
I’ll look into it for the next release.

Hi Aman,

It def. didn’t run on one of our clients installations, the table had nearly 2.5 million entries in and caused the db to crash.

Nuts, I’ll look into it and see if I can make it more reliable ??
Were you able to repair the database? Need help? – [email protected]

I think I fixed it ??
https://www.adrotateplugin.com/download/changelog/

Thanks Aman, I’ll give it a try and yes, I was able to sort the database out.

When is the updated version likely to be released? Are we just waiting for WP to approve it?

I’m finishing up some things, I’m trying for tuesday/wednesday.

I have the same problem, how can I solve? Is there a MySQL command I can run to shrink the database?

Update to the latest version and manually re-activate the plugin to reset the cleanup schedule.

That worked, thanks a lot!

??

Updating to latest version, deactivating – activating doesn’t clean up database. I’ve tried it many times.

I ended up with 110MB of *adrotate_tracker.MYD table for one of my blog. It doesn’t even have massive traffic. This blog had massive traffic in the past so I’m assuming plugin doesn’t clean up old entries.

I manually triggered wp-cron.php but it doesn’t do cleanup.

Any solution?

Is there a way to disable tracking? I’m not interested in tracking I just want to serve ads.

If you look at the AdRotate Settings, near the bottom. There should be some schedules listed. What does it say there?

Also, please post in your own topic next time. This is not related to the original topic.