Related to this problem is this, which is in our logs when visiting the calendar:
WordPress database error Unknown column ‘wp_postmeta.meta_value’ in ‘field list’ for query SELECT DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate 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 = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’ OR wp_posts.post_status = ‘private’) ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
THE SOLUTION is to change this:
MIN(wp_postmeta.meta_value)
To this:
MIN(tribe_event_end_date.meta_value)
Thread Starter
flgirl
(@flgirl)
Where do I find that information?
How do you solved this problem? I’ve the same trouble.
Same issue! No calendar view – list view works though.
Thread Starter
flgirl
(@flgirl)
Hey Digital office…how do I edit these “Logs?” Why isn’t Modern Tribe helping me with my PAID plug-in here.
HEY FLGIRL – did you try updating the plugin?
Thread Starter
flgirl
(@flgirl)
Yes, plugins all updated!
Thread Starter
flgirl
(@flgirl)
Hey works! Tried on my main computer…caching issues now it’s working well.
calendar/month view works on desktop after upgrading to the 4.5.13 but is still broken on mobile.
-
This reply was modified 8 years, 9 months ago by
spcaer.
I really need help with this same issue. I can’t see how this was resolved. If it has to do with updating the logs per Digital Office comment, above, can someone tell me where to find those logs? Thank you!
i was able to get mobile working again, without console errors, by uploading a previous version of the following file:
tribe-events-ajax-calendar.min.js
to this location:
/wp-content/plugins/the-events-calendar/src/resources/js
once i did that and cleared my cache, the mobile calendar works again.
that file can be pulled from archived versions of the plugin here:
https://wordpress.org/plugins/the-events-calendar/advanced/
I grabbed it from version 4.3.5; no real reason why i chose that version, i just went back far enough to rule out any newly developed issues. hopefully this helps others.
-
This reply was modified 8 years, 8 months ago by spcaer.
It’s still not working for me… I’ve updated the plugin.
How do you access that log?
that looks like it was pulled from the server error logs. if so, you wouldn’t need to update those logs, but instead, update the plugin code that is causing that error. i’ve searched the latest plugin (4.5.13) for the text @digitaloffice referenced above and it no longer exists, but i was able to find the solution mentioned above here:
/wp-content/plugins/the-events-calendar/src/Tribe/Query.php
so basically, if you are running 4.5.13, that code should already be corrected. sorry i can’t be of more help, hopefully @moderntribe will respond to help you with this.
-
This reply was modified 8 years, 8 months ago by spcaer.
Looks like 4.5.13 fixed this issue for me.
Hmmm…I’m stumped. I have version 4.5.13. I updated to that version and that’s when all hell broke loose. Unless Modern Tribe can help me, I will have to find another plugin that works for me. Thanks for all your help everyone.
