Error on crerating sheduled on create new ads

Home Forums AdRotate for WordPress Bug Reports Error on crerating sheduled on create new ads

  • #153924

    Angel Salvador
    Badges:

    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?

    #153165

    M.W.
    Badges:

    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.

    #153171

    Arnan de Gans
    Badges:

    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.

    #153177

    M.W.
    Badges:

    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

    #153178

    M.W.
    Badges:

    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.

    #153183

    M.W.
    Badges:

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

    #153194

    Arnan de Gans
    Badges:

    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.

    #153198

    M.W.
    Badges:

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

    #153423

    Chris
    Badges:

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

    #153425

    Chris
    Badges:

    I mean new advert, of course.

    #153427

    Arnan de Gans
    Badges:

    Check the error_log file as suggested above.

    #153429

    Chris
    Badges:

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

    #153529

    Arnan de Gans
    Badges:

    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.

    #153895

    RCEditor
    Badges:

    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”

    #153907

    Arnan de Gans
    Badges:

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

    #153909

    RCEditor
    Badges:

    Nothing in red. Version 399. DB version 68.

    #153911

    Arnan de Gans
    Badges:

    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.

    #153919

    Jennifer
    Badges:

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

    #153922

    Angel Salvador
    Badges:

    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?

    #153927

    Arnan de Gans
    Badges:

    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.

Viewing 20 posts - 1 through 20 (of 27 total)

The topic ‘Error on crerating sheduled on create new ads’ is closed to new replies.

You may be interested in