No Events Found

  • Resolved a_hongjie

    (@a_hongjie)


    3 years, 8 months ago

    In 5.9 EM version the mata key is _event_start_date and _event_end_date.
    In 5.8 version the mata key is _start_ts and _end_ts.

    From 5.8 to 5.9, all of the old events can’t be found from dashboard because the meta key is changed, would you please help me to check?

    SELECT SQL_CALC_FOUND_ROWS
    wp_62_posts.ID
    FROM
    wp_62_posts
    INNER JOIN wp_62_postmeta ON (
    wp_62_posts.ID = wp_62_postmeta.post_id
    )
    INNER JOIN wp_62_postmeta AS mt1 ON (wp_62_posts.ID = mt1.post_id)
    WHERE
    1 = 1
    AND (
    wp_62_postmeta.meta_key = ‘_start_ts’
    AND (
    (
    mt1.meta_key = ‘_end_ts’
    AND mt1.meta_value >= ‘1615852800’
    )
    )
    )
    AND wp_62_posts.post_type = ‘event’
    AND (
    wp_62_posts.post_status = ‘publish’
    OR wp_62_posts.post_status = ‘acf-disabled’
    OR wp_62_posts.post_status = ‘future’
    OR wp_62_posts.post_status = ‘draft’
    OR wp_62_posts.post_status = ‘pending’
    OR wp_62_posts.post_status = ‘private’
    )
    GROUP BY
    wp_62_posts.ID
    ORDER BY
    wp_62_postmeta.meta_value + 0 ASC
    LIMIT 0,
    20`

    Thanks

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support angelo_nwl

    (@angelo_nwl)

    Hi, I’m going to let the Devs know about this.

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    Hello, when updating there should have been a migration of data.

    Try Events > Settings > General > Admin Tools > Reset Timezones

    Thread Starter a_hongjie

    (@a_hongjie)

    Thanks you! When I was trying to reset time zone: but I met the below error:

    There was an error whilst migrating your times to our new timezone-aware formats. Below is a list of errors:

    Event start/end UTC offset: Unknown column ‘event_end’ in ‘where clause’
    Event timezone setting: Unknown column ‘event_timezone’ in ‘where clause’

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    Sorry for the delayed reply.

    I am guessing that something went wrong upgrading your database during the update, which also explains why you have this problem in the first place.

    What you could try is to trigger an update again by visiting wp-admin/wp-options.php and then finding dbem_version, modifying it to 1 digit lower than what you have there.

    If that doesn’t help, you may need to check your PHP error logs for database errors. The issue is likely permissions related, e.g. your database user isn’t able to update tables.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘No Events Found’ is closed to new replies.