Error on crerating sheduled on create new ads

[Angel Salvador]

Hi, i cannot create new schedules from create new ads form. I have no error entries into error_log file, this was after upgrade plugin version.

I create the ad an is ok, but the related shedule has error and not created. The ad show config error. On sheduled list, the shedule for the ad ID is not present (not created).

I tried update db version button from adrotate -> maintenance. I have adrotate v401 and db v68

Im using:
php v7.4
wordpress v5.9.3
adrotate plugin v5.8.19

Please can you help me to solve this error and get back on track?

[M.W.]

Hi, I cannot create schedules anymore. The only error is:

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 at ajdg.solutions/forums/forum/adrotate-for-wordpress/

Of course, loading the page via the menu on the left generates the same error.

[Arnan de Gans]

Usually that indicates a database issue.
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.

[M.W.]

Okay, will try to find the error. Having a pretty hard time digging through the error log.
There are almost 3 million lines in the log file. It contains hundreds of thousands of warning lines from AdRotate.

PHP Warning: Undefined property: stdClass::$spread_all in /home/liveweb/domains/domain.nl/public_html/wp-content/plugins/adrotate-pro/adrotate-functions.php on line 209

[M.W.]

It’s a little more than ‘hundreds of thousands’.
To be exact this warning appears 1.9 million times. (1.939.826).
And that’s only for April 2022.

[M.W.]

I finished searching after removing the PHP Warning above. Then there are no AdRotate entries left in the log file.

[Arnan de Gans]

If you’ve just updated make sure you have finished the update properly.
There probably is a big banner in the dashboard prompting you to finish it.

If not, go to settings > maintenance, near the bottom you’ll find the database version (probably in red) and a button to update the database from there.

[M.W.]

Indeed, that was it. The problem is fixed now. Thank you…

[Chris]

Hello, I have the same issue, updated database, issue still there, cannot ad new. What to do? Thanks, Chris.

[Chris]

I mean new advert, of course.

[Arnan de Gans]

Check the error_log file as suggested above.

[Chris]

I beg your pardon, I do not know how to do it..:( How do I check the error log and what to search?

[Arnan de Gans]

The error_log is usually a simple text file. Found in your hosting dashboard.
Normally there is a dashboard page in there that can open/show the file or the last bit of it.
Ask your hosting provider for the specific location or to send the log to you if you can’t find it.

As for what to look for, there will be errors in that file, anything that goes wrong with websites and databases that can make errors goes in there.
Anything to do with AdRotate will mention AdRotate 😉 You’ll know it when you see it.

[RCEditor]

I just updated the plugin and have the same issues. Date fields will not allow me to update and setup a new advert. The only I found in my log, and I ran all the updates in the maintenance section.

2022/04/25 14:19:19 [error] 36790#36790: *2097432 FastCGI sent in stderr: “PHP message: WordPress database error Unknown column ‘spread_all’ 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 16’, ‘1650871159’, ‘1658128759’, ‘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’)” while reading response header from upstream, client: 67.1.104.195, server: http://www.racecenter.com, request: “GET /wp-admin/admin.php?page=adrotate&view=addnew HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php7.4-fpm-racecenter.sock:”, host: “www.racecenter.com:65054”, referrer: “https://www.racecenter.com/wp-admin/admin.php?page=adrotate”

[Arnan de Gans]

@rceditor, what does it say for the versionnumbers in settings > maintenance? Are there numbers in red there?

[RCEditor]

Nothing in red. Version 399. DB version 68.

[Arnan de Gans]

Hmm that’s odd. Please contact me through the contact form for further assistance. Since the update seems to have failed a manual edit to the database is required to get things back on track. Please refer to this topic when you do.

[Jennifer]

Having the exact same problem. Everything is up to date (Verson 401, DB 68).

[Angel Salvador]

Hi, i have the same problem in 2 websites. I cannot create new schedules from create new ads form. I have no error entries into error_log file, this was after upgrade plugin version.

I tried update db version button from adrotate -> maintenance. I have adrotate v401 and db v68

Im using:
php v7.4
wordpress v5.9.3
adrotate plugin v5.8.19

Please can you help me to solve this error and get back on track?

[Arnan de Gans]

A fix is being tested and should be ready soon.

If you have AdRotate Pro you can create the schedule from Manage Schedules and select the advert from there too.
Or set up the required schedules and select them when editing the advert.