Title: Error AdRotate
Last modified: November 15, 2016

---

# Error AdRotate

 *  [estepona](https://wordpress.org/support/users/estepona/)
 * (@estepona)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/error-adrotate/)
 * Good morning, I’m experiencing problems with the creation of ads in adrotate,
   once prepared everything, I give you to save ad and this does not show me error,
   but the ad is not seen, it does not save the ads.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Arnan](https://wordpress.org/support/users/adegans/)
 * (@adegans)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/error-adrotate/#post-8468358)
 * If you updated recently, click the big “finish update” button.
    if there is no
   such button, check your servers error_log file for anything mentioning AdRotate.
   Anything is interesting.
 *  [smlimmer](https://wordpress.org/support/users/smlimmer/)
 * (@smlimmer)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/error-adrotate/#post-8651230)
 * [@adegans](https://wordpress.org/support/users/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](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](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](https://emtreview.com/wp-admin/admin.php?page=adrotate-ads)
 *  Plugin Author [Arnan](https://wordpress.org/support/users/adegans/)
 * (@adegans)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/error-adrotate/#post-8671679)
 * [@smlimmer](https://wordpress.org/support/users/smlimmer/) if you have the same
   problem, click the “finish update” button.
    It that doesn’t help open your own
   topic with more information.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Error AdRotate’ is closed to new replies.

 * ![](https://ps.w.org/adrotate/assets/icon-256x256.gif?rev=3117289)
 * [AdRotate Banner Manager](https://wordpress.org/plugins/adrotate/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/adrotate/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/adrotate/)
 * [Active Topics](https://wordpress.org/support/plugin/adrotate/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/adrotate/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/adrotate/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [Arnan](https://wordpress.org/support/users/adegans/)
 * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/error-adrotate/#post-8671679)
 * Status: not a support question