Hello,<\/p>\n
I reached out my hosting provider (WpEngine) first. I can’t access the backend of the website. I know I simply need to delete items, but I keep getting time-out errors, so I can’t get to the event section to delete them. Here is the note from WpEngine support:<\/p>\n
Alexander, Aug 06 11:39 AM:
\nHi Anthony,<\/p>\n
I’ve taken a look at the issue and here is what I found:<\/p>\n
I went to this page:<\/p>\n
http:\/\/boilercatholics.org\/wp-admin\/edit.php?post_type=tribe_events<\/p>\n
It didn’t error out but it took a long time to load.<\/p>\n
I then checked the apache error log and found this created at the time when I visited the page:<\/p>\n
[Wed Aug 06 16:13:45 2014] [error] [client 198.58.119.71] [WPE Monitoring] Slow mysql_query() call was running query:\\nSELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, eventStart.meta_value as EventStartDate, eventEnd.meta_value as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as eventStart ON ( wp_posts.ID = eventStart.post_id AND eventStart.meta_key = ‘_EventStartDate’ ) LEFT JOIN wp_postmeta as eventEnd ON ( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = ‘_EventEndDate’ ) 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 = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’) ORDER BY eventStart.meta_value DESC, eventEnd.meta_value DESC LIMIT 0, 20 \/* From [boilercatholics.org\/wp-admin\/edit.php?post_type=tribe_events] in [N\/A] *\/
\nI also checked the SQL slow query log – these are queries that took too long to complete and were shut down, and found several instances related to the events page. Here is an example:<\/p>\n
# Thread_id: 19159341 Schema: wp_boilercatholic Last_errno: 0 Killed: 0
\n# Query_time: 3.375891 Lock_time: 0.000201 Rows_sent: 20 Rows_examined: 270269 Rows_affected: 0 Rows_read: 270269
\n# Bytes_sent: 8383
\nuse wp_boilercatholic;
\nSET timestamp=1407335259;
\nSELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, eventStart.meta_value as EventStartDate, eventEnd.meta_value as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as eventStart ON ( wp_posts.ID = eventStart.post_id AND eventStart.meta_key = ‘_EventStartDate’ ) LEFT JOIN wp_postmeta as eventEnd ON ( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = ‘_EventEndDate’ ) 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 = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’) ORDER BY eventStart.meta_value DESC, eventEnd.meta_value DESC LIMIT 0, 20 \/* From [boilercatholics.org\/wp-admin\/edit.php?post_type=tribe_events] in [N\/A] *\/;
\n# Time: 140806 14:30:42
\n# User@Host: boilercatholic[boilercatholic] @ localhost [127.0.0.1]
\n# Thread_id: 19159710 Schema: wp_boilercatholic Last_errno: 0 Killed: 0
\n# Query_time: 2.201473 Lock_time: 0.000201 Rows_sent: 5 Rows_examined: 134761 Rows_affected: 0 Rows_read: 134761
\n# Bytes_sent: 3627
\nSET timestamp=1407335442;
\nThis query tried to examine 134761 and exceeded the timeout threshold. This is the reason for why you were seeing the 504 gateway timeout errors.<\/p>\n
I see that Ethan Kennedy pointed this out in the chat when you originally started the ticket. Basically any activity that outputs information will require a query to database. Since database can be large, if the query is too broad then it could search through much more of the database than it really needs. Because of this, the query can exceed the timeout and generate 504 error.<\/p>\n
The solution to this is to make the queries more efficient so that they don’t exceed the timeout threshold.<\/p>\n
I see that you’re using The Events Calendar PRO plugin. Since it’s a premium plugin the developer should be able to assist you in making these queries more efficient. Sometimes it’s a matter of adjusting the plugin settings.<\/p>\n
Here is the link the plugin developer’s support page:<\/p>\n
https:\/\/theeventscalendar.com\/support\/?utm_medium=plugin-ecp<\/p>\n
If they require any additional information from us, we would be happy to provide that information.<\/p>\n
Hope that helps. Let us know if you have any questions. I can also give you a call if that might be easier for you.<\/p>\n
Regards,<\/p>\n","protected":false},"template":"","class_list":["post-597680","topic","type-topic","status-closed","hentry"],"yoast_head":"\n