{"action":"closed","issue":{"url":"https://api.github.com/repos/Smile-SA/elasticsuite/issues/106","repository_url":"https://api.github.com/repos/Smile-SA/elasticsuite","labels_url":"https://api.github.com/repos/Smile-SA/elasticsuite/issues/106/labels{/name}","comments_url":"https://api.github.com/repos/Smile-SA/elasticsuite/issues/106/comments","events_url":"https://api.github.com/repos/Smile-SA/elasticsuite/issues/106/events","html_url":"https://github.com/Smile-SA/elasticsuite/issues/106","id":176015599,"number":106,"title":"Column not found: 1054 Unknown column 'entity_id'","user":{"login":"bery","id":1456931,"avatar_url":"https://avatars.githubusercontent.com/u/1456931?v=3","gravatar_id":"","url":"https://api.github.com/users/bery","html_url":"https://github.com/bery","followers_url":"https://api.github.com/users/bery/followers","following_url":"https://api.github.com/users/bery/following{/other_user}","gists_url":"https://api.github.com/users/bery/gists{/gist_id}","starred_url":"https://api.github.com/users/bery/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bery/subscriptions","organizations_url":"https://api.github.com/users/bery/orgs","repos_url":"https://api.github.com/users/bery/repos","events_url":"https://api.github.com/users/bery/events{/privacy}","received_events_url":"https://api.github.com/users/bery/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Smile-SA/elasticsuite/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"afoucret","id":529238,"avatar_url":"https://avatars.githubusercontent.com/u/529238?v=3","gravatar_id":"","url":"https://api.github.com/users/afoucret","html_url":"https://github.com/afoucret","followers_url":"https://api.github.com/users/afoucret/followers","following_url":"https://api.github.com/users/afoucret/following{/other_user}","gists_url":"https://api.github.com/users/afoucret/gists{/gist_id}","starred_url":"https://api.github.com/users/afoucret/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/afoucret/subscriptions","organizations_url":"https://api.github.com/users/afoucret/orgs","repos_url":"https://api.github.com/users/afoucret/repos","events_url":"https://api.github.com/users/afoucret/events{/privacy}","received_events_url":"https://api.github.com/users/afoucret/received_events","type":"User","site_admin":false},"assignees":[{"login":"afoucret","id":529238,"avatar_url":"https://avatars.githubusercontent.com/u/529238?v=3","gravatar_id":"","url":"https://api.github.com/users/afoucret","html_url":"https://github.com/afoucret","followers_url":"https://api.github.com/users/afoucret/followers","following_url":"https://api.github.com/users/afoucret/following{/other_user}","gists_url":"https://api.github.com/users/afoucret/gists{/gist_id}","starred_url":"https://api.github.com/users/afoucret/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/afoucret/subscriptions","organizations_url":"https://api.github.com/users/afoucret/orgs","repos_url":"https://api.github.com/users/afoucret/repos","events_url":"https://api.github.com/users/afoucret/events{/privacy}","received_events_url":"https://api.github.com/users/afoucret/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/Smile-SA/elasticsuite/milestones/2","html_url":"https://github.com/Smile-SA/elasticsuite/milestones/2.2","labels_url":"https://api.github.com/repos/Smile-SA/elasticsuite/milestones/2/labels","id":1809840,"number":2,"title":"2.2","description":null,"creator":{"login":"afoucret","id":529238,"avatar_url":"https://avatars.githubusercontent.com/u/529238?v=3","gravatar_id":"","url":"https://api.github.com/users/afoucret","html_url":"https://github.com/afoucret","followers_url":"https://api.github.com/users/afoucret/followers","following_url":"https://api.github.com/users/afoucret/following{/other_user}","gists_url":"https://api.github.com/users/afoucret/gists{/gist_id}","starred_url":"https://api.github.com/users/afoucret/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/afoucret/subscriptions","organizations_url":"https://api.github.com/users/afoucret/orgs","repos_url":"https://api.github.com/users/afoucret/repos","events_url":"https://api.github.com/users/afoucret/events{/privacy}","received_events_url":"https://api.github.com/users/afoucret/received_events","type":"User","site_admin":false},"open_issues":11,"closed_issues":11,"state":"open","created_at":"2016-06-06T04:52:25Z","updated_at":"2016-09-23T09:32:28Z","due_on":null,"closed_at":null},"comments":10,"created_at":"2016-09-09T13:54:56Z","updated_at":"2016-09-23T09:32:28Z","closed_at":"2016-09-23T09:32:27Z","body":"Hi,\r\n\r\nwhen trying to install Elasticsuite extension on Magento EE 2.1.1 I have ran into an issue when running 'setup:upgrade' command. I believe that this is related to the staging feature introduced in Magento EE 2.1. and changes in column names that came with this change - e.g. renaming entit_id to row_id\r\n\r\n```[Zend_Db_Statement_Exception]\r\n  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity_id' in 'field list', query was: INSERT INTO `catalog_category_entity_int` (`attribute_id`, `entity_id`, `value`) SELECT 211 as attribute_id, `catalog_category_entity`.`row_id`, 1 as value FROM `catalog_c\r\n  ategory_entity` WHERE (catalog_category_entity.created_in <= 1) AND (catalog_category_entity.updated_in > 1) ON DUPLICATE KEY UPDATE `attribute_id` = VALUES(`attribute_id`), `entity_id` = VALUES(`entity_id`), `value` = VALUES(`value`)\r\n\r\n  [PDOException]\r\n  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity_id' in 'field list'```\r\n\r\nchaning lines [145](https://github.com/Smile-SA/elasticsuite/blob/master/src/module-elasticsuite-catalog/Setup/InstallData.php#L145) and [149](https://github.com/Smile-SA/elasticsuite/blob/master/src/module-elasticsuite-catalog/Setup/InstallData.php#L149) from entity_id to row_id solved my issue.\r\n\r\n[Related issue](https://github.com/magento/magento2/issues/6478) in Magento 2 queue in case somebody is looking into similar errors \r\n\r\n\r\n\r\n\r\n"}}
{"actor":{"display_login":"romainruaud"}}