{"action":"created","issue":{"url":"https://api.github.com/repos/xibosignage/xibo/issues/169","labels_url":"https://api.github.com/repos/xibosignage/xibo/issues/169/labels{/name}","comments_url":"https://api.github.com/repos/xibosignage/xibo/issues/169/comments","events_url":"https://api.github.com/repos/xibosignage/xibo/issues/169/events","html_url":"https://github.com/xibosignage/xibo/issues/169","id":56789614,"number":169,"title":"upgrade 1.6.4 to 1.7.0 mysql error","user":{"login":"lpadumorvan","id":10880018,"avatar_url":"https://avatars.githubusercontent.com/u/10880018?v=3","gravatar_id":"","url":"https://api.github.com/users/lpadumorvan","html_url":"https://github.com/lpadumorvan","followers_url":"https://api.github.com/users/lpadumorvan/followers","following_url":"https://api.github.com/users/lpadumorvan/following{/other_user}","gists_url":"https://api.github.com/users/lpadumorvan/gists{/gist_id}","starred_url":"https://api.github.com/users/lpadumorvan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lpadumorvan/subscriptions","organizations_url":"https://api.github.com/users/lpadumorvan/orgs","repos_url":"https://api.github.com/users/lpadumorvan/repos","events_url":"https://api.github.com/users/lpadumorvan/events{/privacy}","received_events_url":"https://api.github.com/users/lpadumorvan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-02-06T09:29:16Z","updated_at":"2015-02-06T16:31:49Z","closed_at":null,"body":"I will upgrade xibo 1.6.4 to 1.7.0. It gives this:\r\nAn error occurred running the upgrade. Please take a screen shot of this page and seek help. Statement number: 80. Error Message = [SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '9' for key 'PRIMARY']\r\n\r\nThen if I press \"next\" button, I have this:\r\nAn error occurred running the upgrade. Please take a screen shot of this page and seek help. Statement number: 80. Error Message = [SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'render_as']\r\n"},"comment":{"url":"https://api.github.com/repos/xibosignage/xibo/issues/comments/73265127","html_url":"https://github.com/xibosignage/xibo/issues/169#issuecomment-73265127","issue_url":"https://api.github.com/repos/xibosignage/xibo/issues/169","id":73265127,"user":{"login":"lpadumorvan","id":10880018,"avatar_url":"https://avatars.githubusercontent.com/u/10880018?v=3","gravatar_id":"","url":"https://api.github.com/users/lpadumorvan","html_url":"https://github.com/lpadumorvan","followers_url":"https://api.github.com/users/lpadumorvan/followers","following_url":"https://api.github.com/users/lpadumorvan/following{/other_user}","gists_url":"https://api.github.com/users/lpadumorvan/gists{/gist_id}","starred_url":"https://api.github.com/users/lpadumorvan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lpadumorvan/subscriptions","organizations_url":"https://api.github.com/users/lpadumorvan/orgs","repos_url":"https://api.github.com/users/lpadumorvan/repos","events_url":"https://api.github.com/users/lpadumorvan/events{/privacy}","received_events_url":"https://api.github.com/users/lpadumorvan/received_events","type":"User","site_admin":false},"created_at":"2015-02-06T16:31:49Z","updated_at":"2015-02-06T16:31:49Z","body":"I download now. I start the installation again and I have this :\r\nAn error occurred running the upgrade. Please take a screen shot of this page and seek help. Statement number: 80. Error Message = [SQLSTATE[42S01]: Base table or view already exists: 1050 Table '`xibo`.`displayprofile`' already exists]\r\nUpgrading from database version 72 to 84\r\n\r\nI press the \"next\" button and I have this:\r\nAn error occurred running the upgrade. Please take a screen shot of this page and seek help. Statement number: 80. Error Message = [SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'render_as']\r\nUpgrading from database version 72 to 84\r\n\r\n"}}