smlimmer

@adegans I was having the same problem. I would create the ad and it would say successful but not appear. The only way to correct it was to delete and reinstall (losing all the data) the pliugin. The database does not appear to be updating and here is the error we are seeing in the log:

[Thu Jan 12 16:55:59.333387 2017] [:error] [pid 24232] [client 72.224.224.163:42867] WordPress database error Unknown column ‘paid’ in ‘field list’ for query INSERT INTO wp_adrotate (title, bannercode, thetime, updated, author, imagetype, image, paid, tracker, desktop, mobile, tablet, os_ios, os_android, os_other, responsive, type, weight, budget, crate, irate, cities, countries) VALUES (”, ”, ‘1484240159’, ‘1484240159’, ‘Stephanie’, ‘dropdown’, ”, ‘U’, ‘N’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘N’, ’empty’, ‘6’, ‘0’, ‘0’, ‘0’, ‘a:0:{}’, ‘a:0:{}’) /* From [emtreview.com/wp-admin/admin.php?page=adrotate-ads&view=addnew] in [/nas/content/live/limmercreative/wp-content/plugins/adrotate/dashboard/publisher/adverts-edit.php:15] */ made by do_action(‘adrotate_page_adrotate-ads’), call_user_func_array, adrotate_manage, include(‘/plugins/adrotate/dashboard/publisher/adverts-edit.php’), referer: https://emtreview.com/wp-admin/admin.php?page=adrotate-ads

[Thu Jan 12 16:55:59.345026 2017] [:error] [pid 24232] [client 72.224.224.163:42867] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND group = 0 AND user = 0 AND schedule = wp_adrotate_schedule.id ORDE’ at line 1 for query SELECT wp_adrotate_schedule.id, starttime, stoptime, maxclicks, maximpressions FROM wp_adrotate_schedule, wp_adrotate_linkmeta WHERE ad = AND group = 0 AND user = 0 AND schedule = wp_adrotate_schedule.id ORDER BY wp_adrotate_schedule.id ASC LIMIT 1; /* From [emtreview.com/wp-admin/admin.php?page=adrotate-ads&view=addnew] in [/nas/content/live/limmercreative/wp-content/plugins/adrotate/dashboard/publisher/adverts-edit.php:27] */ made by do_action(‘adrotate_page_adrotate-ads’), call_user_func_array, adrotate_manage, include(‘/plugins/adrotate/dashboard/publisher/adverts-edit.php’), referer: https://emtreview.com/wp-admin/admin.php?page=adrotate-ads

[Thu Jan 12 16:55:59.345351 2017] [:error] [pid 24232] [client 72.224.224.163:42867] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND user = 0 AND schedule = 0; /* From [emtreview.com/wp-admin/admin.php?pag’ at line 1 for query SELECT group FROM wp_adrotate_linkmeta WHERE ad = AND user = 0 AND schedule = 0; /* From [emtreview.com/wp-admin/admin.php?page=adrotate-ads&view=addnew] in [/nas/content/live/limmercreative/wp-content/plugins/adrotate/dashboard/publisher/adverts-edit.php:28] */ made by do_action(‘adrotate_page_adrotate-ads’), call_user_func_array, adrotate_manage, include(‘/plugins/adrotate/dashboard/publisher/adverts-edit.php’), referer: https://emtreview.com/wp-admin/admin.php?page=adrotate-ads