{"action":"created","issue":{"url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/117","labels_url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/117/labels{/name}","comments_url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/117/comments","events_url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/117/events","html_url":"https://github.com/OpenUpgrade/OpenUpgrade/pull/117","id":47020324,"number":117,"title":"8.0 'mrp' (dev)","user":{"login":"legalsylvain","id":3407482,"avatar_url":"https://avatars.githubusercontent.com/u/3407482?v=3","gravatar_id":"","url":"https://api.github.com/users/legalsylvain","html_url":"https://github.com/legalsylvain","followers_url":"https://api.github.com/users/legalsylvain/followers","following_url":"https://api.github.com/users/legalsylvain/following{/other_user}","gists_url":"https://api.github.com/users/legalsylvain/gists{/gist_id}","starred_url":"https://api.github.com/users/legalsylvain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/legalsylvain/subscriptions","organizations_url":"https://api.github.com/users/legalsylvain/orgs","repos_url":"https://api.github.com/users/legalsylvain/repos","events_url":"https://api.github.com/users/legalsylvain/events{/privacy}","received_events_url":"https://api.github.com/users/legalsylvain/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/labels/Work%20in%20Progress","name":"Work in Progress","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/milestones/2","html_url":"https://github.com/OpenUpgrade/OpenUpgrade/milestones/8.0","labels_url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/milestones/2/labels","id":834743,"number":2,"title":"8.0","description":"","creator":{"login":"legalsylvain","id":3407482,"avatar_url":"https://avatars.githubusercontent.com/u/3407482?v=3","gravatar_id":"","url":"https://api.github.com/users/legalsylvain","html_url":"https://github.com/legalsylvain","followers_url":"https://api.github.com/users/legalsylvain/followers","following_url":"https://api.github.com/users/legalsylvain/following{/other_user}","gists_url":"https://api.github.com/users/legalsylvain/gists{/gist_id}","starred_url":"https://api.github.com/users/legalsylvain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/legalsylvain/subscriptions","organizations_url":"https://api.github.com/users/legalsylvain/orgs","repos_url":"https://api.github.com/users/legalsylvain/repos","events_url":"https://api.github.com/users/legalsylvain/events{/privacy}","received_events_url":"https://api.github.com/users/legalsylvain/received_events","type":"User","site_admin":false},"open_issues":16,"closed_issues":38,"state":"open","created_at":"2014-10-21T17:03:06Z","updated_at":"2015-03-09T16:15:56Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2014-10-28T12:32:27Z","updated_at":"2015-03-10T20:35:56Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/pulls/117","html_url":"https://github.com/OpenUpgrade/OpenUpgrade/pull/117","diff_url":"https://github.com/OpenUpgrade/OpenUpgrade/pull/117.diff","patch_url":"https://github.com/OpenUpgrade/OpenUpgrade/pull/117.patch"},"body":"\r\n\r\nPort 'mrp' modification realized by OneStein BV. (branch onesteinbv:8.0-os)\r\n"},"comment":{"url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/comments/78142487","html_url":"https://github.com/OpenUpgrade/OpenUpgrade/pull/117#issuecomment-78142487","issue_url":"https://api.github.com/repos/OpenUpgrade/OpenUpgrade/issues/117","id":78142487,"user":{"login":"antiflu","id":1466356,"avatar_url":"https://avatars.githubusercontent.com/u/1466356?v=3","gravatar_id":"","url":"https://api.github.com/users/antiflu","html_url":"https://github.com/antiflu","followers_url":"https://api.github.com/users/antiflu/followers","following_url":"https://api.github.com/users/antiflu/following{/other_user}","gists_url":"https://api.github.com/users/antiflu/gists{/gist_id}","starred_url":"https://api.github.com/users/antiflu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/antiflu/subscriptions","organizations_url":"https://api.github.com/users/antiflu/orgs","repos_url":"https://api.github.com/users/antiflu/repos","events_url":"https://api.github.com/users/antiflu/events{/privacy}","received_events_url":"https://api.github.com/users/antiflu/received_events","type":"User","site_admin":false},"created_at":"2015-03-10T20:35:56Z","updated_at":"2015-03-10T20:35:56Z","body":"Like kunadawa, I got the same error:\r\n\r\n    post-migrate.py: syntax error at or near \"FROM\"\r\n    LINE 5:             FROM mrp_bom_mrp_property_rel bom_rel\r\n\r\nTo solve it, I needed to make the following change to post_migration.py:\r\n\r\n    INSERT INTO mrp_bom_line_mrp_property_rel\r\n    (mrp_bom_line_id, mrp_property_id)\r\n    VALUES(%s, bom_rel.mrp_property_id)\r\n    FROM mrp_bom_mrp_property_rel bom_rel\r\n    WHERE bom_rel.mrp_bom_id = %s\r\n\r\nInto:\r\n\r\n    INSERT INTO mrp_bom_line_mrp_property_rel\r\n    (mrp_bom_line_id, mrp_property_id)\r\n    SELECT %s, bom_rel.mrp_property_id\r\n    FROM mrp_bom_mrp_property_rel bom_rel\r\n    WHERE bom_rel.mrp_bom_id = %s\r\n\r\n"}}