WordPress.org

Ready to get started?Download WordPress

Forums

AdRotate
[resolved] Huge Database? (18 posts)

  1. ncdesignz
    Member
    Posted 1 year ago #

    I am using the latest version of AdRotate, and have been doing some database cleanup for my client.

    Why is it that we are running 63 ads, and yet there are 1,984,944 rows in the WP AdRotate Tracker table?

    http://wordpress.org/extend/plugins/adrotate/

  2. Arnan de Gans
    Member
    Plugin Author

    Posted 1 year ago #

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

  3. stuartmcnair
    Member
    Posted 1 year ago #

    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

  4. Arnan de Gans
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  5. stuartmcnair
    Member
    Posted 1 year ago #

    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.

  6. Arnan de Gans
    Member
    Plugin Author

    Posted 1 year ago #

    Nuts, I'll look into it and see if I can make it more reliable :)
    Were you able to repair the database? Need help? - info@ajdg.net

  7. Arnan de Gans
    Member
    Plugin Author

    Posted 1 year ago #

  8. stuartmcnair
    Member
    Posted 1 year ago #

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

  9. stuartmcnair
    Member
    Posted 1 year ago #

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

  10. Arnan de Gans
    Member
    Plugin Author

    Posted 1 year ago #

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

  11. baga
    Member
    Posted 1 year ago #

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

  12. Arnan de Gans
    Member
    Plugin Author

    Posted 1 year ago #

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

  13. baga
    Member
    Posted 1 year ago #

    That worked, thanks a lot!

  14. Arnan de Gans
    Member
    Plugin Author

    Posted 1 year ago #

    :)

  15. ajaykumarsinghuk
    Member
    Posted 8 months ago #

    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.

  16. Arnan de Gans
    Member
    Plugin Author

    Posted 8 months ago #

    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.

  17. ajaykumarsinghuk
    Member
    Posted 8 months ago #

    Tx Found the settings.
    Back to original problem - cleanup still doesn't work after upgrade. I had to manually empty the table from phpMyAdmin.

  18. Arnan de Gans
    Member
    Plugin Author

    Posted 8 months ago #

    Right, but are the cleanup routines scheduled as I Asked in my previous reply?
    If not, make sure wp-cron works. If it doesn't then that's the problem.
    Otherwise re-activating the plugin solves the issue if your WordPress works correctly.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags