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

  • Resolved GoBieN

    (@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.

    http://wordpress.org/plugins/adrotate/

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

    (@adegans)

    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

    (@adegans)

    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

    (@adegans)

    Strange…

    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

    (@adegans)

    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

    (@adegans)

    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.