WordPress database error

[Daniel Maier]

When using the filter bar as soon as you filter anything by day of week the following error appears at the top of the screen:

WordPress database error: [Unknown column 'wp_postmeta.meta_value' in 'where clause']
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' ) WHERE 1=1 AND wp_posts.post_type = 'tribe_events' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private') AND ((DAYOFWEEK(wp_postmeta.meta_value) IN (1)) OR (DATEDIFF(tribe_event_end_date.meta_value, wp_postmeta.meta_value) >=6) OR (DATE(DATE_ADD(wp_postmeta.meta_value, INTERVAL MOD( 7 + 1 - DAYOFWEEK(wp_postmeta.meta_value), 7 ) DAY)) < tribe_event_end_date.meta_value)) ORDER BY wp_posts.post_date DESC LIMIT 0, 1

Please advise. Thanks.

[Hunter]

Daniel,

Thanks for choosing Events Calendar Pro! We hope you’re having a geat holiday season. I just tested the calendar on the site associated with your account and didn’t run into the issue you described. I was able to filter events by day. Have you tried to see if the issue occurs when you’re both logged in and logged out? If you have a caching plugin, that could also cause issues with the Filter Bar if not set up properly.

Let me know what you find and if the issue is still occurring so we can further investigate. Thanks again for choosing PRO and have a wonderful rest of the holidays!

[Daniel Maier]

Hi Hunter, thanks for looking into this.

To see the error you need to have WP_DEBUG set to true:

define('WP_DEBUG', true);

Also after filtering by day of week you have to refresh the page.

i.e., http://domain.com/events-calendar/?tribe_dayofweek%5B%5D=1 (REFRESH THIS, or simply load it directly)

If you provide me your IP I can give you access to view my dev site where I have WP_DEBUG set to true and you are able to see it in action.

Thanks!

[Hunter]

Daniel,

Thanks for getting back to me. I’m unfortunately unable to acquire credentials, so please refrain from sending those over. I turned on debug on my test dev environment and am not seeing the issues you’re describing. Have you tried reverting back reverting back to the default WP theme and deactivating your plugins? Start there and let me know how it goes.

[Daniel Maier]

Yes I have tried that and the issue still persists.

[Daniel Maier]

This reply is private.

[Daniel Maier]

This reply is private.

[Daniel Maier]

This reply is private.

[Hunter]

Daniel,

I hope you had a wonderful New Years Day! We have seen a similar issue in a previous version of Filter Bar. Can you provide the exact version number of The Events Calendar, Events Calendar Pro, and Filter Bar you are currently using?

[Daniel Maier]

Hi Hunter,

I had a great time. I hope you did as well.

– WordPress version 4.4
– The Events Calendar version 4.0.4
– The Events Calendar PRO version 4.0.3
– The Events Calendar: Filter Bar version 4.0.2

Thank you!

[Hunter]

I had a wonderful holiday, thanks for the wishes!

So I’m still unable to recreate the problem you’re experiencing. I apologize for not asking for this sooner, but would you mind sharing your system information as a private reply? This will give us much more information to work with and help narrow down the issue faster (hopefully!)

To share your system information, please read this this quick article on how to do so. Let me know if you have any questions about the process. Thanks again and I look forward to hearing back!

[Daniel Maier]

This reply is private.

[Hunter]

Daniel,

Thanks for your patience while I’ve done some more testing and research. Everything looks good on your system information, however I do want to point out that with as many plugins as you’re using, the likeliness of a conflict is fairly high.

I would recommend running through our “Testing for conflicts” article one more time just to make sure you’ve exhausted the possibility of an error on your side.

With that being said, I’ve logged your issue into our system as a “bug” – though we’re unable to recreate the issue at this time. Our lead developers work through bugs and do more extensive testing than the support team, so keep your eye on this thread and if/when we discover your issue to be an official bug, we’ll be sure and leave an update here.

Thanks again for working so patiently through this issue! If you experience any new issues, please feel free to open a new thread. Have a great weekend!

[Daniel Maier]

This reply is private.

[Daniel Maier]

This reply is private.

[Author]

Posts