Error AdRotate

  • estepona

    (@estepona)


    9 years, 6 months ago

    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

    (@adegans)

    9 years, 6 months ago

    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

    (@smlimmer)

    9 years, 4 months ago

    @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

    Plugin Author Arnan

    (@adegans)

    9 years, 4 months ago

    @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.