{"action":"opened","issue":{"url":"https://api.github.com/repos/xibosignage/xibo/issues/398","labels_url":"https://api.github.com/repos/xibosignage/xibo/issues/398/labels{/name}","comments_url":"https://api.github.com/repos/xibosignage/xibo/issues/398/comments","events_url":"https://api.github.com/repos/xibosignage/xibo/issues/398/events","html_url":"https://github.com/xibosignage/xibo/issues/398","id":59963254,"number":398,"title":"Database problems in the setup wizard","user":{"login":"nspaul","id":812873,"avatar_url":"https://avatars.githubusercontent.com/u/812873?v=3","gravatar_id":"","url":"https://api.github.com/users/nspaul","html_url":"https://github.com/nspaul","followers_url":"https://api.github.com/users/nspaul/followers","following_url":"https://api.github.com/users/nspaul/following{/other_user}","gists_url":"https://api.github.com/users/nspaul/gists{/gist_id}","starred_url":"https://api.github.com/users/nspaul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nspaul/subscriptions","organizations_url":"https://api.github.com/users/nspaul/orgs","repos_url":"https://api.github.com/users/nspaul/repos","events_url":"https://api.github.com/users/nspaul/events{/privacy}","received_events_url":"https://api.github.com/users/nspaul/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-03-05T15:01:01Z","updated_at":"2015-03-05T15:01:01Z","closed_at":null,"body":"When I go through the installation wizard, I can't get past the database setup page. If I choose \"Create a new database\" and give it all the info, it does indeed create the database and the user, but I get the following error at the top of the screen:\r\n\r\n```An error occurred populating the database. Statement number: 90. Error Message = [SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '82, 'LIBRARY_MEDIA_DELETEOLDVER_CHECKB','Unchecked','dropdown','Default the chec' at line 1]. File = [Array]. SQL = [(82, 'LIBRARY_MEDIA_DELETEOLDVER_CHECKB','Unchecked','dropdown','Default the checkbox for Deleting Old Version of media when a new file is being uploaded to the library.','Checked|Unchecked','defaults',1,'Default for \"Delete old version of Media\" checkbox. Showen when Editing Library Media.','dropdown','',50,'Unchecked',1)].```\r\n\r\nIf I use the \"Use an existing database\" option, I get this error:\r\n\r\n```An error occurred populating the database. Statement number: 56. Error Message = [SQLSTATE[HY000]: General error: 1005 Can't create table 'xibo.#sql-6a46_89' (errno: 121)]. File = [Array]. SQL = [ALTER TABLE `blacklist` ADD CONSTRAINT `blacklist_ibfk_1` FOREIGN KEY (`MediaID`) REFERENCES `media` (`mediaID`), ADD CONSTRAINT `blacklist_ibfk_2` FOREIGN KEY (`DisplayID`) REFERENCES `display` (`displayid`)].```\r\n\r\nIs there something wrong with my MySQL installation, or is this something wrong with the xibo wizard?"}}