Support » Plugin: AdRotate Banner Manager » This ad has no schedules!

  • Resolved GoBieN


    Since the update my ads stopped working and all of them are displayed in yellow. And start and stop time are 1 january 1970 and displayed in red.

    If I open the ad I see 2 schedules listed but can’t do anything with them (need pro) and can’t add or activate a schedule.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Arnan de Gans


    Sounds like you didn’t set up a start and end date for your ad.

    In the section right above the schedule list, I adjust the dates and click save but still it remains the same.

    In the schedule list I have the 2 schedules which I can’t adjust.

    It seems I’m stuck.

    Plugin Author Arnan de Gans


    That’s odd.

    Does the date you set get saved? Or is it empty again if you edit the ad?
    Also, if you create a new ad, is there a date filled in? Or are the fields empty?

    After saving the ad and opening it again, the dates are back at 1970.
    The 2 schedules in the list remain.
    Same thing when creating a new ad, because that’s what I tried before posting here. I deleted them all and started over.

    Here is a video:

    Plugin Author Arnan de Gans



    If you add a new ad, does that start out with the right dates?
    If not, go to AdRotate Settings and click “Clean up database” somewhere 2/3rd down the page. THen try again and see if the dates are correct.

    New ads show 1970 as start and end date.
    Clean-up empty records in DB did not help, the other 2 buttons (optimize and reevaluate) did nothing either. Editing the ad again and setting yesterday as start and +3 years as end and saved. Ad still has 1970 on it.

    Really don’t know what to do next …

    Plugin Author Arnan de Gans


    Seems like something is wrong with your database. Can you check your servers error_log for errors mentioning AdRotate?

    Found the error.
    It seems that all tables for adrotate are MyISAM tables, but the adrotate_schedule table was innoDB. I had disabled innoDB for performance reasons. Re-enabled innoDB now.

    Thanks for your support.

    Plugin Author Arnan de Gans


    Ah, that would be it 🙂

    InnoDB is faster for a bunch of things, you may want to consider to use it for the tracker and stats table as they generally get quite large.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘This ad has no schedules!’ is closed to new replies.