• We are using Canvas, have everything updated and have disabled plugins one by one with no help.

    This is what the error looks like on our server:
    [Fri May 20 06:29:24.088546 2016] [:error] [pid 5309] [client 157.55.39.99:52223] KILLED QUERY (18140 characters long generated in /nas/content/live/cottagehome/wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-price-filter.php:126): \n\t\t\t\tSELECT min(meta_value + 0)\n\t\t\t\tFROM wp_posts as posts\n\t\t\t\tLEFT JOIN wp_postmeta as postmeta ON posts.ID = postmeta.post_id\n\t\t\t\tWHERE meta_key IN (‘_price’,’_min_variation_price’)\n\t\t\t\tAND meta_value != ”\n\t\t\t\tAND (\n\t\t\t\t\tposts.ID IN (74695,74650,74638,74626,74617,74596,74582,74560,74539,74515,74508,74498,74488,74470,74466,74456,74447,74434,73822,73811,73801,73781,73782,73767,73749,73740,73727,73715,73704,73697,73690,73683,73673,73665,73652,73643,73634,73608,73297,73274,73260,73124,73107,73098,73090,73078,73069,73060,73052,73044,73036,73012,73020,73011,72995,72992,72983,72908,72899,72891,72882,72874,72866,72855,72846,72838,72830,72822,72808,72799,72784,72774,72764,72748,72747,72737,72729,72721,72713,72677,72661,72659,72650,72640,72632,72624,72616,72600,72596,72581,72579,72571,72563,72553,72544,72535,72527,72519,72511,72503,72433,72425,72417,72409,72203,72100,72084,72072,72048,72056,72029,72012,72001,71960,71950,71940,71930,71922,71914,71906,71897,71887,71877,70791,70706,69020,68968,69468,69436,69455,69447,69377,69264,69247,69229,69185,69184,69164,68801,68871,68885,68815,68787,68913,68927,68899,68843,68829,68763,68745,68709,68710,68673,68691,68652,68635,68618,68601,68583,68565,68526,68527,68508,68315,68316,68288,68287,68260,68259,68245,68215,68216,68172,68200,68156,68141,68171,68440,68404,68403,68381,68343,68111,68094,68074,68041,68040,68022,67992,67987,67952,67953,67917,67921,67900,67883,67864,67831,67830,67813,67717,67691,67669,67614,67618,67584,67563,67580,67492,67545,67527,67493,67456,67474,67437,67420,67384,67367,67350,67332,67210,67208,67207,66856,66669,66667,66646,66381,66373,66370,66368,66366,66363,66360,66358,66355,66351,66349,66347,66345,66343,66334,224,66332,66327,66324,5175,66322,66318,66316,66313,66311,66306,66302,5129,5243,5223,5222,66290,66286,66281,66278,5115,66275,5172,66273,5155,5174,5146,5205,5153,5141,5144,5142,65191,65177,65168,65160,65136,65112,65096,65070,65062,65054,65047,65040,65033,65026,65010,64996,64977,64963,64956,64946,64936,64921,64912,64904,64895,64840,64831,64823,64805,64796,64561,64553,64547,64541,64534,64527,64521,64515,64508,64501,64496,64490,64484,64476,64465,64457,64438,64443,64449,64431,64416,64409,64402,64395,64388,64335,64322,64313,64303,64293,64284,64274,64265,64256,64223,64205,64197,64184,64176,64168,64159,64150,64141,64133,64123,64114,64105,64096,64087,64057,64049,63991,63983,63971,63954,63947,63940,63932,63924,63914,63905,63897,63889,63879,63871,63863,63852,63844,63836,63827,63814,63801,63789,63778,63769,63760,63751,63743,63733,63722,63714,63704,63692,63681,63654,63646,63638,63629,63621,63612,63601,63593,63585,63576,63566,63557,63549,63539,63531,63521,63512,63492,63481,63473,63465,63456,63447,63437,63423,63412,63348,63340,2547,61675,61673,61671,61669,61667,61665,61663,61502,61500,61498,61496,61491,61489,61487,61485,61483,61481,61479,61477,60499,60489,60480,60471,60250,60241,60233,60224,60216,60208,60190,60182,60174,60166,60157,60146,60134,60127,60119,60111,60103,60058,60047,60039,60028,60018,60008,59871,59863,59851,59827,59819,59811,58934,58909,58896,58883,58874,22328,58733,58724,58921,51340,51335,51331,51326,51322,51318,51268,51262,51256,51250,51244,51234,51229,51224,51219,51214,51209,51204,51199,50647,50576,50506,50436,50365,50295,50173,46590,46586,46583,46581,46576,46573,46571,46340,46336,46333,46331,46288,41296,41293,41291,41270,41170,41167,41163,40197,40191,40185,40183,40179,40177,40171,40169,40129,39796,39512,39511,39506,39499,39492,39476,39427,39426,39425,39424,39423,39422,39421,39420,39412,39403,39395,39388,39381,39373,39365,39358,39347,39339,39330,39320,39318,39311,39304,39299,39291,39285,39279,39267,39250,39240,39233,39223,39217,39206,39202,39194,39187,39181,39173,39160,39154,39147,39139,39137,39130,39123,39093,39085,39070,39062,39055,39047,39039,39031,39023,39022,39015,39005,38997,38990,38982,38972,38964,38957,38948,38937,38929,38921,38914,38906,38898,38883,38876,38864,38854,38852,38851,38850,38846,38845,38798,38796,38793,38789,38785,38739,38735,38731,38728,38513,38509,38504,38499,38468,38418,38398,37638,37636,37634,37632,37628,37623,37617,37615,37612,37609,37606,37603,37601,37598,37582,37579,37574,37571,37568,37564,37561,37558,37551,37549,37547,37528,37524,37522,37518,37515,37514,37512,37509,37507,37503,37500,37493,37473,37439,37430,37427,37416,37402,37400,37386,37370,37360,37302,37298,37295,37291,37187,37184,37164,37161,37110,37100,37088,37077,37060,37032,37028,37019,36999,36989,36980,36971,36962,36952,36943,36933,36923,36912,36902,36869,36790,36782,36774,36766,36751,36742,36735,36728,36717,36691,36682,36674,36666,36655,36646,36639,36632,36621,36610,36602,36585,36576,36566,36558,36550,36542,36533,36526,36518,36511,36498,36490,36462,36452,36442,36426,36417,36409,36400,36382,36374,36366,36342,36328,36320,36309,36301,36292,36284,36276,36247,36237,36230,36223,36190,35419,35414,35407,35400,35394,35389,35381,35376,35368,35306,35301,35295,35288,35267,35259,35252,35244,35228,35222,35215,35210,35205,35195,35187,35177,35168,35159,35150,35141,35132,35106,35096,35087,35076,35066,35056,35039,35034,35027,35021,35016,35009,35000,34821,34808,34789,34782,34776,34764,34757,34745,34736,34728,34721,34714,34707,34696,33895,33882,32674,32673,32652,24628,24616,24607,24604,24586,24577,24568,24559,24537,24520,24502,24483,24465,24416,24403,24359,24298,24151,24104,24055,24002,23914,23734,23639,23596,23553,23543,23420,23341,23261,23000,22968,22933,22861,22818,22796,22739,22715,22682,22620,22526,22515,22452,22407,22390,22326,22283,22272,22195,22194,22193,22192,22191,22190,22184,22176,22172,22170,22167,22165,22163,22161,22158,22156,22151,22149,22147,22145,22143,22096,22091,22084,22079,22074,22072,22057,22048,22041,22034,21960,22026,21988,45290,21917,21867,21787,21538,21463,21340,21227,21062,21030,20906,20872,20810,20752,20712,20293,20029,19242,19228,19215,19201,19177,19136,19124,19111,19098,19082,19039,18963,18950,18900,18855,18844,18828,18748,18717,18462,18456,18391,18160,18139,17974,17939,17903,17868,17833,17818,17574,17321,16425,16374,16361,16352,16332,16269,16225,16215,16206,15984,15933,15910,15705,15685,15657,15611,14709,14690,14672,14115,14106,14098,14077,14040,14033,14026,14019,14012,14005,13998,13991,13977,13958,13951,13938,13928,13919,13911,13902,13892,13884,13874,13861,13834,13823,13812,13803,13794,13239,13204,13169,13134,13099,13064,13029,12994,12924,12889,12854,12819,12784,12749,12714,12679,12644,12601,12121,12522,12487,12451,12329,12310,12198,12191,12156,12149,12142,12135,12128,11887,12102,12092,12082,12072,12054,12044,12035,12026,12017,12007,11998,11989,11980,11971,11962,11953,11944,11935,11926,11917,11873,11860,11847,11834,11820,11806,11797,11784,11774,11761,11724,11711,11698,11695,11682,11679,11676,11655,11648,11635,11621,11607,11587,11586,11559,11539,11532,11525,11518,11504,11458,11432,11425,11411,11404,11397,11388,11353,11318,11281,11267,11258,11236,11223,11210,11199,11189,11175,11136,11127,11095,11060,11047,11034,11025,11003,10951,10942,10933,10919,10906,10897,10883,10870,10857,10848,10822,10809,10754,10732,10723,10713,10667,10609,10596,10582,10569,10561,10547,10534,10486,10426,10413,10400,10387,10374,10361,10348,10335,10296,10283,10270,10257,10244,10231,10205,10192,10179,10166,10153,10140,10114,10101,10093,10085,10043,10034,10016,10008,9954,9944,9918,9901,9881,9849,9841,9797,9789,9781,9772,9751,9709,9699,9689,9680,9668,9659,9596,9587,9578,9559,9537,9482,9443,9425,9385,9373,9364,9325,9286,9167,9126,9087,9009,8965,8926,8865,8824,8746,8588,8549,8510,8431,8353,8337,8255,8173,8169,8162,8155,8147,8137,8121,8106,8101,8086,8081,8071,8055,8047,8037,8036,8034,8033,8031,8030,8029,8028,8021,8020,8019,8018,7919,7910,7901,7883,7874,7864,7854,7838,7806,7815,7782,7730,7677,7623,7579,7491,7409,7355,7313,7320,7307,7266,7254,7228,7215,7160,7147,6966,6934,6920,6865,6784,6729,6723,6705,6675,6662,5297,5287,5290,5267,5183,5192,5190,5185,5186,5182,5122,5124,5126,5131,5133,5134,5194,5197,5198,5199,5202,5196,5118,5119,5120,5116,5114,

    ### WordPress Environment ###
    
    Home URL: https://cottagehomefurniture.com
    Site URL: https://cottagehomefurniture.com
    WC Version: 2.5.5
    Log Directory Writable: ✔
    WP Version: 4.5.2
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    Language: en_US
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 5.5.9-1ubuntu4.16
    PHP Post Max Size: 100 MB
    PHP Time Limit: 3600
    PHP Max Input Vars: 10000
    SUHOSIN Installed: –
    MySQL Version: 5.6.29
    Max Upload Size: 50 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 2.5.5
    :
    woocommerce_sessions: ✔
    woocommerce_api_keys: ✔
    woocommerce_attribute_taxonomies: ✔
    woocommerce_termmeta: ✔
    woocommerce_downloadable_product_permissions: ✔
    woocommerce_order_items: ✔
    woocommerce_order_itemmeta: ✔
    woocommerce_tax_rates: ✔
    woocommerce_tax_rate_locations: ✔
    
    ### Active Plugins (40) ###
    
    Gravity Forms: by rocketgenius – 1.9.19
    Advanced Custom Fields: by Elliot Condon – 4.4.7
    Autoptimize: by Frank Goossens (futtta) – 2.0.2
    Bootstrap Collapse: by Suresh Kumar – 1.0.4
    Disable Comments: by Samir Shah – 1.5
    Duplicate Post: by Enrico Battocchi – 2.6
    Dynamic Widgets: by Qurl – 1.5.11
    Enable Media Replace: by Måns Jonasson – 3.0.4
    Google Analytics by Yoast eCommerce tracking addon: by Team Yoast – 3.0.5
    Google Analytics by MonsterInsights: by MonsterInsights – 5.5
    IgniteWoo Updater: by IgniteWoo – 1.2
    Nivo Slider WordPress Plugin: by Dev7studios – 1.9.1
    Responsive Lightbox: by dFactory – 1.6.8
    Rich Tax Description Editor: by Davit Barbakadze – 1.2.4
    Optimize Database after Deleting Revisions: by CAGE Web Design | Rolf van Gelder
    Eindhoven
    The Netherlands – 4.1.6
    
    Testimonials Slider: by ntech-technologies – 2.9.5
    Toggle The Title: by Avner Komarow – 1.4
    UberMenu 2 - WordPress Mega Menu Plugin: by Chris Mavricos
    SevenSpark – 2.3.2.2
    
    WangGuard: by WangGuard – 1.6.2
    Widgets on Pages: by Todd Halfpenny – 0.0.12
    WooCommerce Advanced Ajax Layered Navigation: by Sixty-One Designs
    Inc. – 1.3.17
    
    WooCommerce Cart Reports: by WPBackOffice – 1.1.9
    WooCommerce Checkout Add-Ons: by WooThemes / SkyVerge – 1.7.1
    WooCommerce Extra Product Sorting Options: by SkyVerge – 2.3.0
    WooCommerce Authorize.net DPM Gateway: by WooThemes – 1.6.0
    NW ADCart for WooCommerce: by Netwakies – 1.3.2
    WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 1.5.32
    WooCommerce Product Add-ons: by WooThemes – 2.7.17
    WooCommerce Product Badge: by Terry Tsang – 1.0.4
    WooCommerce Univocal Category URLs: by Raneri Web Design Snc – 1.0.2
    WooCommerce Tab Manager: by WooThemes / SkyVerge – 1.5.3
    WooCommerce Table Rate Shipping: by Mike Jolley – 2.9.2
    WooCommerce: by WooThemes – 2.5.5
    Yoast SEO: by Team Yoast – 3.2.5
    WP Editor Widget: by David Mårtensson
    Odd Alice – 0.5.5
    
    WP Smush Pro: by WPMU DEV – 2.0.6.1
    WP Social SEO Booster: by Daniel Waser – 1.2.0
    WP Edit Pro: by Josh Lobe – 4.3.2
    Yoast WooCommerce SEO: by Team Yoast – 3.0
    YITH WooCommerce Ajax Product Filter: by YITHEMES – 2.9.2
    
    ### Settings ###
    
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    
    ### API ###
    
    API Enabled: ✔
    API Version: 3.1.0
    
    ### WC Pages ###
    
    Shop Base: #13571 - /shop/
    Cart: #7 - /cart/
    Checkout: #11 - /checkout/
    My Account: #12 - /my-account-2/
    
    ### Taxonomies ###
    
    Product Types: configurable (configurable)
    downloadable (downloadable)
    external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    virtual (virtual)
    
    ### Theme ###
    
    Name: Child Theme cottagehome
    Version: 0.1.0
    Author URL:
    Child Theme: ✔
    Parent Theme Name: Canvas
    Parent Theme Version: 5.9.22
    Parent Theme Author URL: http://www.woothemes.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: canvas-child/archive-product.php
    canvas-child/woocommerce/cart/mini-cart.php
    canvas-child/woocommerce/content-product.php
    canvas-child/woocommerce/single-product/add-to-cart/simple.php
    canvas-child/woocommerce/single-product/meta.php
    canvas-child/woocommerce/single-product/product-image.php
    canvas-child/woocommerce/single-product/product-thumbnails.php
    canvas-child/single-product/short-description.php
    canvas-child/single-product/tabs/additional-information.php
    canvas-child/single-product/tabs/description.php
    canvas-child/single-product/tabs/tabs.php
    canvas-child/woocommerce/single-product/up-sells.php
    canvas-child/woocommerce/single-product.php

    https://wordpress.org/plugins/woocommerce/

Viewing 1 replies (of 1 total)
  • Plugin Author Mike Jolley (a11n)

    (@mikejolley)

    We’re aware some servers can struggle with the layered nav queries. I’ve improved them in 2.6 which is due live in a few weeks.

Viewing 1 replies (of 1 total)
  • The topic ‘Price Filter Creating LONG query that kills page and created 502’ is closed to new replies.