Database error on admin event search
-
I’m getting an error when I search events in the admin:
WordPress database error: [Not unique table/alias: 'tca_postmeta'] SELECT SQL_CALC_FOUND_ROWS DISTINCT tca_posts.ID FROM tca_posts INNER JOIN tca_postmeta ON ( tca_posts.ID = tca_postmeta.post_id ) LEFT JOIN tca_postmeta ON tca_posts.ID = tca_postmeta.post_id LEFT JOIN tca_postmeta as tribe_event_end_date ON ( tca_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' ) LEFT JOIN tca_postmeta AS tribe_event_start_date ON tca_posts.ID = tribe_event_start_date.post_id AND tribe_event_start_date.meta_key = '_EventStartDate' WHERE 1=1 AND ( ( tca_postmeta.meta_key = '_EventEndDate' AND CAST(tca_postmeta.meta_value AS DATETIME) > '2020-03-19 11:16:00' ) ) AND tca_posts.post_type = 'tribe_events' AND ((tca_posts.post_status = 'tribe-ignored')) GROUP BY tca_posts.ID ORDER BY tribe_event_start_date.meta_value DESC, tribe_event_end_date.meta_value DESC, tca_posts.post_date DESC LIMIT 0, 10
Any idea what may be causing this?
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Database error on admin event search’ is closed to new replies.