{"action":"opened","issue":{"url":"https://api.github.com/repos/Smile-SA/elasticsuite/issues/466","repository_url":"https://api.github.com/repos/Smile-SA/elasticsuite","labels_url":"https://api.github.com/repos/Smile-SA/elasticsuite/issues/466/labels{/name}","comments_url":"https://api.github.com/repos/Smile-SA/elasticsuite/issues/466/comments","events_url":"https://api.github.com/repos/Smile-SA/elasticsuite/issues/466/events","html_url":"https://github.com/Smile-SA/elasticsuite/issues/466","id":241201253,"number":466,"title":"Catalog search indexer process unknown error : SQLstate 42S22 Column not found 1054 unknown column error","user":{"login":"sugapriyanavamani","id":29648582,"avatar_url":"https://avatars1.githubusercontent.com/u/29648582?v=3","gravatar_id":"","url":"https://api.github.com/users/sugapriyanavamani","html_url":"https://github.com/sugapriyanavamani","followers_url":"https://api.github.com/users/sugapriyanavamani/followers","following_url":"https://api.github.com/users/sugapriyanavamani/following{/other_user}","gists_url":"https://api.github.com/users/sugapriyanavamani/gists{/gist_id}","starred_url":"https://api.github.com/users/sugapriyanavamani/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sugapriyanavamani/subscriptions","organizations_url":"https://api.github.com/users/sugapriyanavamani/orgs","repos_url":"https://api.github.com/users/sugapriyanavamani/repos","events_url":"https://api.github.com/users/sugapriyanavamani/events{/privacy}","received_events_url":"https://api.github.com/users/sugapriyanavamani/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-07-07T08:59:49Z","updated_at":"2017-07-07T08:59:49Z","closed_at":null,"body":"Catalog search indexer process unknown error : SQLstate 42S22 Column not found 1054 unknown column error\r\n\r\n### Preconditions\r\n<!--- Please Provide detailed informations about the environment you use -->\r\nMagento CE 2.1.7\r\n\r\n\r\n\r\n<!-- ElasticSuite Version : Which exact version of ElasticSuite are you using ? -->\r\nElasticSuite Version : 2.3.0\r\n\r\n<!-- Magento Environment : are you in Developer or Production mode ? -->\r\nEnvironment : Development mode\r\n\r\n<!-- Third party modules : are you using any third party modules ? If yes, please attach the list -->\r\nThird party modules : No\r\n\r\n### Steps to reproduce\r\n<!--- Provide a set of unambiguous steps to reproduce this bug. You can also include pieces of code if you think it's relevant  -->\r\n1. installed elastic search 2.4.5 and relevant plugins, started the server\r\n2. installed elastic suite 2.3.0 \r\n3. run reindexing \r\n\r\n### Expected result\r\n<!--- Tell us what should happen -->\r\n1. reindexing should be successful\r\n\r\n### Actual result\r\n<!--- Tell us what happens instead -->\r\n1.getting following error when reindexing\r\n\r\nC:\\wamp64\\bin\\php\\php7.0.10>php C:\\wamp64\\www\\magento1\\bin\\magento index:reindex\r\n\r\nDesign Config Grid index has been rebuilt successfully in 00:00:06\r\nCustomer Grid index has been rebuilt successfully in 00:00:06\r\nCategory Products index has been rebuilt successfully in 00:00:02\r\nProduct Categories index has been rebuilt successfully in 00:00:00\r\nProduct Price index has been rebuilt successfully in 00:00:09\r\nProduct EAV index has been rebuilt successfully in 00:00:05\r\nCatalog Search indexer process unknown error:\r\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'use_name_store_value.val\r\nue' in 'field list', query was: SELECT `cat`.`entity_id`, COALESCE(store_value.v\r\nalue,default_value.value) AS `name`, COALESCE(use_name_store_value.value,use_nam\r\ne_default_value.value,1) AS `use_name` FROM `catalog_category_entity` AS `cat`\r\n INNER JOIN `catalog_category_entity_varchar` AS `default_value` ON cat.entity_i\r\nd = default_value.entity_id\r\n LEFT JOIN `catalog_category_entity` AS `use_name_default_value` ON default_valu\r\ne.entity_id = use_name_default_value.entity_id AND use_name_default_value.attrib\r\nute_id = 0 AND use_name_default_value.store_id = 0\r\n LEFT JOIN `catalog_category_entity_varchar` AS `store_value` ON default_value.e\r\nntity_id = store_value.entity_id AND store_value.attribute_id = 45 AND store_val\r\nue.store_id = 1\r\n LEFT JOIN `catalog_category_entity` AS `use_name_store_value` ON default_value.\r\nentity_id = use_name_store_value.entity_id AND use_name_store_value.attribute_id\r\n = 0 AND use_name_store_value.store_id = 1 WHERE (cat.entity_id != 2) AND (defau\r\nlt_value.store_id = 0) AND (default_value.attribute_id = 45) AND (cat.entity_id\r\nIN (2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 21, 22, 23, 24,\r\n25, 26, 27, 28, 30, 31, 32, 33, 34, 35, 36))\r\nStock index has been rebuilt successfully in 00:00:03\r\nCatalog Rule Product index has been rebuilt successfully in 00:00:04\r\nCatalog Product Rule index has been rebuilt successfully in 00:00:00\r\nElasticSuite Category Indexing index has been rebuilt successfully in 00:00:01\r\nElasticSuite Thesaurus Indexing index has been rebuilt successfully in 00:00:00\r\n\r\n\r\n<!--- (This may be platform independent comment) -->\r\n"}}
{"actor":{"display_login":"sugapriyanavamani"}}