Dates Stuck on 1970

Those are issues from over 2 years ago, both got fixed then too.

Make sure you have assigned a schedule to each advert.

We do. I’d selected a start and end date but it after hitting save, it never changed.

Hmm, if dates don’t update then there may be somethinng wrong with the database.

Please check your servers error_log file for errors.
The error_log file can usually be found in your hosting dashboard.
Anything mentioning AdRotate is interesting.

I have an video of what I’m seeing, along with the logs. Can I send these to you to check out? I obviously don’t want to post them here but if I could email them to you, it may help. We’ve used the plugin for years and want to stick with it!

You can post the logs here, there is no private information in it so that should be fine/safe.

Thank you, Arnan!

This should include the logs and video demo, etc. of what we’re seeing: https://bit.ly/2wPFhct

What version of AdRotate are you using?
And if you updated recently, did you try clearing the browser cache yet?

The settings screen says “Current: 395” and the WordPress plugin says Version 5.7

Tried in a totally separate browser (Firefox vs Chrome), so no cache, incognito window, etc. and same issue.

Try updating to version 5.7.1. A number of things related to updates have been improved.

I’m actually having this exact same issue. I’ve been using this plugin for years. I had a really old version of the pro plugin that wasn’t updating. I got all kinds of errors upgrading straight to the latest pro version. So I installed the free version and slowly ran through each upgrade so that the database could upgrade like it would had it been upgrading normally.

Now I have the latest free plugin that won’t save a proper date schedule. If I enable the latest pro plugin, all my ads disappear on my website, even after setting up the new widgets. It acts like everything has a configuration error even though nothing is apparent on my end. I’m guessing my only option now is paying you to get in here and see what’s going one? I checked my logs and I don’t see any errors ad rotate related.

@coopman that’s not at all the same issue.
Updating from versions older than 4.0 is no longer supported. Hasn’t been for years.

If you still had an older version you can do the incremental update trick as you did. But it’s possible that because you already updated to 5.8 before the database is not updated properly.

If you know you way around MySQL/PhpMyAdmin you can update the database manually (match up the columns and indexes) from the installation script in adrotate-setup.php.
Or I can do it for you for a fee – https://ajdg.solutions/product/adrotate-update/

You can ignore this. I just deleted the database tables and am starting fresh. That seems to have taken care of it.

@adegans Yeah, my issue was probably because I tried upgrading originally to 5.8 and screwed something up in the database. So the incremental trick wasn’t working anymore. It’s all good. I’ll just start fresh and get the latest pro version on here. It’s not too much work. Thanks!

Finally caught it in the logs!

This is the error:

WordPress database error Unknown column ‘daystarttime’ in ‘field list’ for query INSERT INTO wp_adrotate_schedule (name, starttime, stoptime, maxclicks, maximpressions, spread, daystarttime, daystoptime, day_mon, day_tue, day_wed, day_thu, day_fri, day_sat, day_sun, autodelete) VALUES (‘Schedule for ad 51’, ‘1587739250’, ‘1594996850’, ‘0’, ‘0’, ‘N’, ‘0000’, ‘0000’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘N’) /* From [visitwv.com/wp-admin/admin.php?page=adrotate-ads&view=addnew] in [/nas/content/live/visitwv/wp-content/plugins/adrotate/dashboard/publisher/adverts-edit.php:18] */ made by do_action(‘adrotate_page_adrotate-ads’), WP_Hook->do_action, WP_Hook->apply_filters, adrotate_manage, include(‘/plugins/adrotate/dashboard/publisher/adverts-edit.php’), referer: https://visitwv.com/wp-admin/admin.php?page=adrotate-ads

Tried the SQL statement you mentioned here to no avail, but the 1 year renewal worked: https://ajdg.solutions/forums/topic/configuration-error-help/