Title: Database error on admin event search
Last modified: March 19, 2020

---

# Database error on admin event search

 *  Resolved [insidethepark](https://wordpress.org/support/users/insidethepark/)
 * (@insidethepark)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/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)

 *  Plugin Support [Deblyn Prado](https://wordpress.org/support/users/deblynprado/)
 * (@deblynprado)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/database-error-on-admin-event-search/#post-12619512)
 * Hi [@insidethepark](https://wordpress.org/support/users/insidethepark/)!
    Are
   you still having this issue?
 * Would you mind to run our Testing for Conflicts tutorial and let me know the 
   results please?
 * [https://theeventscalendar.com/knowledgebase/k/testing-for-conflicts/](https://theeventscalendar.com/knowledgebase/k/testing-for-conflicts/)
 * Be safe!
    Cheers,

Viewing 1 replies (of 1 total)

The topic ‘Database error on admin event search’ is closed to new replies.

 * ![](https://ps.w.org/the-events-calendar/assets/icon-256x256.gif?rev=2516440)
 * [The Events Calendar](https://wordpress.org/plugins/the-events-calendar/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/the-events-calendar/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/the-events-calendar/)
 * [Active Topics](https://wordpress.org/support/plugin/the-events-calendar/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/the-events-calendar/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/the-events-calendar/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Deblyn Prado](https://wordpress.org/support/users/deblynprado/)
 * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/database-error-on-admin-event-search/#post-12619512)
 * Status: resolved