{"action":"closed","issue":{"url":"https://api.github.com/repos/engelsystem/engelsystem/issues/212","repository_url":"https://api.github.com/repos/engelsystem/engelsystem","labels_url":"https://api.github.com/repos/engelsystem/engelsystem/issues/212/labels{/name}","comments_url":"https://api.github.com/repos/engelsystem/engelsystem/issues/212/comments","events_url":"https://api.github.com/repos/engelsystem/engelsystem/issues/212/events","html_url":"https://github.com/engelsystem/engelsystem/issues/212","id":103027054,"number":212,"title":"Duplicate entry for Room name","user":{"login":"nafur","id":1126854,"avatar_url":"https://avatars0.githubusercontent.com/u/1126854?v=4","gravatar_id":"","url":"https://api.github.com/users/nafur","html_url":"https://github.com/nafur","followers_url":"https://api.github.com/users/nafur/followers","following_url":"https://api.github.com/users/nafur/following{/other_user}","gists_url":"https://api.github.com/users/nafur/gists{/gist_id}","starred_url":"https://api.github.com/users/nafur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nafur/subscriptions","organizations_url":"https://api.github.com/users/nafur/orgs","repos_url":"https://api.github.com/users/nafur/repos","events_url":"https://api.github.com/users/nafur/events{/privacy}","received_events_url":"https://api.github.com/users/nafur/received_events","type":"User","site_admin":false},"labels":[{"id":141670168,"url":"https://api.github.com/repos/engelsystem/engelsystem/labels/P:%20critical","name":"P: critical","color":"ffffb8","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/engelsystem/engelsystem/milestones/1","html_url":"https://github.com/engelsystem/engelsystem/milestone/1","labels_url":"https://api.github.com/repos/engelsystem/engelsystem/milestones/1/labels","id":840809,"number":1,"title":"Future","description":"Features needed","creator":{"login":"mortzu","id":1412022,"avatar_url":"https://avatars0.githubusercontent.com/u/1412022?v=4","gravatar_id":"","url":"https://api.github.com/users/mortzu","html_url":"https://github.com/mortzu","followers_url":"https://api.github.com/users/mortzu/followers","following_url":"https://api.github.com/users/mortzu/following{/other_user}","gists_url":"https://api.github.com/users/mortzu/gists{/gist_id}","starred_url":"https://api.github.com/users/mortzu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mortzu/subscriptions","organizations_url":"https://api.github.com/users/mortzu/orgs","repos_url":"https://api.github.com/users/mortzu/repos","events_url":"https://api.github.com/users/mortzu/events{/privacy}","received_events_url":"https://api.github.com/users/mortzu/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":3,"state":"open","created_at":"2014-10-26T09:50:46Z","updated_at":"2017-12-10T17:56:51Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2015-08-25T13:52:24Z","updated_at":"2017-12-10T17:56:51Z","closed_at":"2017-12-10T17:56:51Z","author_association":"NONE","body":"Hi,\n\nI'm trying to use the Frab import when I already configured some of the rooms.\nThe importer somehow does not correctly detects that some of the rooms already exists and places them in the list to be created.\n\nUltimately, this results in the following SQL error when performing the import:\n\nmysql_provider error: MySQL-query error: \n   INSERT INTO `Room` SET \n   `Name`='HS 3', \n   `FromPentabarf`='Y', \n   `show`='Y', \n   `Number`=0 (1062) Duplicate entry 'HS 3' for key 'Name'\n#0  sql_error(MySQL-query error:\n\n   INSERT INTO `Room` SET \n   `Name`='HS 3', \n   `FromPentabarf`='Y', \n   `show`='Y', \n   `Number`=0 (1062) Duplicate entry 'HS 3' for key 'Name') called at [/www/engelsystem/includes/mysqli_provider.php:149]\n#1  sql_query(\n\n   INSERT INTO `Room` SET \n   `Name`='HS 3', \n   `FromPentabarf`='Y', \n   `show`='Y', \n   `Number`=0) called at [/www/engelsystem/includes/model/Room_model.php:27]\n#2  Room_create(HS 3, 1, 1) called at [/www/engelsystem/includes/pages/admin_import.php:165]\n#3  admin_import() called at [/www/engelsystem/public/index.php:126]\n"}}
{"actor":{"display_login":"msquare"}}