Recently while following the search words in my Site Analytics a bit I’ve noticed that there is a small influx of people searching for a particular error that may pop up for some users after using AdRotate for a longer period of time or when your site is particularly busy.
The error in question is a duplicate entry error for the statistics AdRotate keeps and essentially means that the database is “full”.
The solution is rather simple and can be applied from PHPMyAdmin to raise the capacity in only a few minutes.
I have discovered this problem a while ago based on feedback from some users and created detailed page for users to resolve it. Due to the nature of the Query you need to run I do *not* want this in the automated upgrade process. So you have to make the change yourself.
If you run into the error;
WordPress database error Duplicate entry '16777215' for key 'PRIMARY' for query INSERT INTO wp_adrotate_tracker (ipaddress,timer,bannerid,stat,useragent) VALUES ('xxx.xxx.xxx.xxx','1358187611','59','i','')
(or something very similar)
You can find this in your servers “error_log” file through your hosting providers dashboard.
Check out this page with more details and the few simple steps on how to resolve the issue for you.
If you need help with this, obviously contact me as soon as you can and I will help you sort this out quickly.