{"action":"created","issue":{"url":"https://api.github.com/repos/snipe/snipe-it/issues/1430","labels_url":"https://api.github.com/repos/snipe/snipe-it/issues/1430/labels{/name}","comments_url":"https://api.github.com/repos/snipe/snipe-it/issues/1430/comments","events_url":"https://api.github.com/repos/snipe/snipe-it/issues/1430/events","html_url":"https://github.com/snipe/snipe-it/issues/1430","id":119985569,"number":1430,"title":"General error: 1005 Can't create table 'snipeit.#sql-70e_cb3'","user":{"login":"chrisrbmn","id":5017742,"avatar_url":"https://avatars.githubusercontent.com/u/5017742?v=3","gravatar_id":"","url":"https://api.github.com/users/chrisrbmn","html_url":"https://github.com/chrisrbmn","followers_url":"https://api.github.com/users/chrisrbmn/followers","following_url":"https://api.github.com/users/chrisrbmn/following{/other_user}","gists_url":"https://api.github.com/users/chrisrbmn/gists{/gist_id}","starred_url":"https://api.github.com/users/chrisrbmn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chrisrbmn/subscriptions","organizations_url":"https://api.github.com/users/chrisrbmn/orgs","repos_url":"https://api.github.com/users/chrisrbmn/repos","events_url":"https://api.github.com/users/chrisrbmn/events{/privacy}","received_events_url":"https://api.github.com/users/chrisrbmn/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":17,"created_at":"2015-12-02T16:47:17Z","updated_at":"2015-12-02T21:33:59Z","closed_at":null,"body":"Hi all,\r\nI just tried to run the 2.0.6 upgrade, and ran across this error.\r\n![2015-12-02_10-41-55](https://cloud.githubusercontent.com/assets/5017742/11537166/606306ca-98e1-11e5-8ddb-36724e0d653e.png)\r\n\r\nHere are the steps I ran, on my centos 6.7 server.\r\n----------\r\nfrom /var/www/snipeit\r\n\r\ngit stash\r\n\r\ngit pull\r\n\r\nphp composer.phar install\r\n\r\nphp composer.phar dump-autoload\r\n\r\nphp artisan migrate\r\n----------\r\n\r\nDid I do the upgrade correctly? or something else?\r\nI don't see any visible issue, unless I go edit something on the settings page.. If I try to change the currency option to US Dollar's, (which is defaulted to TWD - Taiwan New Dollars),  I get a 500 error.\r\n![2015-12-02_10-45-49](https://cloud.githubusercontent.com/assets/5017742/11537280/ee460a32-98e1-11e5-983f-3694989ee3a8.png)\r\n\r\nThanks for your help all,\r\nChris\r\n"},"comment":{"url":"https://api.github.com/repos/snipe/snipe-it/issues/comments/161440714","html_url":"https://github.com/snipe/snipe-it/issues/1430#issuecomment-161440714","issue_url":"https://api.github.com/repos/snipe/snipe-it/issues/1430","id":161440714,"user":{"login":"snipe","id":197404,"avatar_url":"https://avatars.githubusercontent.com/u/197404?v=3","gravatar_id":"","url":"https://api.github.com/users/snipe","html_url":"https://github.com/snipe","followers_url":"https://api.github.com/users/snipe/followers","following_url":"https://api.github.com/users/snipe/following{/other_user}","gists_url":"https://api.github.com/users/snipe/gists{/gist_id}","starred_url":"https://api.github.com/users/snipe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/snipe/subscriptions","organizations_url":"https://api.github.com/users/snipe/orgs","repos_url":"https://api.github.com/users/snipe/repos","events_url":"https://api.github.com/users/snipe/events{/privacy}","received_events_url":"https://api.github.com/users/snipe/received_events","type":"User","site_admin":false},"created_at":"2015-12-02T21:33:59Z","updated_at":"2015-12-02T21:33:59Z","body":"(This foreign key nonsense is exactly why I never use foreign keys. They always seem like a good idea but always end in tears.)"}}