Error when indexing with SOLR

[Christopher Muldrow]

I’m getting the following error when trying to index my site with SOLR using Pantheon’s Solr Search for WordPress plugin:

WordPress database error Unknown column ‘EventStartDate’ in ‘order clause’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta as wp_postmeta on wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘project’, ‘product’, ‘tribe_venue’, ‘tribe_events’, ‘tribe-ea-record’) AND ((wp_posts.post_status = ‘publish’)) ORDER BY wp_posts.ID ASC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
LIMIT 100, 100
made by do_action(‘wp_ajax_solr_options’), WP_Hook->do_action, WP_Hook->apply_filters, SolrPower_Options->options_load, SolrPower_Batch_Index->fetch_next_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

It’s similar to some errors other have reported. I can confirm that turning off Pro (and leaving regular Events Calendar on) makes the error go away.

[Barry]

Sorry to hear that, Christopher.

Just to help me identify if this is indeed a known bug or not, can you confirm where or when you see this issue?

Is it on specific occasions such as frontend requests for month view, for example, or more general than that?

Thanks!

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts