• Resolved mylescameron

    (@mylescameron)


    We have been using publishpress for a while but just came across an error which is causing the views to be blank. A query is being created which is longer than 16k characters. By the looks of it you are inserting IDs into a select string which means that if the site has a lot of posts then it would create an incredibly long query string.

    KILLED QUERY (16754 characters long generated in /plugins/revisionary-pro/admin/class-list-table_rvy.php:165):

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( \\n ( wp_postmeta.meta_key = ‘_cic_rejected’ AND wp_postmeta.meta_value = ‘1’ )\\n) AND wp_posts.post_type IN (‘post’, ‘page’, ‘e-landing-page’, ‘elementor_library’, ‘swfd-courses’, ‘custom_css’, ‘customize_changeset’, ‘wp_template’, ‘wpforms’, ‘elementor_snippet’, ‘um_form’, ‘um_directory’, ‘commitment’, ‘member’, ‘team’, ‘wp_log’, ‘um_groups’, ‘acf-field’, ‘bnfw_notification’) AND ((wp_posts.post_status = ‘pending-revision’ OR wp_posts.post_status = ‘future-revision’)) AND (wp_posts.comment_count IN (‘11828′,’11827′,’11826′,’11825′,’11824′,’11823′,’11822′,’11821′,’11820′,’11819′,’11817′,’11816′,’11814′,’11815′,’11810′,’11811′,’11812′,’11813′,’11806′,’11807′,’11808′,’11809′,’11802′,’11803′,’11804′,’11805′,’11799′,’11800′,’11801′,’11795′,’11796′,’11797′,’11798′,’11792′,’11793′,’11794′,’11791′,’11788′,’11789′,’11790′,’11785′,’11786′,’11787′,’11782′,’11783′,’11784′,’11779′,’11780′,’11781′,’11775′,’11776′,’11777′,’11778′,’11772′,’11773′,’11774′,’11771′,’11770′,’11768′,’11764′,’11762′,’11761′,’11760′,’11759′,’8039′,’10593′,’11758′,’11757′,’11755′,’11750′,’11749′,’11748′,’11747′,’11745′,’11743′,’11332′,’11419′,’11712′,’11736′,’11732′,’11733′,’11734′,’11735′,’11729′,’11730′,’11731′,’11725′,’11726′,’11727′,’11728′,’11720′,’11722′,’11723′,’11724′,’11717′,’11718′,’11719′,’11713′,’11714′,’11715′,’11716′,’10248′,’11711′,’11710′,’11709′,’11708′,’11706′,’11707′,’11705′,’11703′,’11704′,’11702′,’11700′,’11701′,’11699′,’11697′,’11698′,’11696′,’11694′,’11695′,’11693′,’11691′,’11692′,’11690′,’11689′,’11687′,’11688′,’11686′,’11685′,’11683′,’11684′,’11681′,’11682′,’11680′,’11678′,’11679′,’11676′,’11677′,’11675′,’11674′,’11672′,’11673′,’11671′,’11670′,’11668′,’11669′,’11667′,’11666′,’11665′,’11663′,’11664′,’11661′,’11662′,’10523′,’11658′,’11656′,’11655′,’11643′,’11640′,’11639′,’11638′,’11637′,’11636′,’11634′,’11633′,’11632′,’11630′,’11629′,’11211′,’11628′,’11627′,’11210′,’11624′,’11623′,’11621′,’11620′,’11616′,’11615′,’11614′,’11613′,’11611′,’11612′,’11610′,’11609′,’11608′,’11607′,’11605′,’11602′,’11603′,’11594′,’11600′,’11601′,’11595′,’11590′,’11589′,’11588′,’11587′,’11585′,’11584′,’11583′,’10054′,’11582′,’11581′,’9663′,’11580′,’11579′,’11578′,’11577′,’11576′,’11574′,’11573′,’11572′,’11571′,’11570′,’11569′,’11568′,’11567′,’11566′,’11565′,’11564′,’11563′,’11562′,’11561′,’11560′,’11559′,’11558′,’11557′,’11556′,’11555′,’11554′,’11553′,’11552′,’11551′,’11550′,’11548′,’11545′,’11546′,’11544′,’11542′,’11541′,’11540′,’11539′,’11538′,’11535′,’11536′,’11533′,’11531′,’11530′,’11525′,’11526′,’11524′,’11523′,’11522′,’11520′,’11518′,’11516′,’11515′,’11528′,’11513′,’11511′,’11508′,’11507′,’11506′,’11505′,’11504′,’11503′,’11502′,’11501′,’11499′,’11498′,’11496′,’11495′,’11493′,’11491′,’11490′,’11488′,’11487′,’11486′,’11484′,’11483′,’11481′,’11480′,’11479′,’11477′,’11476′,’11472′,’11474′,’11468′,’11469′,’11464′,’11465′,’11466′,’11460′,’11459′,’11457′,’11453′,’11450′,’11447′,’11445′,’11440′,’11439′,’11438′,’11437′,’11436′,’11435′,’11432′,’11431′,’11428′,’11425′,’11424′,’11423′,’11422′,’11421′,’11417′,’11416′,’11414′,’11413′,’11412′,’11411′,’11369′,’11407′,’11405′,’11404′,’11403′,’11400′,’11397′,’11395′,’11392′,’11391′,’11390′,’11389′,’11388′,’11387′,’11386′,’11385′,’11384′,’11383′,’11382′,’11381′,’11380′,’11379′,’11378′,’11377′,’11376′,’11375′,’11374′,’11373′,’9655′,’11359′,’11358′,’11357′,’11356′,’11355′,’11353′,’11352′,’11348′,’11346′,’11347′,’11345′,’11344′,’11343′,’11340′,’11339′,’11338′,’11330′,’11329′,’11328′,’11326′,’11325′,’11324′,’11322′,’11321′,’11318′,’11317′,’11316′,’11315′,’11314′,’11313′,’11312′,’11310′,’11309′,’11308′,’10534′,’11294′,’11266′,’11263′,’11261′,’11224′,’11223′,’9647′,’11207′,’11185′,’11184′,’10627′,’11116′,’8529′,’11146′,’10797′,’11136′,’11137′,’11126′,’10741′,’11115′,’6232′,’4105′,’4620′,’11156′,’5759′,’11067′,’6434′,’6436′,’6438′,’6440′,’6442′,’6372′,’6370′,’6358′,’6356′,’6352′,’7627′,’7709′,’7777′,’8531′,’11026′,’10058′,’11021′,’10811′,’11014′,’10980′,’10978′,’10974′,’10975′,’10965′,’10967′,’10946′,’10938′,’10937′,’10932′,’10934′,’10930′,’10921′,’10920′,’10243′,’10245′,’10913′,’9652′,’10109′,’10816′,’10844′,’10830′,’10824′,’10815′,’10810′,’10809′,’10807′,’10766′,’10801′,’10776′,’10774′,’10756′,’10755′,’10754′,’10751′,’10752′,’10753′,’10749′,’10750′,’10747′,’10748′,’10745′,’10746′,’10743′,’10742′,’10725′,’10693′,’10691′,’10689′,’10687′,’10685′,’10683′,’10681′,’10679′,’10677′,’10675′,’8561′,’10667′,’10660′,’10658′,’10652′,’10650′,’10635′,’10636′,’10087′,’8364′,’4819′,’10603′,’10601′,’10598′,’10600′,’10587′,’10585′,’10583′,’10575′,’10572′,’10567′,’10566′,’10568′,’10533′,’10395′,’10515′,’8127′,’10496′,’10494′,’10486′,’10484′,’10482′,’10480′,’10477′,’10457′,’10455′,’10452′,’10450′,’10444′,’10442′,’10440′,’10438′,’10429′,’10375′,’10373′,’10422′,’10419′,’10412′,’10410′,’10399′,’10388′,’10381′,’10378′,’10370′,’10358′,’10342′,’10340′,’10324′,’10322′,’10320′,’10318′,’10316′,’10314′,’10312′,’10310′,’10308′,’10306′,’10303′,’10305′,’10300′,’10291′,’10286′,’10249′,’10250′,’9649′,’10216′,’10214′,’10210′,’10208′,’10206′,’10190′,’10174′,’10150′,’10051′,’10147′,’10145′,’10143′,’10122′,’10101′,’10099′,’10098′,’10097′,’10085′,’6470′,’10073′,’10057′,’10055′,’10053′,’10052′,’10035′,’9996′,’9993′,’9987′,’9969′,’9970′,’9939′,’9937′,’9935′,’9933′,’9931′,’9929′,’9927′,’9925′,’9923′,’9910′,’9904′,’9853′,’9821′,’9818′,’9714′,’9802′,’9783′,’9781′,’9772′,’9770′,’9764′,’9762′,’9755′,’9749′,’9747′,’9745′,’9743′,’9741′,’9739′,’9733′,’9734′,’9735′,’9731′,’9729′,’9727′,’9725′,’9718′,’9716′,’9715′,’9668′,’9664′,’9660′,’9662′,’9661′,’9659′,’9657′,’9656′,’9654′,’9653′,’9650′,’9651′,’9648′,’9606′,’9642′,’9633′,’9609′,’9607′,’9601′,’9600′,’9590′,’9531′,’9567′,’9568′,’9530′,’9524′,’9523′,’11765′,’9308′,’9351′,’9352′,’9304′,’9335′,’9306′,’9613′,’9320′,’9319′,’9317′,’8329′,’9293′,’9170′,’8389′,’8383′,’8982′,’8891′,’8886′,’8485′,’8841′,’8829′,’8820′,’8784′,’8774′,’8726′,’8626′,’8589′,’8558′,’8549′,’8544′,’8533′,’8527′,’8507′,’8504′,’8496′,’8487′,’8483′,’8481′,’8450′,’8438′,’8429′,’8424′,’8418′,’8402′,’8395′,’8393′,’8391′,’8387′,’8385′,’8373′,’8369′,’8340′,’8333′,’8326′,’8323′,’8320′,’4413′,’3786′,’8305′,’8300′,’8269′,’8267′,’8263′,’8261′,’8255′,’8249′,’8243′,’8229′,’8228′,’8216′,’8208′,’8206′,’8200′,’8194′,’8192′,’8190′,’8188′,’8186′,’8184′,’8181′,’8178′,’8176′,’8168′,’8160′,’8152′,’8144′,’8141′,’8130′,’8107′,’8105′,’8102′,’8100′,’8093′,’8090′,’8087′,’8083′,’8071′,’8050′,’8046′,’8043′,’8036′,’8034′,’8028′,’8025′,’8023′,’7847′,’8006′,’8002′,’8000′,’7987′,’7651′,’7985′,’7983′,’7966′,’7927′,’7848′,’7845′,’7838′,’7835′,’7828′,’7823′,’7821′,’7814′,’7812′,’7810′,’7804′,’7802′,’7797′,’7794′,’7789′,’7786′,’7783′,’7781′,’7779′,’7775′,’7751′,’7747′,’7731′,’7723′,’7714′,’7711′,’7707′,’7702′,’7697′,’7693′,’7691′,’7674′,’7597′,’7642′,’7666′,’7664′,’7662′,’7660′,’7656′,’7649′,’7643′,’7638′,’9617′,’7635′,’7633′,’7631′,’7629′,’7624′,’7621′,’7619′,’7612′,’7605′,’7604′,’7602′,’7600′,’7590′,’7242′,’7584′,’7579′,’4009′,’7562′,’7559′,’7556′,’7555′,’7552′,’7549′,’7544′,’7539′,’7522′,’7518′,’7515′,’7513′,’7511′,’7509′,’7506′,’7503′,’7500′,’7494′,’7490′,’7487′,’7485′,’7480′,’7478′,’7476′,’7473′,’7469′,’7466′,’7467′,’7463′,’7454′,’7455′,’7452′,’7450′,’7448′,’7444′,’7440′,’7437′,’7351′,’7432′,’7427′,’7425′,’7419′,’7414′,’7412′,’7406′,’7404′,’7402′,’7400′,’7396′,’7394′,’7391′,’7390′,’7388′,’7385′,’7349′,’7340′,’7336′,’7334′,’7331′,’7329′,’7317′,’7314′,’7311′,’7308′,’7290′,’7278′,’7272′,’7269′,’7263′,’7260′,’7256′,’7254′,’7252′,’7250′,’7248′,’7246′,’7244′,’7239′,’7231′,’7214′,’7209′,’7167′,’7190′,’7168′,’7165′,’7162′,’7154′,’7146′,’7095′,’7088′,’7086′,’7083′,’7078′,’7075′,’7071′,’7066′,’7064′,’7062′,’7060′,’7058′,’7056′,’7054′,’7037′,’7009′,’4774′,’7006′,’7002′,’3549′,’4613′,’6994′,’6990′,’6987′,’4622′,’6984′,’6975′,’6972′,’6957′,’6953′,’6948′,’6936′,’6934′,’6931′,’6923′,’6921′,’6919′,’6917′,’6915′,’6906′,’6902′,’6898′,’6893′,’6890′,’6888′,’6884’,”,……

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘KILLED Query – over 16k characters’ is closed to new replies.