{"action":"created","issue":{"url":"https://api.github.com/repos/xibosignage/xibo/issues/70","labels_url":"https://api.github.com/repos/xibosignage/xibo/issues/70/labels{/name}","comments_url":"https://api.github.com/repos/xibosignage/xibo/issues/70/comments","events_url":"https://api.github.com/repos/xibosignage/xibo/issues/70/events","html_url":"https://github.com/xibosignage/xibo/issues/70","id":55656571,"number":70,"title":"Error when upgrading 1.6.4 to 1.7.0","user":{"login":"RobKeeling","id":10727632,"avatar_url":"https://avatars.githubusercontent.com/u/10727632?v=3","gravatar_id":"","url":"https://api.github.com/users/RobKeeling","html_url":"https://github.com/RobKeeling","followers_url":"https://api.github.com/users/RobKeeling/followers","following_url":"https://api.github.com/users/RobKeeling/following{/other_user}","gists_url":"https://api.github.com/users/RobKeeling/gists{/gist_id}","starred_url":"https://api.github.com/users/RobKeeling/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RobKeeling/subscriptions","organizations_url":"https://api.github.com/users/RobKeeling/orgs","repos_url":"https://api.github.com/users/RobKeeling/repos","events_url":"https://api.github.com/users/RobKeeling/events{/privacy}","received_events_url":"https://api.github.com/users/RobKeeling/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-01-27T18:36:29Z","updated_at":"2015-02-17T15:16:44Z","closed_at":"2015-02-17T14:31:00Z","body":"An error occurred running the upgrade. Please take a screen shot of this page and seek help. Statement number: 80. Error Message = [SQLSTATE[HY000]: General error: 1025 Error on rename of '.\\xibo\\schedule_detail' to '.\\xibo\\#sql2-538-4cf4a' (errno: 152)]\r\n\r\nI have made the change of UTF32 to UTF8 in 82.sql but now get the error above."},"comment":{"url":"https://api.github.com/repos/xibosignage/xibo/issues/comments/74683466","html_url":"https://github.com/xibosignage/xibo/issues/70#issuecomment-74683466","issue_url":"https://api.github.com/repos/xibosignage/xibo/issues/70","id":74683466,"user":{"login":"JELedoux","id":10731154,"avatar_url":"https://avatars.githubusercontent.com/u/10731154?v=3","gravatar_id":"","url":"https://api.github.com/users/JELedoux","html_url":"https://github.com/JELedoux","followers_url":"https://api.github.com/users/JELedoux/followers","following_url":"https://api.github.com/users/JELedoux/following{/other_user}","gists_url":"https://api.github.com/users/JELedoux/gists{/gist_id}","starred_url":"https://api.github.com/users/JELedoux/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JELedoux/subscriptions","organizations_url":"https://api.github.com/users/JELedoux/orgs","repos_url":"https://api.github.com/users/JELedoux/repos","events_url":"https://api.github.com/users/JELedoux/events{/privacy}","received_events_url":"https://api.github.com/users/JELedoux/received_events","type":"User","site_admin":false},"created_at":"2015-02-17T15:16:44Z","updated_at":"2015-02-17T15:16:44Z","body":"Will do.\r\n\r\nThank You,\r\n\r\nJ. Eric Ledoux\r\nLondonderry Police Department\r\n\r\n\r\nFrom: Dan Garner [mailto:notifications@github.com]\r\nSent: Tuesday, February 17, 2015 9:31 AM\r\nTo: xibosignage/xibo\r\nCc: J. Eric Ledoux\r\nSubject: Re: [xibo] Error when upgrading 1.6.4 to 1.7.0 (#70)\r\n\r\n\r\nthere are some instructions towards the end of #177<https://github.com/xibosignage/xibo/issues/177> where we are trying to work out which statement is causing the issue - that would also be useful to know in your case.\r\n\r\nCan you join the other issue and try the suggestions?\r\n\r\n—\r\nReply to this email directly or view it on GitHub<https://github.com/xibosignage/xibo/issues/70#issuecomment-74675627>.\r\n\nConfidentiality Notice: the information contained in this email and any attachments may be legally privileged and confidential. If you are not an intended recipient, you are hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender and permanently delete the e-mail and any attachments immediately. You should not retain, copy or use this e-mail or any attachments for any purpose, nor disclose all or any part of the contents to any other person.\n"}}