@adegans Further to this post: https://projectdmc.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’, ‘[email protected]’, ‘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
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 INTOwp_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’, ‘[email protected]’, ‘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’, ‘[email protected]’, ‘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’, ‘[email protected]’, ‘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’, ‘[email protected]’, ‘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
