Title: Problem Adding New Advert Last modified: September 24, 2024 --- # Problem Adding New Advert * Resolved [navaweb](https://wordpress.org/support/users/navaweb/) * (@navaweb) * [1 year, 8 months ago](https://wordpress.org/support/topic/problem-adding-new-advert/) * [@adegans](https://wordpress.org/support/users/adegans/) Further to this post: [https://wordpress.org/support/topic/cant-create-a-new-advert/](https://wordpress.org/support/topic/cant-create-a-new-advert/) * I am having the same issue… tried several things to solve it, including re-installing and even installing an older version. I get the following error: * **WordPress database error:** [Unknown column ‘desktop’ in ‘field list’] `INSERT INTO ``wp_adrotate` (`title`, `bannercode`, `thetime`, `updated`, `author`, ` imagetype`, `image`, `tracker`, `show_everyone`, `desktop`, `mobile`, `tablet`,` os_ios`, `os_android`, `type`, `weight`, `autodelete`, `budget`, `crate`, `irate`,` state_req`, `cities`, `states`, `countries`) VALUES ('', '', '1727124926', '1727124926',' hello@navaweb.com', 'dropdown', '', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'empty',' 6', 'N', '0', '0', '0', 'N', 'a:0:{}', 'a:0:{}', 'a:0:{}') * **WordPress database error:** [Unknown column ‘daystarttime’ in ‘field list’] ` INSERT INTO ``wp_adrotate_schedule` (`name`, `starttime`, `stoptime`, `maxclicks`,` maximpressions`, `spread`, `spread_all`, `daystarttime`, `daystoptime`, `day_mon`,` day_tue`, `day_wed`, `day_thu`, `day_fri`, `day_sat`, `day_sun`, `autodelete`) VALUES ('Schedule for ad 0', '1727124926', '1734382526', '0', '0', 'N', 'N', ' 0000', '0000', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N')**There was an error loading the page. Please try again by reloading the page via the menu on the left.If the issue persists please seek help on the [support forums](https://ajdg.solutions/forums/forum/adrotate-for-wordpress/) * We did not have this issue before.. I assume something failed during the last update maybe… How can I resolve it, without uninstalling (and losing all current settings/ads)? * Some other Errors in php error log: * [24-Sep-2024 02:17:24 UTC] WordPress database error Unknown column ‘desktop’ in ‘field list’ for query INSERT INTO `wp_adrotate` (`title`, `bannercode`, ` thetime`, `updated`, `author`, `imagetype`, `image`, `tracker`, `show_everyone`,` desktop`, `mobile`, `tablet`, `os_ios`, `os_android`, `type`, `weight`, `autodelete`,` budget`, `crate`, `irate`, `state_req`, `cities`, `states`, `countries`) VALUES(”,”,‘ 1727119044’, ‘1727119044’, ‘hello@navaweb.com’, ‘dropdown’, ”, ‘N’, ‘Y’, ‘Y’,‘ Y’, ‘Y’, ‘Y’, ‘Y’, ’empty’, ‘6’, ‘N’, ‘0’, ‘0’, ‘0’, ‘N’, ‘a:0:{}’, ‘a:0:{}’,‘ a:0:{}’) made by do_action(‘toplevel_page_adrotate’), WP_Hook->do_action, WP_Hook- >apply_filters, adrotate_manage, include(‘/plugins/adrotate/dashboard/publisher/ adverts-edit.php’) [24-Sep-2024 02:17:24 UTC] WordPress database error Unknown column ‘daystarttime’ in ‘field list’ for query INSERT INTO `wp_adrotate_schedule`(` name`, `starttime`, `stoptime`, `maxclicks`, `maximpressions`, `spread`, `spread_all`,` daystarttime`, `daystoptime`, `day_mon`, `day_tue`, `day_wed`, `day_thu`, `day_fri`,` day_sat`, `day_sun`, `autodelete`) VALUES (‘Schedule for ad 0’, ‘1727119044’,‘ 1734376644’, ‘0’, ‘0’, ‘N’, ‘N’, ‘0000’, ‘0000’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’,‘ Y’, ‘N’) made by do_action(‘toplevel_page_adrotate’), WP_Hook->do_action, WP_Hook- >apply_filters, adrotate_manage, include(‘/plugins/adrotate/dashboard/publisher/ adverts-edit.php’) [24-Sep-2024 02:46:14 UTC] WordPress database error Unknown column ‘desktop’ in ‘field list’ for query INSERT INTO `wp_adrotate` (`title`,` bannercode`, `thetime`, `updated`, `author`, `imagetype`, `image`, `tracker`,` show_everyone`, `desktop`, `mobile`, `tablet`, `os_ios`, `os_android`, `type`,` weight`, `autodelete`, `budget`, `crate`, `irate`, `state_req`, `cities`, `states`,` countries`) VALUES (”, ”, ‘1727120774’, ‘1727120774’, ‘hello@navaweb.com’, ‘dropdown’,”,‘ N’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ’empty’, ‘6’, ‘N’, ‘0’, ‘0’, ‘0’, ‘N’, ‘a:0:{}’,‘ a:0:{}’, ‘a:0:{}’) made by do_action(‘toplevel_page_adrotate’), WP_Hook->do_action, WP_Hook->apply_filters, adrotate_manage, include(‘/plugins/adrotate-banner-manager- 5.13/dashboard/publisher/adverts-edit.php’) [24-Sep-2024 02:46:14 UTC] WordPress database error Unknown column ‘daystarttime’ in ‘field list’ for query INSERT INTO `wp_adrotate_schedule` (`name`, `starttime`, `stoptime`, `maxclicks`, `maximpressions`,` spread`, `spread_all`, `daystarttime`, `daystoptime`, `day_mon`, `day_tue`, ` day_wed`, `day_thu`, `day_fri`, `day_sat`, `day_sun`, `autodelete`) VALUES (‘ Schedule for ad 0’, ‘1727120774’, ‘1734378374’, ‘0’, ‘0’, ‘N’, ‘N’, ‘0000’, ‘ 0000’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘N’) made by do_action(‘toplevel_page_adrotate’), WP_Hook->do_action, WP_Hook->apply_filters, adrotate_manage, include(‘/plugins/ adrotate-banner-manager-5.13/dashboard/publisher/adverts-edit.php’) [24-Sep-2024 02:46:34 UTC] PHP Warning: file_get_contents(/home/yossili1/public_html/wp-content/ plugins/adrotate-banner-manager-5.13/adrotate.php): failed to open stream: No such file or directory in /home/yossili1/public_html/wp-includes/functions.php on line 6808 [24-Sep-2024 02:46:35 UTC] PHP Warning: file_get_contents(/home/ yossili1/public_html/wp-content/plugins/adrotate-banner-manager-5.13/adrotate. php): failed to open stream: No such file or directory in /home/yossili1/public_html/ wp-includes/functions.php on line 6808 [24-Sep-2024 02:47:58 UTC] WordPress database error Unknown column ‘desktop’ in ‘field list’ for query INSERT INTO `wp_adrotate`(` title`, `bannercode`, `thetime`, `updated`, `author`, `imagetype`, `image`, ` tracker`, `show_everyone`, `desktop`, `mobile`, `tablet`, `os_ios`, `os_android`,` type`, `weight`, `autodelete`, `budget`, `crate`, `irate`, `state_req`, `cities`,` states`, `countries`) VALUES (”, ”, ‘1727120878’, ‘1727120878’, ‘hello@navaweb. com’, ‘dropdown’, ”, ‘N’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ’empty’, ‘6’, ‘N’, ‘0’,‘ 0’, ‘0’, ‘N’, ‘a:0:{}’, ‘a:0:{}’, ‘a:0:{}’) made by do_action(‘toplevel_page_adrotate’), WP_Hook->do_action, WP_Hook->apply_filters, adrotate_manage, include(‘/plugins/ adrotate/dashboard/publisher/adverts-edit.php’) [24-Sep-2024 02:47:58 UTC] WordPress database error Unknown column ‘daystarttime’ in ‘field list’ for query INSERT INTO `wp_adrotate_schedule` (`name`, `starttime`, `stoptime`, `maxclicks`, `maximpressions`,` spread`, `spread_all`, `daystarttime`, `daystoptime`, `day_mon`, `day_tue`, ` day_wed`, `day_thu`, `day_fri`, `day_sat`, `day_sun`, `autodelete`) VALUES (‘ Schedule for ad 0’, ‘1727120878’, ‘1734378478’, ‘0’, ‘0’, ‘N’, ‘N’, ‘0000’, ‘ 0000’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘N’) made by do_action(‘toplevel_page_adrotate’), WP_Hook->do_action, WP_Hook->apply_filters, adrotate_manage, include(‘/plugins/ adrotate/dashboard/publisher/adverts-edit.php’) [24-Sep-2024 03:18:21 UTC] WordPress database error Unknown column ‘desktop’ in ‘field list’ for query INSERT INTO` wp_adrotate` (`title`, `bannercode`, `thetime`, `updated`, `author`, `imagetype`,` image`, `tracker`, `show_everyone`, `desktop`, `mobile`, `tablet`, `os_ios`, ` os_android`, `type`, `weight`, `autodelete`, `budget`, `crate`, `irate`, `state_req`,` cities`, `states`, `countries`) VALUES (”, ”, ‘1727122701’, ‘1727122701’, ‘Yossilinks. com’, ‘dropdown’, ”, ‘N’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ’empty’, ‘6’, ‘N’, ‘0’,‘ 0’, ‘0’, ‘N’, ‘a:0:{}’, ‘a:0:{}’, ‘a:0:{}’) made by do_action(‘toplevel_page_adrotate’), WP_Hook->do_action, WP_Hook->apply_filters, adrotate_manage, include(‘/plugins/ adrotate/dashboard/publisher/adverts-edit.php’) [24-Sep-2024 03:18:21 UTC] WordPress database error Unknown column ‘daystarttime’ in ‘field list’ for query INSERT INTO `wp_adrotate_schedule` (`name`, `starttime`, `stoptime`, `maxclicks`, `maximpressions`,` spread`, `spread_all`, `daystarttime`, `daystoptime`, `day_mon`, `day_tue`, ` day_wed`, `day_thu`, `day_fri`, `day_sat`, `day_sun`, `autodelete`) VALUES (‘ Schedule for ad 0’, ‘1727122701’, ‘1734380301’, ‘0’, ‘0’, ‘N’, ‘N’, ‘0000’, ‘ 0000’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘N’) made by do_action(‘toplevel_page_adrotate’), WP_Hook->do_action, WP_Hook->apply_filters, adrotate_manage, include(‘/plugins/ adrotate/dashboard/publisher/adverts-edit.php’) [24-Sep-2024 03:55:26 UTC] WordPress database error Unknown column ‘desktop’ in ‘field list’ for query INSERT INTO` wp_adrotate` (`title`, `bannercode`, `thetime`, `updated`, `author`, `imagetype`,` image`, `tracker`, `show_everyone`, `desktop`, `mobile`, `tablet`, `os_ios`, ` os_android`, `type`, `weight`, `autodelete`, `budget`, `crate`, `irate`, `state_req`,` cities`, `states`, `countries`) VALUES (”, ”, ‘1727124926’, ‘1727124926’, ‘hello@navaweb. com’, ‘dropdown’, ”, ‘N’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ’empty’, ‘6’, ‘N’, ‘0’,‘ 0’, ‘0’, ‘N’, ‘a:0:{}’, ‘a:0:{}’, ‘a:0:{}’) made by do_action(‘toplevel_page_adrotate’), WP_Hook->do_action, WP_Hook->apply_filters, adrotate_manage, include(‘/plugins/ adrotate/dashboard/publisher/adverts-edit.php’) [24-Sep-2024 03:55:26 UTC] WordPress database error Unknown column ‘daystarttime’ in ‘field list’ for query INSERT INTO `wp_adrotate_schedule` (`name`, `starttime`, `stoptime`, `maxclicks`, `maximpressions`,` spread`, `spread_all`, `daystarttime`, `daystoptime`, `day_mon`, `day_tue`, ` day_wed`, `day_thu`, `day_fri`, `day_sat`, `day_sun`, `autodelete`) VALUES (‘ Schedule for ad 0’, ‘1727124926’, ‘1734382526’, ‘0’, ‘0’, ‘N’, ‘N’, ‘0000’, ‘ 0000’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘N’) made by do_action(‘toplevel_page_adrotate’), WP_Hook->do_action, WP_Hook->apply_filters, adrotate_manage, include(‘/plugins/ adrotate/dashboard/publisher/adverts-edit.php’) * Thanks! * Elyssa - This topic was modified 1 year, 8 months ago by [navaweb](https://wordpress.org/support/users/navaweb/). Viewing 6 replies - 1 through 6 (of 6 total) * Plugin Author [Arnan](https://wordpress.org/support/users/adegans/) * (@adegans) * [1 year, 8 months ago](https://wordpress.org/support/topic/problem-adding-new-advert/#post-18032586) * Nothing has changed in the database recently, certainly nothing related to those fields missing. I don’t know how you re-installed the plugin but a proper re- install would have created new tables including those fields. * Did you update from a very old version recently? Or did you roll back (parts) of the database to an earlier version? Perhaps restored a backup? * Thread Starter [navaweb](https://wordpress.org/support/users/navaweb/) * (@navaweb) * [1 year, 8 months ago](https://wordpress.org/support/topic/problem-adding-new-advert/#post-18032660) * by proper re-install, you mean deactivate and delete the plugin, then install it? won’t that delete all settings, groups, adverts etc? I can’t do that… I am not sure what happened, but I did try to install an older version (i have a plugin that allows me to install and overwrite plugins called easy theme and plugin updates)….that didn’t work. I also disabled and installed the latest version overtop.. didn’t work. So how can I fix this without deleting and re-installing? Thanks! * Thread Starter [navaweb](https://wordpress.org/support/users/navaweb/) * (@navaweb) * [1 year, 8 months ago](https://wordpress.org/support/topic/problem-adding-new-advert/#post-18032754) * I went ahead and installed a fresh copy of the plugin and checked the Structure of all AdRotate database tables in comparison with the database of the website that had issues.. probably about 15 columns were missing throughout… I added each missing one, one by one… now I’ll check if things work…fingers crossed! * Plugin Author [Arnan](https://wordpress.org/support/users/adegans/) * (@adegans) * [1 year, 8 months ago](https://wordpress.org/support/topic/problem-adding-new-advert/#post-18033917) * > I am not sure what happened, but I did try to install an older version * That’s probably what did in the database. Don’t mess with plugins like that, it’ll only cause issues. * You can indeed add the columns yourself and see if that works. If not, you’re probably better off reinstalling the plugin so that AdRotate can create a new database and settings. This will delete all AdRotate data though. Time consuming to re-do all ads and stuff but it’s a sure fix. * Thread Starter [navaweb](https://wordpress.org/support/users/navaweb/) * (@navaweb) * [1 year, 8 months ago](https://wordpress.org/support/topic/problem-adding-new-advert/#post-18037256) * no, that’s not why this happened… the database was already missing 15 or so tables, so whatever caused this to happen, happened way before I installed an older version… I installed the older version in hopes that it would ADD the missing tables … that didn’t work.. so then I reinstalled the current version thinking that it would add the missing tables – which it did not either 🙂 In any case, I manually added the tables and we’ve added new adverts, so far so good! * Plugin Author [Arnan](https://wordpress.org/support/users/adegans/) * (@adegans) * [1 year, 8 months ago](https://wordpress.org/support/topic/problem-adding-new-advert/#post-18037682) * Okie – Let me know if you run into further trouble. Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Problem Adding New Advert’ 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/) * 6 replies * 2 participants * Last reply from: [Arnan](https://wordpress.org/support/users/adegans/) * Last activity: [1 year, 8 months ago](https://wordpress.org/support/topic/problem-adding-new-advert/#post-18037682) * Status: resolved