Forum Replies Created
-
Posts
-
ok guys .. now i changed again the theme to default theme (twenty twelve) and now the site works well with your plugins .. now i’m absolutely confused and can’t understand the whole thing …
Activated Gameplan Theme (http://themeforest.net/item/gameplan-event-and-gym-fitness-wordpress-theme/5936266) and activated TRIBE-plugins => Site crashes
The same setup with only 44 Events => no problemActivated DEFAULT THEME (twenty twelve) and activated Tribe Plugins and over 255 Events => no problem …
so please tell me whats going wrong here … i can’t understand
it’s not occuring at the test-system (tribe.woodlandevents.eu), its on the live-System (woodlandevents.eu) … at the moment we can’t open the site with the plugin (http://www.woodlandevents.eu/eventsmap/) ..
Now i deactivated the widget tagcloud with event-categories .. but nothing helps … I’m absolutely frustrated at the moment … yesterday i deactivated all plugins – but no chances ..
i can try to set up the same website again .. but we have the same site on a test-server (woodland.jb-webdev.de/woodland/ (44 Events)) and everything ist fine .. i told you that …here is a example-link to the detailview of EventCalendar …
http://www.woodlandevents.eu/event/gsf-sued-saisonabschluss-weihnachtsgame/
all Detail-Links are not working …
we tried everything … we have the problem now for over a week .. we have another Post / Discussion (https://tri.be/support/forums/topic/enormous-perfomance-problems/#post-793511)we are sure thats a problem with the plugin … when i deactivate the plugin, we have the same problem … the site works only when we restart the sql-service
we installed now the debug-bar … please take a look and try to solve the problem .. we can’t find no information in the server-error-logs …
it’s always the same SQL Query / proceess which crashes the site :Kernel: 2.6.32-431.29.2.el6.x86_64 #1 SMP
OS: Centos 6.5
MySQL 5.1.73-log
Status: Copying to tmp table
SQL: SHOW FULL PROCESSLIST
SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) INNER JOIN wp_term_relationships AS tt3 ON (wp_posts.ID = tt3.object_id) INNER JOIN wp_term_relationships AS tt4 ON (wp_posts.ID = tt4.object_id) INNER JOIN wp_term_relationships AS tt5 ON (wp_posts.ID = tt5.object_id) INNER JOIN wp_term_relationships AS tt6 ON (wp_posts.ID = tt6.object_id) INNER JOIN wp_term_relationships AS tt7 ON (wp_posts.ID = tt7.object_id) INNER JOIN wp_term_relationships AS tt8 ON (wp_posts.ID = tt8.object_id) INNER JOIN wp_term_relationships AS tt9 ON (wp_posts.ID = tt9.object_id) INNER JOIN wp_term_relationships AS tt10 ON (wp_posts.ID = tt10.object_id) INNER JOIN wp_term_relationships AS tt11 ON (wp_posts.ID = tt11.object_id) INNER JOIN wp_term_relationships AS tt12 ON (wp_posts.ID = tt12.object_id) INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) 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_term_relationships.term_taxonomy_id IN (147) OR tt1.term_taxonomy_id IN (148) OR tt2.term_taxonomy_id IN (146) OR tt3.term_taxonomy_id IN (132) OR tt4.term_taxonomy_id IN (143) OR tt5.term_taxonomy_id IN (142) OR tt6.term_taxonomy_id IN (134) OR tt7.term_taxonomy_id IN (133) OR tt8.term_taxonomy_id IN (131) OR tt9.term_taxonomy_id IN (141) OR tt10.term_taxonomy_id IN (145) OR tt11.term_taxonomy_id IN (144) OR tt12.term_taxonomy_id IN (149) ) AND wp_posts.post_type = ‘tribe_events’ AND ((wp_posts.post_status = ‘publish’)) AND (wp_postmeta.meta_key = ‘_EventStartDate’ ) AND (wp_postmeta.meta_value >= ‘2014-10-07 00:00:00’ OR (wp_postmeta.meta_value <= ‘2014-10-07 00:00:00’ AND tribe_event_end_date.meta_value >= ‘2014-10-07 00:00:00’ )) GROUP BY wp_posts.ID ORDER BY DATE(MIN(wp_postmeta.meta_value)) ASC, TIME(wp_postmeta.meta_value) ASC LIMIT 0, 6The Login Data for the project i sent as PM
now our website is not working anymore .. is not reachable and get Internal Server Error
yesterday the website was working well and after 12 Hours we got a internalServerErrorit happens on this page (http://blank.woodlandevents.eu/eventsmap/) ..
only frontend …
it happens on this page (http://blank.woodlandevents.eu/eventsmap/) ..
we have to try the new update 3.8 …
my developer wrote to me:” It seems that whenever we create a new category (here in that case it’s 148, 134, etc.) that it’s creating another JOIN in the SQL statement, therefore it seems that the the whole table is included there for every categorie (here: 10 times). Correct would be a statement like “… term_taxonomy_id IN (148, 143, …)” instead of all those JOINs
If I correct this statement and insert it directly into e.g. phpMyAdmin it runs smoothly without problems
: For me it seems that the problem is here:”
we are absolutely sure that there’s no conflict.hi …
we tried u update, there were no changes .. same problem ..
we have a maneged root server … on this server we have only installed 3 Projects .. i will send u the detailed server specification later .. but i’m sure that’s not a server problem.
Our developer told me, that’s a problem with the categories … the most strange thing is, when the plugin is activated, that the normal blog is not working anymore
