New install on wpengine and Killed Query

[sculawdm]

Hello,
Facing same issues as I found here from 2014.

On wpengine and my Calendar view will not produce consistent month views. Admin sees the months progress with events as pressing the next month, but non logged in viewers.

I tried, define( ‘WPE_GOVERNOR’, false );

I’m uptodate on all plugins (Event calendar related), WP Core etc..

Any ideas what to do?

KILLED QUERY (22298 characters long generated in /nas/content/live/santaclaralaw/wp-content/plugins/role-scoper/comments-interceptor_rs.php:92): SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID LEFT JOIN wp_posts as parent ON parent.ID = wp_posts.post_parent AND parent.post_type IN (‘post’,’page’,’bibliography’,’staff’,’news’,’faculty’,’organizations’,’courses’,’scheduled_classes’,’tribe_venue’,’tribe_organizer’,’tribe_events’,’tribe-ea-record’,’portfolio’) AND wp_posts.post_type = ‘attachment’ WHERE ( ( comment_approved = ‘0’ OR comment_approved = ‘1’ ) ) AND comment_type NOT IN (‘tribe-ea-error’) AND ( ( wp_posts.post_type = ‘post’ AND 1=2 ) OR ( wp_posts.post_type = ‘attachment’ AND parent.post_type = ‘post’ AND 1=2 ) OR ( wp_posts.post_type = ‘page’ AND ( ( wp_posts.post_status IN (‘future’, ‘draft’, ‘pending’, ‘private’, ‘tribe-ea-success’, ‘tribe-ea-failed’, ‘tribe-ea-schedule’, ‘tribe-ea-pending’, ‘tribe-ea-draft’, ‘tribe-ignored’, ‘publish’) AND ( ( ( ( ( ( ( wp_posts.ID IN ( ‘486433’,’486434′,’486537′,’486538′,’486568′,’486569′,’486787′,’487302′,’487303′,’487305′,’487306′,’487307′,’487308′,’487309′,’487310′,’487311′,’487312′,’487313′,’487314′,’487315′,’487316′,’487317′,’487318′,’487319′,’487320′,’487321′,’487322′,’487323′,’487324′,’487325′,’487326′,’487327′,’487328′,’487329′,’487330′,’487331′,’487332′,’487333′,’487334′,’487335′,’487336′,’487337′,’487338′,’487339′,’487340′,’487341′,’487342′,’487343′,’487344′,’487345′,’487346′,’487347′,’487348′,’487349′,’487350′,’487351′,’487352′,’487353′,’487354′,’487355′,’487356′,’487357′,’487358′,’487359′,’487360′,’487361′,’487362′,’487363′,’487364′,’487365′,’487366′,’487367′,’487368′,’487369′,’487370′,’487371′,’487372′,’487373′,’487374′,’487375′,’487376′,’487377′,’487378′,’487379′,’487380′,’487381′,’487382′,’487383′,’487384′,’487385′,’487386′,’487387′,’487388′,’487389′,’487390′,’487391′,’487392′,’487393′,’487394′,’487396′,’487397′,’487398′,’487453′,’487483′,’487484′,’487485′,’487486′,’487488′,’487489′,’487491′,’487492′,’487493′,’487495′,’487496′,’487497′,’487498′,’487500′,’487501′,’487503′,’487504′,’487506′,’487507′,’487508′,’487509′,’487510′,’487511′,’487513′,’487514′,’487516′,’487517′,’487518′,’487519′,’487520′,’487521′,’487522′,’487524′,’487623′,’487624′,’487626′,’487638′,’487640′,’487662′,’487663′,’487664′,’487665′,’487666′,’487667′,’487669′,’487671′,’487672′,’487722′,’487723′,’487724′,’487725′,’487726′,’487727′,’487728′,’487729′,’487730′,’487733′,’487734′,’487735′,’487736′,’487737′,’487738′,’487739′,’487740′,’487742′,’487743′,’487744′,’487764′,’487765′,’487840′,’487841′,’487847′,’487848′,’487849′,’487854′,’487856′,’487857′,’487858′,’487859′,’487860′,’487862′,’487863′,’487864′,’487865′,’487934′,’487935′,’487936′,’487937′,’487938′,’487939′,’487940′,’487941′,’487942′,’487943′,’487944′,’487945′,’487946′,’487947′,’487948′,’487949′,’487950′,’487951′,’487952′,’487953′,’487954′,’487955′,’487956′,’487957′,’487958′,’487959′,’487960′,’487961′,’487962′,’487963′,’487964′,’487965′,’487966′,’487967′,’487968′,’487969′,’487970′,’487971′,’487972′,’487973′,’487974′,’487975′,’487976′,’487977′,’487978′,’487979′,’487980′,’487981′,’487982′,’487983′,’487984′,’487985′,’487986′,’487987′,’487988′,’487989′,’487990′,’487991′,’487992′,’487993′,’487994′,’487995′,’487996′,’487997′,’487998′,’487999′,’488000′,’488001′,’488002′,’488003′,’488004′,’488005′,’488006′,’488007′,’488008′,’488009′,’488010′,’488011′,’488012′,’488013′,’488014′,’488015′,’488016′,’488017′,’488018′,’488019′,’488020′,’488021′,’488022′,’488023′,’488024′,’488025′,’488026′,’488027′,’488028′,’488029′,’488030′,’488031′,’488032′,’488033′,’488034′,’488035′,’488036′,’488037′,’488038′,’488039′,’488040′,’488041′,’488042′,’488043′,’488044′,’488045′,’488046′,’488047′,’488048′,’488049′,’488050′,’488051′,’488052′,’488053′,’488054′,’488055′,’488056′,’488057′,’488058′,’488059′,’488060′,’488061′,’488062′,’488063′,’488064′,’488065′,’488066′,’488067′,’488068′,’488069′,’488070′,’488071′,’488072′,’488073′,’488074′,’488075′,’488076′,’488077′,’488078′,’488079′,’488080′,’488081′,’488082′,’488083′,’488084′,’488085′,’488086′,’488087′,’488088′,’488089′,’488090′,’488091′,’488092′,’488093′,’488094′,’488095′,’488096′,’488097′,’488098′,’488099′,’488100′,’488101′,’488102′,’488103′,’488104′,’488105′,’488106′,’488107′,’488108′,’488109′,’488110′,’488111′,’488112′,’488113′,’488114′,’488115′,’488116′,’488117′,’488118′,’488119′,’488120′,’488121′,’488122′,’488123′,’488124′,’488125′,’488126′,’488127′,’488128′,’488129′,’488130′,’488131′,’488132′,’488133′,’488134′,’488135′,’488136′,’488137′,’488138′,’488139′,’488140′,’488141′,’488142′,’488143′,’488144′,’488145′,’488146′,’488147′,’488148′,’488149′,’488150′,’488151′,’488152′,’488153′,’488154′,’488155′,’488156′,’488157′,’488158′,’488159′,’488160′,’488161′,’488162′,’488163′,’488164′,’488165′,’488166′,’488167′,’488168′,’488169′,’488170′,’488171′,’488172′,’488173′,’488174′,’488175′,’488176′,’488177′,’488178′,’488179′,’488180′,’488181′,’488182′,’488183′,’488184′,’488185′,’488186′,’488187′,’488188′,’488189′,’488190′,’488191′,’488192′,’488193′,’488194′,’488195′,’488196′,’488197′,’488198′,’488199′,’488200′,’488201′,’488202′,’488203′,’488204′,’488205′,’488206′,’488207′,’488208′,’488209′,’488210′,’488712′,’488713′,’488974′,’489234′,’489235′,’489303′,’489304′,’489305′,’489306′,’489307′,’489312′,’489313′,’489314′,’489315′,’489316′,’489317′,’489318′,’489319′,’489320′,’489323′,’489326′,’489329′,’489332′,’489335′,’489338′,’489341′,’489344′,’489349′,’489860′,’489862′,’489863′,’489864′,’489865′,’489866′,’489867′,’489868′,’489869′,’489870′,’489871′,’489872′,’489873′,’489874′,’489875′,’489876′,’489877′,’489878′,’489879′,’489880′,’489881′,’489882′,’489883′,’489884′,’489885′,’489886′,’489887′,’489888′,’489889′,’489890′,’489891′,’489892′,’489893′,’489894′,’489895′,’489896′,’489897′,’489898′,’489899′,’489900′,’489901′,’489902′,’489903′,’489904′,’489905′,’489906′,’489907′,’489908′,’489909′,’489910′,’489911′,’489912′,’489913′,’489914′,’489915′,’489916′,’489917′,’489918′,’489919′,’489920′,’489921′,’489922′,’489923′,’489924′,’489925′,’489926′,’489927′,’489928′,’489929′,’489930′,’489931′,’489932′,’489933′,’489934′,’489935′,’489936′,’489937′,’489938′,’489939′,’489940′,’489941′,’489942′,’489943′,’489944′,’489945′,’489946′,’489947′,’489948′,’489949′,’489950′,’489951′,’489952′,’489953′,’489954′,’489955′,’489956′,’489957′,’489958′,’489959′,’489960′,’489961′,’489962′,’489963′,’489964′,’489965′,’489966′,’489967′,’489968′,’489969′,’489970′,’489971′,’489972′,’489973′,’489974′,’489975′,’489976′,’489977′,’489978′,’489979′,’489980′,’489981′,’489982′,’489983′,’489984′,’489985′,’489986′,’489987′,’489988′,’489989′,’489990′,’489991′,’489992′,’489993′,’489994′,’489995′,’490004′,’490081′,’490082′,’490083′,’490084′,’490085′,’490086′,’490089′,’490092′,’490095′,’490098′,’490670′,’490673′,’490676′,’490679′,’490682′,’490684′,’490685′,’490686′,’490687′,’490688′,’490689′,’490950′,’490951′,’491092′,’491130′,’491131′,’491143′,’491144′,’491145′,’491251′,’491252′,’491253′,’491254′,’491255′,’491256′,’491585′,’491588′,’491591′,’491594′,’491597′,’491600′,’491650′,’491651′,’491652′,’491653′,’491654′,’491655′,’491656′,’491729′,’491732′,’491737′,’491740′,’491741′,’491742′,’491743′,’492085′,’492086′,’492087′,’492088′,’492089′,’492090′,’492091′,’492092′,’492093′,’492094′,’492095′,’492096′,’492097′,’492098′,’492099′,’492107′,’492161′,’492166′,’492167′,’492168′,’492170′,’492171′,’492172′,’492173′,’492174′,’492175′,’492176′,’492177′,’492178′,’492179′,’492180′,’492181′,’492182′,’492187′,’492188′,’492641′,’492642′,’492643′,’492645′,’492646′,’492647′,’492648′,’492649′,’492650′,’492651′,’492652′,’492653′,’492654′,’492655′,’492656′,’492657′,’492658′,’492659′,’492660′,’492661′,’492662′,’492663′,’492664′,’492665′,’492666′,’492667′,’492668′,’492669′,’492670′,’492671′,’492672′,’492673′,’492674′,’492675′,’492676′,’492677′,’492678′,’492679′,’492680′,’492681′,’492682′,’492683′,’492795′,’493100′,’493103′,’493740′,’493743′,’493746′,’493749′,’493752′,’493753′,’493754′,’493755′,’493756′,’493757′,’493843′,’493844′,’493845′,’493846′,’493847′,’493848′,

[sculawdm]

Update?

[Andras]

Hello Matthew,

Thanks for using our plugins and for reaching out! I’m sorry about the issue you are having. Let me try to help you solve it.

I checked your site and what I found is that clicking on next month gives an empty calendar, but when I refresh the page it loads the events.

The query posted above is reading from the wp_comments table, so there seems to be something fishy with the comments. Maybe a widget?

As  first it would be super helpful if you could run a full test for conflicts. Here’s a link to a handy guide for that: testing for conflicts

Please let me know what you find.

Thanks and cheers,
Andras

[sculawdm]

Fixed, Role Scoper added at last minute caused issue. Removed and corrected

[Andras]

Hey Mat,

Super stoked to hear you managed the find a fix for this. Awesome job!

Since this is marked resolved I am going to close this ticket, but if you need anything else related to this topic or another please post a new one in the forum and we will be happy to help you out.

Cheers,
Andras

PS: If you like our plugins, and you didn’t yet do so 🙂 we would be happy to receive a review in the wordpress.org repository. Thanks!
https://wordpress.org/support/plugin/the-events-calendar/reviews/

PS2: We’d be also grateful if you would give us feedback on your satisfaction with support. Just click on one of the classy looking emojis below. 🙂 If you can spare a few words, that’s even better. Doublethanks!

 

[Author]

Posts