{"action":"created","issue":{"url":"https://api.github.com/repos/firegento/firegento-magesetup/issues/326","repository_url":"https://api.github.com/repos/firegento/firegento-magesetup","labels_url":"https://api.github.com/repos/firegento/firegento-magesetup/issues/326/labels{/name}","comments_url":"https://api.github.com/repos/firegento/firegento-magesetup/issues/326/comments","events_url":"https://api.github.com/repos/firegento/firegento-magesetup/issues/326/events","html_url":"https://github.com/firegento/firegento-magesetup/issues/326","id":306478020,"number":326,"title":"SQL Fehler im Checkout","user":{"login":"twosg","id":325412,"avatar_url":"https://avatars0.githubusercontent.com/u/325412?v=4","gravatar_id":"","url":"https://api.github.com/users/twosg","html_url":"https://github.com/twosg","followers_url":"https://api.github.com/users/twosg/followers","following_url":"https://api.github.com/users/twosg/following{/other_user}","gists_url":"https://api.github.com/users/twosg/gists{/gist_id}","starred_url":"https://api.github.com/users/twosg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/twosg/subscriptions","organizations_url":"https://api.github.com/users/twosg/orgs","repos_url":"https://api.github.com/users/twosg/repos","events_url":"https://api.github.com/users/twosg/events{/privacy}","received_events_url":"https://api.github.com/users/twosg/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-03-19T14:09:06Z","updated_at":"2018-03-19T14:26:07Z","closed_at":"2018-03-19T14:26:07Z","author_association":"NONE","body":"Nach Update auf 2.4.2 erhalte ich folgende Meldung im Checkout:\r\n\r\n```\r\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'position' in 'order clause', query was: \r\n\r\nSELECT `main_table`.* FROM `checkout_agreement` AS `main_table`\r\nINNER JOIN `checkout_agreement_store` AS `store_table_2` ON main_table.agreement_id = store_table_2.agreement_id \r\nWHERE (store_table_2.store_id IN ('2', 0)) AND (`is_active` = '1') \r\nGROUP BY `main_table`.`agreement_id` ORDER BY position ASC\r\n```\r\n\r\nDas passiert aufgrund einer Änderung in der /app/code/community/FireGento/MageSetup/Model/Observer.php, Zeile 81:\r\n\r\n`$agreements->setOrder('position', Varien_Data_Collection::SORT_ORDER_ASC);`.\r\n\r\nAuskommentieren löst das Problem und ich sehe auch keine Nachteile dadurch."},"comment":{"url":"https://api.github.com/repos/firegento/firegento-magesetup/issues/comments/374230360","html_url":"https://github.com/firegento/firegento-magesetup/issues/326#issuecomment-374230360","issue_url":"https://api.github.com/repos/firegento/firegento-magesetup/issues/326","id":374230360,"user":{"login":"twosg","id":325412,"avatar_url":"https://avatars0.githubusercontent.com/u/325412?v=4","gravatar_id":"","url":"https://api.github.com/users/twosg","html_url":"https://github.com/twosg","followers_url":"https://api.github.com/users/twosg/followers","following_url":"https://api.github.com/users/twosg/following{/other_user}","gists_url":"https://api.github.com/users/twosg/gists{/gist_id}","starred_url":"https://api.github.com/users/twosg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/twosg/subscriptions","organizations_url":"https://api.github.com/users/twosg/orgs","repos_url":"https://api.github.com/users/twosg/repos","events_url":"https://api.github.com/users/twosg/events{/privacy}","received_events_url":"https://api.github.com/users/twosg/received_events","type":"User","site_admin":false},"created_at":"2018-03-19T14:26:07Z","updated_at":"2018-03-19T14:26:07Z","author_association":"NONE","body":"Stimmt - das lief wohl bei mir nicht, sorry :)"}}
{"actor":{"display_login":"twosg"}}