Open jefflenz opened 4 years ago
Hi @jefflenz! Thanks for submitting your issue here. Can you tell us more about your settings? What version of Elastic Search is your Search Engine configured to?
Can you also provide the stacktrace for this issue so that we can pinpoint where this is thrown? Thank you for your assistance!
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'FIELD(e.entity_id,34613,34310,22712,3587,22418,23036,8735,22889,8663,3245,22883,22337,22463,22466,22871,22859,22397,33578,8627,24806,33608,22391,22775,47766,22703,22706,8615,22700,22715,2957,8' in 'order clause', query was: SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`url_key`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`giftcard_amounts`, `e`.`allow_open_amount`, `e`.`open_amount_min`, `e`.`open_amount_max`, `e`.`tax_class_id`, `e`.`swatch_image`, `e`.`msrp_custom`, `e`.`badge_closeout`, `e`.`badge_discontinued`, `e`.`badge_free_gift`, `e`.`badge_great_value`, `e`.`badge_new`, `e`.`badge_special`, `e`.`badge_special_order`, `e`.`badge_top_seller`, `e`.`am_shipping_type`, `e`.`am_shipping_type_value`, `e`.`stock_expected_date`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `product_entity`.`row_id`, `stock_status_index`.`stock_status` AS `is_salable`, `e_entity`.`row_id` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = e.entity_id AND (product_entity.created_in <= '1563829910' AND product_entity.updated_in > '1563829910')
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
INNER JOIN `catalog_product_entity` AS `e_entity` ON e_entity.entity_id = e.entity_id AND (e_entity.created_in <= '1563829910' AND e_entity.updated_in > '1563829910') WHERE (e.entity_id IN (34613, 34310, 22712, 3587, 22418, 23036, 8735, 22889, 8663, 3245, 22883, 22337, 22463, 22466, 22871, 22859, 22397, 33578, 8627, 24806, 33608, 22391, 22775, 47766, 22703, 22706, 8615, 22700, 22715, 2957, 8516, 24809, 22682, 22757, 22751, 8174, 22853, 8645, 5516, 22886, 24785, 8579, 8591, 3035, 3005, 47790, 22808, 22754, 22679, 24761, 22796, 22736, 33563, 22454, 22967, 47571, 22742, 23048, 22880, 3113, 5612, 22964, 23102, 22745, 34853, 33581, 6923, 3020, 47871, 22400, 8186, 22475, 2909, 8753, 8492, 4025, 24788, 22361, 34922, 4379, 47241, 22832, 8534, 48258, 3059, 22688, 4352, 8222, 4250, 47562, 24773, 22352, 34775, 8210, 46833, 34394, 22355, 22340, 23024, 22409, 4184, 48363, 8603, 22841, 22658, 24836, 22802, 22694, 47739, 33590, 24830, 4406, 24779, 22367, 3503, 47499, 46584, 22862, 5258, 4073, 3074, 2975, 47727, 46860, 33584, 4535, 3089, 1736, 24833, 22865, 22505, 22364, 5588, 35366, 33599, 22697, 8558, 6185, 4988, 47508, 46084, 24848, 24839, 24827, 24824, 24794, 24782, 22985, 22826, 22457, 49016, 47511, 47148, 46620, 46183, 35009, 34937, 33575, 24860, 24800, 23129, 23027, 22991, 22988, 22976, 22913, 22874, 22856, 22814, 22811, 22799, 22793, 22787, 22772, 22769, 22766, 22664, 22652, 22334, 5684, 5636, 5564, 4721, 4697, 4649, 4601, 4583, 4559, 4511, 4487, 4463, 4442, 4274, 4211, 4121, 4097, 2747, 2270, 35075, 34955, 34958, 8462, 23099, 35069, 34952, 34949, 35198, 35108, 35117, 24815, 35126, 23039, 34316, 22868, 23144, 34676, 34658, 6230, 33551, 46533, 22358, 6206, 22844, 24812, 6806, 23072, 23195, 23198, 23141, 3713, 33560, 34679, 2600, 48688, 2285, 3803, 2831, 47820, 3449, 3953, 3827, 24842, 5057, 23069, 22370, 8708, 47247, 49107, 4304, 4049, 23246, 22931, 22850, 46848, 34940, 47898, 47793, 22460, 5504, 3758, 46587, 4328, 4235, 3929, 3704, 24872, 24845, 22817, 22667, 7370, 5291, 2312, 23156, 23126, 5309, 3695, 49086, 48216, 48198, 46629, 46132, 33635, 33611, 24875, 23123, 23060, 23045, 22970, 22583, 22439, 22379, 8069, 7712, 7256, 5339, 5222, 5033, 3731, 2363, 2252, 2162, 2132, 1718, 34358, 34355, 34343, 35060, 35168, 35381, 22628, 35120, 8126, 34688, 2423, 22502, 8144, 34361, 8123, 2486, 8141, 6254, 2567, 23000, 2513, 3578, 2636, 34979, 8690, 34322, 34847, 3365, 33605, 35153, 2876, 22547, 35114, 8723, 34784, 33602, 47994, 8288, 35150, 34652, 22406, 33557, 48622, 47991, 47529, 48003, 35000, 34697, 8021, 48478, 46218, 8318, 22805, 22538, 22427, 47460, 34844, 5993, 47967, 22673, 22394, 22529, 22562, 35171, 22541, 2789, 22424, 48547, 8111, 5840, 34826, 6095, 46836, 48330, 35180, 22544, 8267, 8261, 8336, 6131, 22898, 6026, 2660, 3542, 35183, 35174, 33569, 33620, 3551, 47952, 35177, 3560, 2537, 22901, 22532, 2459, 33623, 22847, 22838, 22403, 8681, 47505, 46839, 22829, 46443, 33614, 2591, 22535, 3518, 46788, 34982, 34850, 3740, 46290, 34988, 8327, 34946, 22997, 2441, 1493, 48619, 46791, 22670, 8441, 2684, 6008, 3977, 22916, 22892, 46818, 34985, 33554, 3668, 46311, 34991, 23042, 23033, 22835, 3485, 48087, 46416, 34313, 33548, 23147, 8309, 6143, 5492, 3686, 1553, 48159, 46851, 35387, 34700, 34592, 23030, 22895, 22634, 8654, 8357, 6764, 6038, 3677, 48291, 48288, 48207, 48180, 48171, 48162, 48150, 48126, 48114, 47196, 46362, 35003, 34913, 34910, 33626, 24857, 22763, 8090, 7796, 7232, 6113, 6077, 5483, 5048, 5018, 3905, 3722, 3467, 3395, 2627, 2546, 1979, 0)) ORDER BY `FIELD(e`.`entity_id,34613,34310,22712,3587,22418,23036,8735,22889,8663,3245,22883,22337,22463,22466,22871,22859,22397,33578,8627,24806,33608,22391,22775,47766,22703,22706,8615,22700,22715,2957,8516,24809,22682,22757,22751,8174,22853,8645,5516,22886,24785,8579,8591,3035,3005,47790,22808,22754,22679,24761,22796,22736,33563,22454,22967,47571,22742,23048,22880,3113,5612,22964,23102,22745,34853,33581,6923,3020,47871,22400,8186,22475,2909,8753,8492,4025,24788,22361,34922,4379,47241,22832,8534,48258,3059,22688,4352,8222,4250,47562,24773,22352,34775,8210,46833,34394,22355,22340,23024,22409,4184,48363,8603,22841,22658,24836,22802,22694,47739,33590,24830,4406,24779,22367,3503,47499,46584,22862,5258,4073,3074,2975,47727,46860,33584,4535,3089,1736,24833,22865,22505,22364,5588,35366,33599,22697,8558,6185,4988,47508,46084,24848,24839,24827,24824,24794,24782,22985,22826,22457,49016,47511,47148,46620,46183,35009,34937,33575,24860,24800,23129,23027,22991,22988,22976,22913,22874,22856,22814,22811,22799,22793,22787,22772,22769,22766,22664,22652,22334,5684,5636,5564,4721,4697,4649,4601,4583,4559,4511,4487,4463,4442,4274,4211,4121,4097,2747,2270,35075,34955,34958,8462,23099,35069,34952,34949,35198,35108,35117,24815,35126,23039,34316,22868,23144,34676,34658,6230,33551,46533,22358,6206,22844,24812,6806,23072,23195,23198,23141,3713,33560,34679,2600,48688,2285,3803,2831,47820,3449,3953,3827,24842,5057,23069,22370,8708,47247,49107,4304,4049,23246,22931,22850,46848,34940,47898,47793,22460,5504,3758,46587,4328,4235,3929,3704,24872,24845,22817,22667,7370,5291,2312,23156,23126,5309,3695,49086,48216,48198,46629,46132,33635,33611,24875,23123,23060,23045,22970,22583,22439,22379,8069,7712,7256,5339,5222,5033,3731,2363,2252,2162,2132,1718,34358,34355,34343,35060,35168,35381,22628,35120,8126,34688,2423,22502,8144,34361,8123,2486,8141,6254,2567,23000,2513,3578,2636,34979,8690,34322,34847,3365,33605,35153,2876,22547,35114,8723,34784,33602,47994,8288,35150,34652,22406,33557,48622,47991,47529,48003,35000,34697,8021,48478,46218,8318,22805,22538,22427,47460,34844,5993,47967,22673,22394,22529,22562,35171,22541,2789,22424,48547,8111,5840,34826,6095,46836,48330,35180,22544,8267,8261,8336,6131,22898,6026,2660,3542,35183,35174,33569,33620,3551,47952,35177,3560,2537,22901,22532,2459,33623,22847,22838,22403,8681,47505,46839,22829,46443,33614,2591,22535,3518,46788,34982,34850,3740,46290,34988,8327,34946,22997,2441,1493,48619,46791,22670,8441,2684,6008,3977,22916,22892,46818,34985,33554,3668,46311,34991,23042,23033,22835,3485,48087,46416,34313,33548,23147,8309,6143,5492,3686,1553,48159,46851,35387,34700,34592,23030,22895,22634,8654,8357,6764,6038,3677,48291,48288,48207,48180,48171,48162,48150,48126,48114,47196,46362,35003,34913,34910,33626,24857,22763,8090,7796,7232,6113,6077,5483,5048,5018,3905,3722,3467,3395,2627,2546,1979,0)` ASC
<pre>#1 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303]
#2 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#3 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#4 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:542]
#5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:617]
#6 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737]
#7 Zend_Db_Adapter_Abstract->fetchAll() called at [vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php:21]
#8 Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:778]
#9 Magento\Framework\Data\Collection\AbstractDb->_fetchAll() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:1130]
#10 Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities() called at [generated/code/Magento/CatalogSearch/Model/ResourceModel/Fulltext/Collection/Interceptor.php:1207]
#11 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->_loadEntities() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:927]
#12 Magento\Eav\Model\Entity\Collection\AbstractCollection->load() called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:803]
#13 Magento\Catalog\Model\ResourceModel\Product\Collection->load() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#14 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#15 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#16 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->___callPlugins() called at [generated/code/Magento/CatalogSearch/Model/ResourceModel/Fulltext/Collection/Interceptor.php:338]
#17 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->load() called at [vendor/magento/module-review/Observer/CatalogBlockProductCollectionBeforeToHtmlObserver.php:42]
#18 Magento\Review\Observer\CatalogBlockProductCollectionBeforeToHtmlObserver->execute() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:88]
#19 Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:74]
#20 Magento\Framework\Event\Invoker\InvokerDefault->dispatch() called at [vendor/magento/module-staging/Model/Event/Manager.php:97]
#21 Magento\Staging\Model\Event\Manager->dispatch() called at [generated/code/Magento/Staging/Model/Event/Manager/Proxy.php:95]
#22 Magento\Staging\Model\Event\Manager\Proxy->dispatch() called at [vendor/magento/module-catalog/Block/Product/ListProduct.php:482]
#23 Magento\Catalog\Block\Product\ListProduct->initializeProductCollection() called at [vendor/magento/module-catalog/Block/Product/ListProduct.php:116]
#24 Magento\Catalog\Block\Product\ListProduct->_getProductCollection() called at [vendor/magento/module-catalog/Block/Product/ListProduct.php:139]
#25 Magento\Catalog\Block\Product\ListProduct->getLoadedProductCollection() called at [generated/code/Magento/Catalog/Block/Product/ListProduct/Interceptor.php:37]
#26 Magento\Catalog\Block\Product\ListProduct\Interceptor->getLoadedProductCollection() called at [vendor/magento/module-catalog-search/Block/Result.php:182]
#27 Magento\CatalogSearch\Block\Result->_getProductCollection() called at [vendor/magento/module-catalog-search/Block/Result.php:206]
#28 Magento\CatalogSearch\Block\Result->getResultCount() called at [vendor/magento/module-catalog-search/view/frontend/templates/result.phtml:10]
#29 include() called at [vendor/magento/framework/View/TemplateEngine/Php.php:59]
#30 Magento\Framework\View\TemplateEngine\Php->render() called at [vendor/magento/framework/View/Element/Template.php:271]
#31 Magento\Framework\View\Element\Template->fetchView() called at [vendor/magento/framework/View/Element/Template.php:301]
#32 Magento\Framework\View\Element\Template->_toHtml() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1094]
#33 Magento\Framework\View\Element\AbstractBlock->Magento\Framework\View\Element\{closure}() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1098]
#34 Magento\Framework\View\Element\AbstractBlock->_loadCache() called at [vendor/magento/framework/View/Element/AbstractBlock.php:671]
#35 Magento\Framework\View\Element\AbstractBlock->toHtml() called at [vendor/magento/framework/View/Layout.php:557]
#36 Magento\Framework\View\Layout->_renderBlock() called at [vendor/magento/framework/View/Layout.php:533]
#37 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#38 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:488]
#39 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#40 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:585]
#41 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:535]
#42 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#43 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:488]
#44 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#45 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:585]
#46 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:535]
#47 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#48 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:488]
#49 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#50 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:585]
#51 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:535]
#52 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#53 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:488]
#54 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#55 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:585]
#56 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:535]
#57 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#58 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:488]
#59 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#60 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:585]
#61 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:535]
#62 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#63 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:488]
#64 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#65 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:585]
#66 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:535]
#67 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#68 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:488]
#69 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#70 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:954]
#71 Magento\Framework\View\Layout->getOutput() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#72 Magento\Framework\View\Layout\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#73 Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#74 Magento\Framework\View\Layout\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:494]
#75 Magento\Framework\View\Layout\Interceptor->getOutput() called at [vendor/magento/framework/View/Result/Page.php:258]
#76 Magento\Framework\View\Result\Page->render() called at [vendor/magento/framework/View/Result/Layout.php:171]
#77 Magento\Framework\View\Result\Layout->renderResult() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#78 Magento\Framework\View\Result\Page\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#79 Magento\Framework\View\Result\Page\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#80 Magento\Framework\View\Result\Page\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Result/Page/Interceptor.php:130]
#81 Magento\Framework\View\Result\Page\Interceptor->renderResult() called at [vendor/magento/framework/App/View.php:221]
#82 Magento\Framework\App\View->renderLayout() called at [vendor/magento/module-catalog-search/Controller/Result/Index.php:168]
#83 Magento\CatalogSearch\Controller\Result\Index->getNotCacheableResult() called at [vendor/magento/module-catalog-search/Controller/Result/Index.php:110]
#84 Magento\CatalogSearch\Controller\Result\Index->execute() called at [generated/code/Magento/CatalogSearch/Controller/Result/Index/Interceptor.php:24]
#85 Magento\CatalogSearch\Controller\Result\Index\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:108]
#86 Magento\Framework\App\Action\Action->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#87 Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#88 Magento\CatalogSearch\Controller\Result\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-customer-segment/Model/App/Action/ContextPlugin.php:81]
#89 Magento\CustomerSegment\Model\App\Action\ContextPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#90 Magento\CatalogSearch\Controller\Result\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#91 Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callPlugins() called at [generated/code/Magento/CatalogSearch/Controller/Result/Index/Interceptor.php:39]
#92 Magento\CatalogSearch\Controller\Result\Index\Interceptor->dispatch() called at [vendor/magento/framework/App/FrontController.php:159]
#93 Magento\Framework\App\FrontController->processRequest() called at [vendor/magento/framework/App/FrontController.php:99]
#94 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#95 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#96 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:94]
#97 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#98 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/fastly/magento2/Model/FrontControllerPlugin.php:120]
#99 Fastly\Cdn\Model\FrontControllerPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#100 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:73]
#101 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#102 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#103 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:26]
#104 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:137]
#105 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:24]
#106 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:261]
#107 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:40]
</pre>
I have "make a request to backend" set to yes, instant search is disabled. There's a lot of settings, are there specific ones you'd like to know of?
Hey @jefflenz! After briefly looking at your stacktrace, it seems that your Search Engine might still be set to Mysql. Can you confirm what this setting is set to:
Stores > Configuration > Catalog > Catalog > Catalog Search > Search Engine
This external module overrides the Elastic Search adapters to replace the product collection to be queried from Algolia. Additionally, searching through your stacktrace, I did not find anything associated to our Algolia extensions. I might be that you just need to reindex the catalogsearch_fulltext indexer.
Can you confirm your Search Engine settings?
Strange, it was set to "Elasticsearch 6+", however, after swapping it to "Elasticsearch" I'm getting a new error:
Error: Call to a member function create() on null in /home/jeff/workspace/sites/summit-safety/vendor/algolia/algoliasearch-magento-2-es-compatibility/Adapter/AlgoliaElasticSearchAdapter.php on line 65
--
1 | 0.0000 | 414680 | {main}( ) | .../index.php:0
2 | 0.0477 | 6752288 | Magento\Framework\App\Bootstrap->run( ) | .../index.php:40
3 | 0.0506 | 7666184 | Magento\Framework\App\Http\Interceptor->launch( ) | .../Bootstrap.php:261
4 | 0.0506 | 7668464 | Magento\Framework\App\Http\Interceptor->launch( ) | .../Interceptor.php:24
5 | 0.0880 | 11286592 | Magento\Framework\App\FrontController\Interceptor->dispatch( ) | .../Http.php:137
6 | 0.0883 | 11304864 | Magento\Framework\App\FrontController\Interceptor->___callPlugins( ) | .../Interceptor.php:26
7 | 0.0883 | 11305832 | Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure:/home/jeff/workspace/sites/summit-safety/vendor/magento/framework/Interception/Interceptor.php:104-151}( ) | .../Interceptor.php:153
8 | 0.0896 | 11350864 | Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch( ) | .../Interceptor.php:135
9 | 0.1119 | 14459576 | Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure:/home/jeff/workspace/sites/summit-safety/vendor/magento/framework/Interception/Interceptor.php:104-151}( ) | .../BuiltinPlugin.php:73
10 | 0.1125 | 14497464 | Fastly\Cdn\Model\FrontControllerPlugin->aroundDispatch( ) | .../Interceptor.php:135
11 | 0.1126 | 14500664 | Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure:/home/jeff/workspace/sites/summit-safety/vendor/magento/framework/Interception/Interceptor.php:104-151}( ) | .../FrontControllerPlugin.php:120
12 | 0.1141 | 14597984 | Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch( ) | .../Interceptor.php:135
13 | 0.1151 | 14619496 | Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure:/home/jeff/workspace/sites/summit-safety/vendor/magento/framework/Interception/Interceptor.php:104-151}( ) | .../RequestPreprocessor.php:94
14 | 0.1151 | 14619912 | Magento\Framework\App\FrontController\Interceptor->___callParent( ) | .../Interceptor.php:138
15 | 0.1151 | 14619912 | Magento\Framework\App\FrontController\Interceptor->dispatch( ) | .../Interceptor.php:58
16 | 0.1346 | 16601336 | Magento\Framework\App\FrontController\Interceptor->processRequest( ) | .../FrontController.php:99
17 | 0.1352 | 16682152 | Magento\CatalogSearch\Controller\Result\Index\Interceptor->dispatch( ) | .../FrontController.php:159
18 | 0.1355 | 16704616 | Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callPlugins( ) | .../Interceptor.php:39
19 | 0.1355 | 16705584 | Magento\CatalogSearch\Controller\Result\Index\Interceptor->Magento\Framework\Interception\{closure:/home/jeff/workspace/sites/summit-safety/vendor/magento/framework/Interception/Interceptor.php:104-151}( ) | .../Interceptor.php:153
20 | 0.1546 | 18664952 | Magento\CustomerSegment\Model\App\Action\ContextPlugin->aroundDispatch( ) | .../Interceptor.php:135
21 | 0.1546 | 18666776 | Magento\CatalogSearch\Controller\Result\Index\Interceptor->Magento\Framework\Interception\{closure:/home/jeff/workspace/sites/summit-safety/vendor/magento/framework/Interception/Interceptor.php:104-151}( ) | .../ContextPlugin.php:81
22 | 0.1546 | 18667192 | Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callParent( ) | .../Interceptor.php:138
23 | 0.1546 | 18667192 | Magento\CatalogSearch\Controller\Result\Index\Interceptor->dispatch( ) | .../Interceptor.php:58
24 | 0.1576 | 18855672 | Magento\CatalogSearch\Controller\Result\Index\Interceptor->execute( ) | .../Action.php:108
25 | 0.1576 | 18855672 | Magento\CatalogSearch\Controller\Result\Index\Interceptor->execute( ) | .../Interceptor.php:24
26 | 0.2300 | 19854888 | Magento\CatalogSearch\Controller\Result\Index\Interceptor->getNotCacheableResult( ) | .../Index.php:110
27 | 0.5297 | 53333600 | Magento\Framework\App\View->renderLayout( ) | .../Index.php:168
28 | 0.5320 | 53724936 | Magento\Framework\View\Result\Page\Interceptor->renderResult( ) | .../View.php:221
29 | 0.5320 | 53725312 | Magento\Framework\View\Result\Page\Interceptor->___callPlugins( ) | .../Interceptor.php:130
30 | 0.5320 | 53726280 | Magento\Framework\View\Result\Page\Interceptor->Magento\Framework\Interception\{closure:/home/jeff/workspace/sites/summit-safety/vendor/magento/framework/Interception/Interceptor.php:104-151}( ) | .../Interceptor.php:153
31 | 0.5321 | 53727160 | Magento\Framework\View\Result\Page\Interceptor->___callParent( ) | .../Interceptor.php:138
32 | 0.5321 | 53727160 | Magento\Framework\View\Result\Page\Interceptor->renderResult( ) | .../Interceptor.php:58
33 | 0.5321 | 53727160 | Magento\Framework\View\Result\Page\Interceptor->render( ) | .../Layout.php:171
34 | 0.5600 | 56709288 | Magento\Framework\View\Layout\Interceptor->getOutput( ) | .../Page.php:258
35 | 0.5600 | 56709344 | Magento\Framework\View\Layout\Interceptor->___callPlugins( ) | .../Interceptor.php:494
36 | 0.5600 | 56710312 | Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure:/home/jeff/workspace/sites/summit-safety/vendor/magento/framework/Interception/Interceptor.php:104-151}( ) | .../Interceptor.php:153
37 | 0.5600 | 56710408 | Magento\Framework\View\Layout\Interceptor->___callParent( ) | .../Interceptor.php:138
38 | 0.5600 | 56710408 | Magento\Framework\View\Layout\Interceptor->getOutput( ) | .../Interceptor.php:58
39 | 0.5600 | 56710408 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Layout.php:954
40 | 0.5600 | 56710408 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Interceptor.php:193
41 | 0.5601 | 56710408 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Layout.php:488
42 | 0.5601 | 56710408 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Interceptor.php:206
43 | 0.5601 | 56710408 | Magento\Framework\View\Layout\Interceptor->_renderContainer( ) | .../Layout.php:535
44 | 0.5813 | 56849584 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Layout.php:585
45 | 0.5813 | 56849584 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Interceptor.php:193
46 | 0.5813 | 56849584 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Layout.php:488
47 | 0.5813 | 56849584 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Interceptor.php:206
48 | 0.5813 | 56849584 | Magento\Framework\View\Layout\Interceptor->_renderContainer( ) | .../Layout.php:535
49 | 0.6277 | 58371160 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Layout.php:585
50 | 0.6277 | 58371160 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Interceptor.php:193
51 | 0.6277 | 58371160 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Layout.php:488
52 | 0.6277 | 58371160 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Interceptor.php:206
53 | 0.6277 | 58371160 | Magento\Framework\View\Layout\Interceptor->_renderContainer( ) | .../Layout.php:535
54 | 0.6325 | 58378832 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Layout.php:585
55 | 0.6325 | 58378832 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Interceptor.php:193
56 | 0.6325 | 58378832 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Layout.php:488
57 | 0.6325 | 58378832 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Interceptor.php:206
58 | 0.6325 | 58378832 | Magento\Framework\View\Layout\Interceptor->_renderContainer( ) | .../Layout.php:535
59 | 0.6325 | 58379208 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Layout.php:585
60 | 0.6325 | 58379208 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Interceptor.php:193
61 | 0.6325 | 58379208 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Layout.php:488
62 | 0.6325 | 58379208 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Interceptor.php:206
63 | 0.6325 | 58379208 | Magento\Framework\View\Layout\Interceptor->_renderContainer( ) | .../Layout.php:535
64 | 0.6327 | 58379616 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Layout.php:585
65 | 0.6327 | 58379616 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Interceptor.php:193
66 | 0.6327 | 58379616 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Layout.php:488
67 | 0.6327 | 58379616 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Interceptor.php:206
68 | 0.6328 | 58379616 | Magento\Framework\View\Layout\Interceptor->_renderContainer( ) | .../Layout.php:535
69 | 0.6483 | 58533784 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Layout.php:585
70 | 0.6483 | 58533784 | Magento\Framework\View\Layout\Interceptor->renderElement( ) | .../Interceptor.php:193
71 | 0.6483 | 58533784 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Layout.php:488
72 | 0.6483 | 58533784 | Magento\Framework\View\Layout\Interceptor->renderNonCachedElement( ) | .../Interceptor.php:206
73 | 0.6483 | 58533784 | Magento\Framework\View\Layout\Interceptor->_renderBlock( ) | .../Layout.php:533
74 | 0.6483 | 58533784 | Magento\CatalogSearch\Block\Result->toHtml( ) | .../Layout.php:557
75 | 0.6484 | 58533832 | Magento\CatalogSearch\Block\Result->_loadCache( ) | .../AbstractBlock.php:671
76 | 0.6484 | 58534152 | Magento\CatalogSearch\Block\Result->Magento\Framework\View\Element\{closure:/home/jeff/workspace/sites/summit-safety/vendor/magento/framework/View/Element/AbstractBlock.php:1088-1095}( ) | .../AbstractBlock.php:1098
77 | 0.6484 | 58534152 | Magento\CatalogSearch\Block\Result->_toHtml( ) | .../AbstractBlock.php:1094
78 | 0.6486 | 58534328 | Magento\CatalogSearch\Block\Result->fetchView( ) | .../Template.php:301
79 | 0.6487 | 58534600 | Magento\Framework\View\TemplateEngine\Php->render( ) | .../Template.php:271
80 | 0.6487 | 58558152 | include( '/home/jeff/workspace/sites/summit-safety/vendor/magento/module-catalog-search/view/frontend/templates/result.phtml' ) | .../Php.php:59
81 | 0.6487 | 58558152 | Magento\CatalogSearch\Block\Result->getResultCount( ) | .../result.phtml:10
82 | 0.6487 | 58558152 | Magento\CatalogSearch\Block\Result->_getProductCollection( ) | .../Result.php:206
83 | 0.6488 | 58558152 | Magento\Catalog\Block\Product\ListProduct\Interceptor->getLoadedProductCollection( ) | .../Result.php:182
84 | 0.6488 | 58558152 | Magento\Catalog\Block\Product\ListProduct\Interceptor->getLoadedProductCollection( ) | .../Interceptor.php:37
85 | 0.6488 | 58558152 | Magento\Catalog\Block\Product\ListProduct\Interceptor->_getProductCollection( ) | .../ListProduct.php:139
86 | 0.6488 | 58558152 | Magento\Catalog\Block\Product\ListProduct\Interceptor->initializeProductCollection( ) | .../ListProduct.php:116
87 | 0.6991 | 59910304 | Magento\Staging\Model\Event\Manager\Proxy->dispatch( ) | .../ListProduct.php:482
88 | 0.6991 | 59910304 | Magento\Staging\Model\Event\Manager->dispatch( ) | .../Proxy.php:95
89 | 0.6991 | 59911312 | Magento\Framework\Event\Invoker\InvokerDefault->dispatch( ) | .../Manager.php:97
90 | 0.6992 | 59917152 | Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod( ) | .../InvokerDefault.php:74
91 | 0.6992 | 59917152 | Magento\Review\Observer\CatalogBlockProductCollectionBeforeToHtmlObserver->execute( ) | .../InvokerDefault.php:88
92 | 0.6992 | 59917232 | Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->load( ) | .../CatalogBlockProductCollectionBeforeToHtmlObserver.php:42
93 | 0.6993 | 59917288 | Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->___callPlugins( ) | .../Interceptor.php:338
94 | 0.6993 | 59918256 | Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->Magento\Framework\Interception\{closure:/home/jeff/workspace/sites/summit-safety/vendor/magento/framework/Interception/Interceptor.php:104-151}( ) | .../Interceptor.php:153
95 | 0.7107 | 60605008 | Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->___callParent( ) | .../Interceptor.php:138
96 | 0.7107 | 60605008 | Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->load( ) | .../Interceptor.php:58
97 | 0.7107 | 60605008 | Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->load( ) | .../Collection.php:803
98 | 0.7108 | 60605008 | Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->_renderFilters( ) | .../AbstractCollection.php:923
99 | 0.7108 | 60605008 | Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->_renderFilters( ) | .../Collection.php:534
100 | 0.7108 | 60605008 | Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->_renderFiltersBefore( ) | .../AbstractDb.php:343
101 | 0.7117 | 60683296 | Magento\Search\Model\Search->search( ) | .../Collection.php:436
102 | 0.7143 | 60891824 | Magento\Search\Model\SearchEngine->search( ) | .../Search.php:85
103 | 0.7222 | 61634232 | Algolia\AlgoliaSearchElastic\Adapter\AlgoliaElasticSearchAdapter->query( ) | .../SearchEngine.php:42
Thanks for following up. What version of elasticsearch is installed in your environment? I would match your Search Engine to the version you are utilizing. If it is elasticsearch v6, then you should configure it to Elastic Search 6 +.
If and when you switch the search engines, I would clear your cache to update the configuration and run the catalogsearch_fulltext indexer.
Let me know if this error clears up for you as this one might be related to a mismatched version.
Yes I'm using ES 6.1.4. Not sure why it's not using it when I select it from the Magento admin. When I select the option for just "Elasticsearch" it starts using it. I will debug further and followup, thanks for the help so far!
So it is indeed using Elasticsearch, I confirmed by turning off ES and seeing no results, turning it back on and then seeing results. I can also confirm disabling the algolia es compatibility extension makes the error go away and the page loads as normal. I'm currently not available to spend a lot of time debugging why.
Has the extension been tested on a clean Enterprise 2.3.2?
I have tested this on Commerce 2.3.2 and on the cloud environment that is using elasticsearch v 6 with Elasticsearch 6+ configure as Magento's Search Engine. Would it be possible to get the version of the elasticsearch php client installed in composer? The package name is: elasticsearch/elasticsearch
. I would like it if it was set to match the version of elasticsearch you are using in your environment.
You can read more about how to configure Elasticsearch in this doc: https://devdocs.magento.com/guides/v2.3/config-guide/elasticsearch/es-downgrade.html
I'll take a deeper look at the error further but your version of elasticsearch should be Elasticsearch 6+.
It's using ElasticSearch 6 with 6+ configured in admin. I also deployed to our cloud environment which is also using ES and same error. Perhaps our Algolia settings are different.
I also disabled all 3rd-party extensions/reindexed to rule that out
Some search terms work, where others produce the error. I'm not quite sure why. Would you be able to take a look at our setup if I provided you credentials?
Hey @jefflenz! Yes, that would be great. You can send your information over to support@algolia.com and mention me in your request so that it is dispatched to the Magento team.
If you can also send over the search terms that are throwing errors and links to these results.
Thanks!
Apologies, our staging server is undergoing maintenance- however, I did notice a correlation: If the product count exceeds a few hundred it seems to error out. Will be in touch with credentials to staging site.
Haven't tested on open source, but this extension does not work on commerce/enterprise 2.3.2. There's an SQL syntax error on the ORDER BY clause:
Currently, it's trying to do (Note the backticks):
This should instead be: