HOW TO FIX ISSUE WORDPRESS PLUGIN BANNER ADS ROTATOR NOT DISPLAYING AD BANNERS PAGE
June 20, 2017 / by Marco / Categories : Business, TIP AND TRICKS, wordpress, Wordpress
I’ve been using the Banner Ads Rotator plugin on several of my WordPress sites to display different types of banners on the sites. I recently stumbled on an issue whereby when I tried clicking on Ads Banner, it would go to a default error page.

I just needed to go in there and delete some banners but couldn’t do this and was very frustrated. It would go to this URL: http://www.businesslegions.com/wp-admin/edit.php?post_type=ads_banner

This would be the error message:
This page isn’t working
www.businesslegions.com/blog/ is currently unable to handle this request.
HTTP ERROR 500

The fix was quite simple and I think it is related to the accumulation of stats gathered for each banner. The simple way I got around it was to login to the database and empty the stats table. To do this follow these step by step instructions:
Login to your phpmyadmin page

Let’s check to make sure it’s the correct table, by selecting your database and clicking on the table called wp_bar_info
You will notice that it will have a lot of entries, and it will have a column called bannerid. That’s the correct table (if you are unsure, then I recommend you backup the database before making any changes to it)

Now click on the database name

Then on the right hand side you will see all the tables. Click on the Empty button for the wp_bar_info table. If you look at the below screenshot you will notice this table was 105.6MiB which was quite large.
![]()
You will receive the following message when the table is emptied. You will also notice the table is now 0 
Now go back to the Ad Banner and it should now work.

Hopefully, this has helped someone out there using this plugin and WordPress. If you still need any help, leave me a comment and I’ll try my best to help.
Our Sponsors
- Advertise Me Pty Ltd
Digital Signage Solutions
OTHER ARTICLES YOU MAY LIKE
REVIEWING AND UNBOXING THE TOOCKI USB-C RIGHT ANGLE 1.2M CABLE
USB C cables are among the most ordinary accessories we own, yet they can make a surprisingly noticeable difference to how comfortable our devices are to use while charging. The Toocki USB C right angle cable is a good example of a simple accessory that tries to solve a very common irritation, because instead of […]
read more
QUICK FIX TO CHANGE THE MAX SELL POWER TO LESS THAN 500W ON THE DEYE INVERTER
There are many reasons a home owner or installer might want to place a tight cap on how much solar power is exported to the public grid. Some households live under a strict export cap imposed by their local distribution network operator, others want to reduce export to focus on self consumption and battery charging, […]
read more

