<input type="hidden" id="_wpnonce" name="_wpnonce" value="419f4d4589" /><input type="hidden" name="_wp_http_referer" value="/blog/wp-json/wp/v2/posts/10559" /><input type="hidden" id="_wpnonce" name="_wpnonce" value="419f4d4589" /><input type="hidden" name="_wp_http_referer" value="/blog/wp-json/wp/v2/posts/10559" />{"id":10559,"date":"2017-06-20T16:14:59","date_gmt":"2017-06-20T06:14:59","guid":{"rendered":"https:\/\/www.businesslegions.com\/blog\/?p=10559"},"modified":"2017-06-20T16:14:59","modified_gmt":"2017-06-20T06:14:59","slug":"fix-issue-wordpress-plugin-banner-ads-rotator-not-displaying-ad-banners-page","status":"publish","type":"post","link":"https:\/\/www.businesslegions.com\/blog\/2017\/06\/20\/fix-issue-wordpress-plugin-banner-ads-rotator-not-displaying-ad-banners-page\/","title":{"rendered":"HOW TO FIX ISSUE WORDPRESS PLUGIN BANNER ADS ROTATOR NOT DISPLAYING AD BANNERS PAGE"},"content":{"rendered":"<!--CusAds0--><p>I&#8217;ve been using the <a href=\"https:\/\/wordpress.org\/plugins\/banner-ads-rotator\/\">Banner Ads Rotator plugin<\/a> 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.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-10568\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Page.png?strip=all\" alt=\"Ad Banner Manager - Page\" width=\"315\" height=\"118\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Page.png?strip=all 315w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Page-300x112.png?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Page-178x67.png?strip=all 178w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Page.png?strip=all&amp;w=63 63w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Page.png?strip=all&amp;w=126 126w\" sizes=\"(max-width: 315px) 100vw, 315px\" \/><\/p>\n<p>I just needed to go in there and delete some banners but couldn&#8217;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<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-10562\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-URL.png?strip=all\" alt=\"Ad Banner Manager URL\" width=\"636\" height=\"65\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-URL.png?strip=all 636w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-URL-300x31.png?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-URL-178x18.png?strip=all 178w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-URL.png?strip=all&amp;w=127 127w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-URL.png?strip=all&amp;w=381 381w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-URL.png?strip=all&amp;w=508 508w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-URL.png?strip=all&amp;w=450 450w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/p>\n<p>This would be the error message:<\/p>\n<p>This page isn&#8217;t working<\/p>\n<p>www.businesslegions.com\/blog\/ is currently unable to handle this request.<\/p>\n<p>HTTP ERROR 500<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-10564\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Error-Message.png?strip=all\" alt=\"Ad Banner Manager - Error Message\" width=\"629\" height=\"432\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Error-Message.png?strip=all 629w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Error-Message-300x206.png?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Error-Message-178x122.png?strip=all 178w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Error-Message.png?strip=all&amp;w=125 125w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Error-Message.png?strip=all&amp;w=377 377w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Error-Message.png?strip=all&amp;w=503 503w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Error-Message.png?strip=all&amp;w=450 450w\" sizes=\"(max-width: 629px) 100vw, 629px\" \/><\/p>\n<p>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:<\/p>\n<p>Login to your phpmyadmin\u00a0page<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-10563\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-phpMyAdmin.png?strip=all\" alt=\"Ad Banner Manager - phpMyAdmin\" width=\"501\" height=\"564\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-phpMyAdmin.png?strip=all 501w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-phpMyAdmin-266x300.png?strip=all 266w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-phpMyAdmin-158x178.png?strip=all 158w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-phpMyAdmin.png?strip=all&amp;w=100 100w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-phpMyAdmin.png?strip=all&amp;w=400 400w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-phpMyAdmin.png?strip=all&amp;w=450 450w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/p>\n<p>Let&#8217;s check to make sure it&#8217;s the correct table, by selecting your database and clicking on the table called wp_bar_info<\/p><!--CusAds0-->\n<p>You will notice that it will have a lot of entries, and it will have a column called bannerid. That&#8217;s the correct table (if you are unsure, then I recommend you backup the database before making any changes to it)<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-10561 size-large\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-database-entries.-883x666.png?strip=all\" alt=\"Ad Banner Manager database entries.\" width=\"883\" height=\"666\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-database-entries.-883x666.png?strip=all 883w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-database-entries..png?strip=all&amp;zoom=0.2&amp;resize=883%2C666 176w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-database-entries..png?strip=all&amp;zoom=0.4&amp;resize=883%2C666 353w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-database-entries..png?strip=all&amp;zoom=0.6&amp;resize=883%2C666 529w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-database-entries..png?strip=all&amp;zoom=0.8&amp;resize=883%2C666 706w\" sizes=\"(max-width: 883px) 100vw, 883px\" \/><\/p>\n<p>Now click on the database name<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-10565\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Database-Name.png?strip=all\" alt=\"Ad Banner Manager - Database Name\" width=\"885\" height=\"292\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Database-Name.png?strip=all 1324w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Database-Name-300x99.png?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Database-Name-768x253.png?strip=all 768w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Database-Name-178x59.png?strip=all 178w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Database-Name.png?strip=all&amp;w=529 529w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Database-Name.png?strip=all&amp;w=1059 1059w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Database-Name.png?strip=all&amp;w=450 450w\" sizes=\"(max-width: 885px) 100vw, 885px\" \/><\/p>\n<p>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.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-10566\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-mysql-wp_bar_info.png?strip=all\" alt=\"\" width=\"1070\" height=\"26\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-mysql-wp_bar_info.png?strip=all 1070w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-mysql-wp_bar_info-300x7.png?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-mysql-wp_bar_info-768x19.png?strip=all 768w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-mysql-wp_bar_info-178x4.png?strip=all 178w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-mysql-wp_bar_info.png?strip=all&amp;w=428 428w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-mysql-wp_bar_info.png?strip=all&amp;w=642 642w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-mysql-wp_bar_info.png?strip=all&amp;w=856 856w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/p>\n<p>You will receive the following message when the table is emptied. You will also notice the table is now 0\u00a0<img decoding=\"async\" class=\"alignnone size-full wp-image-10567\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-successfully-empty.png?strip=all\" alt=\"Ad Banner Manager successfully empty\" width=\"1103\" height=\"64\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-successfully-empty.png?strip=all 1103w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-successfully-empty-300x17.png?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-successfully-empty-768x45.png?strip=all 768w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-successfully-empty-178x10.png?strip=all 178w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-successfully-empty.png?strip=all&amp;w=441 441w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-successfully-empty.png?strip=all&amp;w=661 661w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-successfully-empty.png?strip=all&amp;w=882 882w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/p>\n<p>Now go back to the Ad Banner and it should now work.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-10569\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Banner-List.png?strip=all\" alt=\"Ad Banner Manager Banner List\" width=\"1879\" height=\"617\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Banner-List.png?strip=all 1879w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Banner-List-300x99.png?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Banner-List-768x252.png?strip=all 768w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Banner-List-178x58.png?strip=all 178w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Banner-List.png?strip=all&amp;w=375 375w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Banner-List.png?strip=all&amp;w=1127 1127w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Banner-List.png?strip=all&amp;w=1503 1503w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2017\/06\/Ad-Banner-Manager-Banner-List.png?strip=all&amp;w=450 450w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/p>\n<p>Hopefully, this has helped someone out there using this plugin and WordPress. If you still need any help, leave me a comment and I&#8217;ll try my best to help.<\/p>\n<div class=\"lt-box\" style=\"border:1px solid #1d6a9e\"><div class=\"lt-box-title\" style=\"background-color:#2485C6;border-top:1px solid #a7cee8;text-shadow:1px 1px 0 #0b283b\">DO YOU LIKE WHAT YOU'VE READ?<\/div><div class=\"lt-box-content\">Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!\r\n\r\n<p><div class=\"tnp tnp-subscription \">\n<form method=\"post\" action=\"https:\/\/www.businesslegions.com\/blog\/wp-admin\/admin-ajax.php?action=tnp&amp;na=s\">\n<input type=\"hidden\" name=\"nlang\" value=\"\">\n<div class=\"tnp-field tnp-field-firstname\"><label for=\"tnp-1\">Name<\/label>\n<input class=\"tnp-name\" type=\"text\" name=\"nn\" id=\"tnp-1\" value=\"\" placeholder=\"\"><\/div>\n<div class=\"tnp-field tnp-field-email\"><label for=\"tnp-2\">Email<\/label>\n<input class=\"tnp-email\" type=\"email\" name=\"ne\" id=\"tnp-2\" value=\"\" placeholder=\"\" required><\/div>\n<div class=\"tnp-field tnp-field-button\" style=\"text-align: left\"><input class=\"tnp-submit\" type=\"submit\" value=\"Subscribe\" style=\"\">\n<\/div>\n<\/form>\n<\/div>\n<\/p>\r\n\r\n<\/div><\/div><!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>I&#8217;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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":10571,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,1691,382,3499],"tags":[3297,4702,42,383,4703,1936],"class_list":["post-10559","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business","category-tip-and-tricks","category-wordpress","category-wordpress-2","tag-ads","tag-banner","tag-manager","tag-plugin","tag-rotator","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/10559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/comments?post=10559"}],"version-history":[{"count":2,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/10559\/revisions"}],"predecessor-version":[{"id":10572,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/10559\/revisions\/10572"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media\/10571"}],"wp:attachment":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media?parent=10559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/categories?post=10559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/tags?post=10559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}