I was asked to start a new thread with this information instead of including it in the thread it was originally posted in. I was told I could copy\/paste it into this one. I’m actually not sure if this issue is occurring in code for TEC, TEC-Pro, or EA but here is the information:<\/p>\n
I am adding this information I have just received my hosting company as well. I\u2019m not sure what category this new information fits into, but I have been having a lot of performance issues with my site that I thought had to do with hosting. They have spent the last week working with me and while I authorized upgrading plans by two levels, during the process of working on that request they stopped and sent this email information because of a problem that has to do with TEC. I\u2019m copying and pasting from their email here (in entirety)<\/p>\n
Hello, I ran a check on the calendar using Query Monitor. It\u2019s flagging a broken query from the plugin. The query is: SELECT DISTINCT 859_posts.*, MIN(859_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM 859_posts LEFT JOIN 859_postmeta as tribe_event_end_date ON ( 859_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = \u2018_EventEndDate\u2019 ) WHERE 1=1 AND 859_posts.post_type = \u2018tribe_events\u2019 AND (859_posts.post_status = \u2018publish\u2019 OR 859_posts.post_status = \u2018tribe-ea-success\u2019 OR 859_posts.post_status = \u2018tribe-ea-failed\u2019 OR 859_posts.post_status = \u2018tribe-ea-schedule\u2019 OR 859_posts.post_status = \u2018tribe-ea-pending\u2019 OR 859_posts.post_status = \u2018tribe-ea-draft\u2019 OR 859_posts.post_status = \u2018private\u2019) ORDER BY EventStartDate DESC, 859_posts.post_date DESC LIMIT 0, 1 The complaint from the query is: Unknown column \u2018859_postmeta.meta_value\u2019 in \u2018field list\u2019 I believe the problem is because the table name is being joined in as a different name, so instead of \u201c859_postmeta.meta_value\u201d it should be \u201ctribe_event_end_date.meta_value\u201d. This isn\u2019t something you can fix. It\u2019s a problem in the plugin code itself. It could also affect the performance of the page because MySQL has take the time to check and then fail that query. There are two other factors that are affecting performance, one more so than the other. The first is the number of events. The more events, the more data that has to be queried. This is causing for a few slow queries on the page. A recommendation I found on the Modern Tribe forum was to upgrade the hosting account. The person answering assumed the account was on shared hosting, which yours is. In your case, you\u2019re on a plan that has a low number of resources. However, I\u2019m not completely convinced that the hosting plan is the problem in your case. To be sure, I\u2019ve temporarily switched you to the next plan up that provides a higher allotment of various system resources. I\u2019m going to leave it like this for a few days so you can run your site and see if you\u2019re still having problems. From my perspective, the page loads in anywhere from 7-13 seconds, which would be slow for any other page but in your case you have 3400 queries running to make up the data on the calendar page. For the issue with the plugin, I suggest contacting Modern Tribe so they can check into the query and get that corrected. I suspect that it\u2019s affecting everyone who uses the plugin but it may not have been reported yet. I\u2019m going to leave your ticket on hold for now so I can check back in a day or two.<\/p>\n
Clearly, this needs to be addressed immediately and not be waiting for a maintenance release down the road. If it is affecting other sites like it is affecting me, it is bad news!!<\/p>\n
In the previous thread I was asked what screen this was occurring on. I can’t answer that question since it was the hosting company that found this while trying to fix issues they thought were related to hosting. I would assume you are capable of running the same tests they mention above and finding the same information since they’ve given the full details.<\/p>\n","protected":false},"template":"","class_list":["post-1266308","topic","type-topic","status-closed","hentry"],"yoast_head":"\n