Bug: long query that dies using calendar widget

[dwenaus]

I’m using the calendar widget on my home page (I also have the communiy plugin installed).
This query times out mysql when I’l logged in.
http://pastie.org/9155969
I believe the offending part is “GROUP BY IF( wp_posts.post_parent = 0, wp_posts.ID, wp_posts.post_parent )”

[Barry]

Hi – I’m sorry you’re facing difficulties here.

Can you give me an idea of how many events are currently set up and what proportion might be recurring?

[dwenaus]

interestingly, even trying to load the events list in the admin, caused the site to time out!

here was the error:
[Fri May 09 00:13:06 2014] [error] [client 190.239.65.5] LONG QUERY (1051 characters long generated in :): SELECT comment_post_ID, COUNT(comment_ID) as num_comments FROM wp_comments WHERE comment_post_ID IN ( ‘12244’, ‘12245’, ‘12246’, ‘12247’, ‘12248’, ‘12249’, ‘12250’, ‘12251’, ‘12252’, ‘12253’, ‘12254’, ‘12255’, ‘12256’, ‘12257’, ‘12258’, ‘12259’, ‘12260’, ‘12261’, ‘12262’, ‘12263’, ‘12264’, ‘12265’, ‘12266’, ‘12267’, ‘12268’, ‘12269’, ‘12270’, ‘12271’, ‘12272’, ‘12273’, ‘12274’, ‘12275’, ‘12276’, ‘12190’, ‘12191’, ‘12192’, ‘12193’, ‘12194’, ‘12195’, ‘12196’, ‘12197’, ‘12198’, ‘12199’, ‘12200’, ‘12201’, ‘12202’, ‘12203’, ‘12204’, ‘12205’, ‘12206’, ‘12207’, ‘12208’, ‘12209’, ‘12210’, ‘12211’, ‘12212’, ‘12213’, ‘12214’, ‘12215’, ‘12216’, ‘12217’, ‘12218’, ‘12187’, ‘12185’, ‘12184’, ‘12183’, ‘12181’, ‘12179’, ‘12178’, ‘12177’, ‘12163’, ‘12162’, ‘12133’, ‘12120’, ‘12118’, ‘12111’, ‘12109’, ‘12105’, ‘12104’, ‘12102’, ‘11173’, ‘11171’, ‘11169’, ‘11167’, ‘11165’, ‘11163’, ‘10343’, ‘10338’, ‘10026’, ‘10024’, ‘10022’, ‘10018’, ‘10017’, ‘10015’, ‘10013’, ‘10011’, ‘10010’, ‘9206’, ‘9205’, ‘9203’ ) AND comment_approved = ‘0’ GROUP BY comment_post_ID

[Barry]

Hmm, ok. Do you have an approximate idea of how many events you might have and can you tell me who your hosting provider is?

One other thing I am curious about ixs did you recently update your plugins from an older version – and if so have you looked at this announcement? It’s not impossible that things are going slowly due to a number of duplicates that were generated during the update process … if that sounds like a possibility to you then making use of the cleanup plugin linked to in that post might be worth a shot.

[Barry]

Hi! It’s been a while so I’m going to go ahead and close this thread. If we can help with anything else, though, please don’t hesitate to create new threads as needed. Thanks!

[Author]

Posts