Posted: March 2, 2015 at 1:29 pm
|
|
Hello, Our site is consistently dropping the connection to most event espresso related items on the site. The site itself will load, but when trying to view an event from the front end or backend, the page will not load. The response from Chrome is “No data received,” Firefox says “Description: Server Hangup,” and Safari says “the server unexpectedly dropped the connection.” Here is an example: http://www.thewarrengroupevents.com/blog/events/banking-ny-conference-2015/. This is only for event espresso items on the site, and all other aspects are loading fine. Can you please offer any insight into this? Thank you! |
|
Hi John, What kind of hosting are you using and which hosting company are you using? |
|
|
|
Hello, We are using Rackspace Cloud shared hosting. |
|
Hi, I’m having trouble reaching those pages as well. It appears to be loading for an extended period of time when I try to reach the single event page or the event listing page. Could you temporarily enable WordPress debugging and let us know if anything appears in the debug.log that is related to Event Espresso? https://gist.github.com/lorenzocaum/848801a1173be464fbe7 /wp-content/debug.log Also, if you have recently added any new plugins, then I would also try briefly testing with only Event Espresso running. — |
|
|
|
Hello, Thank you for your response! Below, please find the contents of the debug.log: [02-Mar-2015 21:57:26 UTC] PHP Notice: Undefined index: promo in /mnt/stor7-wc2-dfw1/531663/661851/www.thewarrengroupevents.com/web/content/wp-content/plugins/event-espresso-core-reg/modules/ticket_selector/templates/ticket_selector_chart.template.php on line 14 |
|
Hi, thanks for posting. I’m not seeing any errors there. Do you see the same issue when only Event Espresso 4 is running? Also, is this the latest release of Event Espresso 4? — |
|
|
|
Hello, I tried deactivating all other plugins, and it does not seem to make a difference. We are using Event Espresso 4.4.4p. I put all expired events into the trash folder, and am now able to view an event in Chrome, but it is going very slow and still timing out in Safari. Do you have any suggestions on optimizing the speed and size of the data so that it can make it through the browser? Thank you. |
|
Hi, the single event page still doesn’t load and I’m using Safari. Is there something preventing you from upgrading to the latest software? https://eventespresso.com/wiki/ee4-changelog/ Also, when did you first discover this slow loading for the pages? — |
|
|
|
Hello, We are hesitant to upgrade to the latest software at the moment because we have some customizations that need to be reconnected upon update, and the last update we performed the regular event pages got distorted. Is there anything in the latest update that may help speed and site load performance that we would want to try out? We first noticed this on Monday. We had Rackspace run tests and they were able to narrow in on the issue being that the queries being run in the Event Espresso pages were timing out. Here is the example of the query they ran: SELECT Registration.REG_ID AS ‘Registration.REG_ID’, Registration.EVT_ID AS ‘Registration.EVT_ID’, Registration.ATT_ID AS ‘Registration.ATT_ID’, Registration.TXN_ID AS ‘Registration.TXN_ID’, Registration.TKT_ID AS ‘Registration.TKT_ID’, Registration.STS_ID AS ‘Registration.STS_ID’, Registration.REG_date AS ‘Registration.REG_date’, Registration.REG_final_price AS ‘Registration.REG_final_price’, Registration.REG_session AS ‘Registration.REG_session’, Registration.REG_code AS ‘Registration.REG_code’, Registration.REG_url_link AS ‘Registration.REG_url_link’, Registration.REG_count AS ‘Registration.REG_count’, Registration.REG_group_size AS ‘Registration.REG_group_size’, Registration.REG_att_is_going AS ‘Registration.REG_att_is_going’, Registration.REG_deleted AS ‘Registration.REG_deleted’, Event_CPT.ID AS ‘Event_CPT.ID’, Event_CPT.post_title AS ‘Event_CPT.post_title’, Event_CPT.post_content AS ‘Event_CPT.post_content’, Event_CPT.post_name AS ‘Event_CPT.post_name’, Event_CPT.post_date AS ‘Event_CPT.post_date’, Event_CPT.post_excerpt AS ‘Event_CPT.post_excerpt’, Event_CPT.post_modified AS ‘Event_CPT.post_modified’, Event_CPT.post_author AS ‘Event_CPT.post_author’, Event_CPT.post_parent AS ‘Event_CPT.post_parent’, Event_CPT.menu_order AS ‘Event_CPT.menu_order’, Event_CPT.post_status AS ‘Event_CPT.post_status’, Event_Meta.EVT_display_desc AS ‘Event_Meta.EVT_display_desc’, Event_Meta.EVT_display_ticket_selector AS ‘Event_Meta.EVT_display_ticket_selector’, Event_Meta.EVT_visible_on AS ‘Event_Meta.EVT_visible_on’, Event_Meta.EVT_additional_limit AS ‘Event_Meta.EVT_additional_limit’, Event_Meta.EVT_default_registration_status AS ‘Event_Meta.EVT_default_registration_status’, Event_Meta.EVT_member_only AS ‘Event_Meta.EVT_member_only’, Event_Meta.EVT_phone AS ‘Event_Meta.EVT_phone’, Event_Meta.EVT_allow_overflow AS ‘Event_Meta.EVT_allow_overflow’, Event_Meta.EVT_timezone_string AS ‘Event_Meta.EVT_timezone_string’, Event_Meta.EVT_external_URL AS ‘Event_Meta.EVT_external_URL’, Event_Meta.EVT_donations AS ‘Event_Meta.EVT_donations’, Event_CPT.ID AS ‘Event_CPT.ID’, Event_Meta.EVTM_ID AS ‘Event_Meta.EVTM_ID’, Attendee_CPT.ID AS ‘Attendee_CPT.ID’, Attendee_CPT.post_title AS ‘Attendee_CPT.post_title’, Attendee_CPT.post_content AS ‘Attendee_CPT.post_content’, Attendee_CPT.post_name AS ‘Attendee_CPT.post_name’, Attendee_CPT.post_date AS ‘Attendee_CPT.post_date’, Attendee_CPT.post_excerpt AS ‘Attendee_CPT.post_excerpt’, Attendee_CPT.post_modified AS ‘Attendee_CPT.post_modified’, Attendee_CPT.post_author AS ‘Attendee_CPT.post_author’, Attendee_CPT.post_status AS ‘Attendee_CPT.post_status’, Attendee_Meta.ATT_fname AS ‘Attendee_Meta.ATT_fname’, Attendee_Meta.ATT_lname AS ‘Attendee_Meta.ATT_lname’, Attendee_Meta.ATT_address AS ‘Attendee_Meta.ATT_address’, Attendee_Meta.ATT_address2 AS ‘Attendee_Meta.ATT_address2’, Attendee_Meta.ATT_city AS ‘Attendee_Meta.ATT_city’, Attendee_Meta.STA_ID AS ‘Attendee_Meta.STA_ID’, Attendee_Meta.CNT_ISO AS ‘Attendee_Meta.CNT_ISO’, Attendee_Meta.ATT_zip AS ‘Attendee_Meta.ATT_zip’, Attendee_Meta.ATT_email AS ‘Attendee_Meta.ATT_email’, Attendee_Meta.ATT_phone AS ‘Attendee_Meta.ATT_phone’, Attendee_CPT.ID AS ‘Attendee_CPT.ID’, Attendee_Meta.ATTM_ID AS ‘Attendee_Meta.ATTM_ID’, Ticket.TKT_ID AS ‘Ticket.TKT_ID’, Ticket.TTM_ID AS ‘Ticket.TTM_ID’, Ticket.TKT_name AS ‘Ticket.TKT_name’, Ticket.TKT_description AS ‘Ticket.TKT_description’, Ticket.TKT_start_date AS ‘Ticket.TKT_start_date’, Ticket.TKT_end_date AS ‘Ticket.TKT_end_date’, Ticket.TKT_min AS ‘Ticket.TKT_min’, Ticket.TKT_max AS ‘Ticket.TKT_max’, Ticket.TKT_price AS ‘Ticket.TKT_price’, Ticket.TKT_sold AS ‘Ticket.TKT_sold’, Ticket.TKT_qty AS ‘Ticket.TKT_qty’, Ticket.TKT_uses AS ‘Ticket.TKT_uses’, Ticket.TKT_required AS ‘Ticket.TKT_required’, Ticket.TKT_taxable AS ‘Ticket.TKT_taxable’, Ticket.TKT_is_default AS ‘Ticket.TKT_is_default’, Ticket.TKT_order AS ‘Ticket.TKT_order’, Ticket.TKT_row AS ‘Ticket.TKT_row’, Ticket.TKT_deleted AS ‘Ticket.TKT_deleted’, Ticket.TKT_parent AS ‘Ticket.TKT_parent’ FROM gv_esp_registration AS Registration LEFT JOIN gv_posts AS Event_CPT ON Event_CPT.ID=Registration.EVT_ID LEFT JOIN gv_esp_event_meta AS Event_Meta ON Event_CPT.ID = Event_Meta.EVT_ID LEFT JOIN gv_posts AS Attendee_CPT ON Attendee_CPT.ID=Registration.ATT_ID LEFT JOIN gv_esp_attendee_meta AS Attendee_Meta ON Attendee_CPT.ID = Attendee_Meta.ATT_ID LEFT JOIN gv_esp_ticket AS Ticket ON Ticket.TKT_ID=Registration.TKT_ID WHERE Registration.REG_deleted = 0 AND (Event_CPT.post_title LIKE ‘%Barna%’ OR Event_CPT.post_content LIKE ‘%Barna%’ OR Event_CPT.post_excerpt LIKE ‘%Barna%’ OR Attendee_Meta.ATT_fname LIKE ‘%Barna%’ OR Attendee_Meta.ATT_lname LIKE ‘%Barna%’ OR Attendee_CPT.post_excerpt LIKE ‘%Barna%’ OR Attendee_Meta.ATT_email LIKE ‘%Barna%’ OR Attendee_Meta.ATT_address LIKE ‘%Barna%’ OR Attendee_Meta.ATT_address2 LIKE ‘%Barna%’ OR Attendee_Meta.ATT_city LIKE ‘%Barna%’ OR Registration.REG_final_price LIKE ‘%Barna%’ OR Registration.REG_code LIKE ‘%Barna%’ OR Registration.REG_count LIKE ‘%Barna%’ OR Registration.REG_group_size LIKE ‘%Barna%’ OR Ticket.TKT_name LIKE ‘%Barna%’ OR Ticket.TKT_description LIKE ‘%Barna%’) ORDER BY Registration.REG_date DESC LIMIT 0,10; We have over a thousand registrations in the database, and are investigating deleting the older ones out in order to clear up some space. Obviously, it is not ideal to delete out data, so any suggestions you have to optimize page load will be greatly appreciated. Thank you! |
|
|
Hello, We are all set now – thank you! |
|
Hi, I see that you are running EE 4.4.4 could you share how you solved this issue? Thanks — |
|
The support post ‘Dropped Connection’ is closed to new replies.
Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.
