I was hoping the most recent update would fix this, but I’m sorry to report that the transient data is not being deleted. It has inserted about 670,000 rows in the last 6 days, so I once again manually deleted it. Is there some other setting we need to activate for this to occur?
(I’m using AdRotate Free 3.19 on WordPress 4.7.2.)
There is no option on the Settings > Maintenance page to activate a schedule; should there be one? (Reminder: I am using the free version, if that makes a difference.) In the Status and Versions section of the Maintenance page, it does say:
Clean Transients February 24, 2017 15:53
However it has said that before with an earlier date, and the date has passed and the transients were not deleted. The date changes, but the transients are not deleted.
The transient data is still not being deleted from the wp_options table. I have confirmed the schedule is active under Settings > Maintenance. I disabled and re-enabled “clean up temporary data” on the Stats page, waited until the date/time shown next to Clean Transients on the Maintenance page had passed. They were not deleted. I tried all that a couple of times.
Everything is set correctly based on your guidance, but they are still not being deleted and I have to do it manually every few days so my site won’t be impacted. Is it possible that the plug-in does not have permissions to delete from the wp_options table? Could that be why they are not being cleaned up?