WordPress.org

1. ncdesignz
   Member
   Posted 3 months 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 3 months 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 3 months 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 3 months 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 3 months 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 3 months 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 3 months ago #
   

   I think I fixed it :)
   http://www.adrotateplugin.com/download/changelog/

8. stuartmcnair
   Member
   Posted 2 months ago #
   

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

9. stuartmcnair
   Member
   Posted 2 months 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 2 months ago #
    

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

11. baga
    Member
    Posted 1 month 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 month ago #
    

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

13. baga
    Member
    Posted 1 month ago #
    

    That worked, thanks a lot!

14. Arnan de Gans
    Member
    Plugin Author
    Posted 1 month ago #
    

    :)

Reply

You must log in to post.