SpyCamCentral

@lancemonotone thanks for providing the code, it helped me get started on fixing this. Had an older version of Adrotate on multiple sites and updating to new version caused same database errors as you had.

Running the plugin’s updater manually in Adrotate’s Settings->Maintenance to upgrade database didn’t add all missing fields and I still had to add some manually.

Anyway, here’s SQL code to add missing tables in case anyone else has similar issues in the future:

ALTER TABLE wp_dbprefix_adrotate_schedule
ADD COLUMN daystarttime CHAR(4) NOT NULL DEFAULT '0000' AFTER spread_all,
ADD COLUMN daystoptime CHAR(4) NOT NULL DEFAULT '0000' AFTER daystarttime,
ADD COLUMN day_mon CHAR(1) NOT NULL DEFAULT 'Y' AFTER daystoptime,
ADD COLUMN day_tue CHAR(1) NOT NULL DEFAULT 'Y' AFTER day_mon,
ADD COLUMN day_wed CHAR(1) NOT NULL DEFAULT 'Y' AFTER day_tue,
ADD COLUMN day_thu CHAR(1) NOT NULL DEFAULT 'Y' AFTER day_wed,
ADD COLUMN day_fri CHAR(1) NOT NULL DEFAULT 'Y' AFTER day_thu,
ADD COLUMN day_sat CHAR(1) NOT NULL DEFAULT 'Y' AFTER day_fri,
ADD COLUMN day_sun CHAR(1) NOT NULL DEFAULT 'Y' AFTER day_sat,
ADD COLUMN autodelete CHAR(1) NOT NULL DEFAULT 'N' AFTER day_sun;

ALTER TABLE wp_dbprefix_adrotate
ADD COLUMN desktop CHAR(1) NOT NULL DEFAULT 'Y' AFTER show_everyone,
ADD COLUMN tablet CHAR(1) NOT NULL DEFAULT 'Y' AFTER mobile,
ADD COLUMN os_ios CHAR(1) NOT NULL DEFAULT 'Y' AFTER tablet,
ADD COLUMN os_android CHAR(1) NOT NULL DEFAULT 'Y' AFTER os_ios,
ADD COLUMN os_other CHAR(1) NOT NULL DEFAULT 'Y' AFTER os_android;

Don’t forget to change “dbprefix” to your database prefix!