There are no upcoming events. Bug.

  • Resolved thatstevensguy

    (@thatstevensguy)


    10 years, 7 months ago

    Today the Agenda views (widget and on the calendar) have started to say ‘There are no upcoming events.’ – I have checked the database for the instances of the repeated events that SHOULD be displaying and they are certainly there.

    Adding a new event about an hour ahead does not show either.

    I have a custom script for a horizontal ticker that loads in event posts a little differently, and that works just fine, showing the events that should be shown.

    Has anyone experienced this bug? How do I fix it… I have even tried updating to the latest version without success.

    http://wordpress.org/plugins/all-in-one-event-calendar/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter thatstevensguy

    (@thatstevensguy)

    10 years, 7 months ago

    Upon further investigation, it seems to be related to this bit of code. As it effects posterboard, agenda and agenda widget, but not the others.

    $ai1ec_calendar_helper->get_events_relative_to();

    Which in class-ai1ec-calendar-helper.php has quite a large SQL query…

    Thread Starter thatstevensguy

    (@thatstevensguy)

    10 years, 7 months ago

    Ok, so after putting wordpress into debug mode, via the config. I found out that it was an internal server error with SQL, server support fixed it over the weekend.

    WordPress database error : [Incorrect key file for table '/tmp/#sql_a46_0.MYI'; try to repair it]
SELECT SQL_CALC_FOUND_ROWS p.*, e.post_id, i.id AS instance_id, UNIX_TIMESTAMP( i.start ) AS start, UNIX_TIMESTAMP( i.end ) AS end, IF( e.allday, e.allday, i.end = DATE_ADD( i.start, INTERVAL 1 DAY ) ) AS allday, e.recurrence_rules, e.exception_rules, e.recurrence_dates, e.exception_dates, e.venue, e.country, e.address, e.city, e.province, e.postal_code, e.show_map, e.contact_name, e.contact_phone, e.contact_email, e.cost, e.ical_feed_url, e.ical_source_url, e.ical_organizer, e.ical_contact, e.ical_uid FROM wp_ai1ec_events e INNER JOIN wp_posts p ON e.post_id = p.ID INNER JOIN wp_ai1ec_event_instances i ON e.post_id = i.post_id WHERE post_type = 'ai1ec_event' AND i.end >= FROM_UNIXTIME( 1378459320 ) AND ( post_status = 'publish' OR post_status = 'private' ) ORDER BY i.start ASC, post_title ASC LIMIT 0, 10
    Thread Starter thatstevensguy

    (@thatstevensguy)

    10 years, 7 months ago

    Bug resolved.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘There are no upcoming events. Bug.’ is closed to new replies.