{"action":"created","issue":{"url":"https://api.github.com/repos/NagiosEnterprises/ndoutils/issues/15","repository_url":"https://api.github.com/repos/NagiosEnterprises/ndoutils","labels_url":"https://api.github.com/repos/NagiosEnterprises/ndoutils/issues/15/labels{/name}","comments_url":"https://api.github.com/repos/NagiosEnterprises/ndoutils/issues/15/comments","events_url":"https://api.github.com/repos/NagiosEnterprises/ndoutils/issues/15/events","html_url":"https://github.com/NagiosEnterprises/ndoutils/issues/15","id":175290030,"number":15,"title":"Database creation fails in mysql.sql in fresh install","user":{"login":"tatref","id":2582791,"avatar_url":"https://avatars.githubusercontent.com/u/2582791?v=3","gravatar_id":"","url":"https://api.github.com/users/tatref","html_url":"https://github.com/tatref","followers_url":"https://api.github.com/users/tatref/followers","following_url":"https://api.github.com/users/tatref/following{/other_user}","gists_url":"https://api.github.com/users/tatref/gists{/gist_id}","starred_url":"https://api.github.com/users/tatref/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tatref/subscriptions","organizations_url":"https://api.github.com/users/tatref/orgs","repos_url":"https://api.github.com/users/tatref/repos","events_url":"https://api.github.com/users/tatref/events{/privacy}","received_events_url":"https://api.github.com/users/tatref/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/NagiosEnterprises/ndoutils/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"jfrickson","id":13370023,"avatar_url":"https://avatars.githubusercontent.com/u/13370023?v=3","gravatar_id":"","url":"https://api.github.com/users/jfrickson","html_url":"https://github.com/jfrickson","followers_url":"https://api.github.com/users/jfrickson/followers","following_url":"https://api.github.com/users/jfrickson/following{/other_user}","gists_url":"https://api.github.com/users/jfrickson/gists{/gist_id}","starred_url":"https://api.github.com/users/jfrickson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jfrickson/subscriptions","organizations_url":"https://api.github.com/users/jfrickson/orgs","repos_url":"https://api.github.com/users/jfrickson/repos","events_url":"https://api.github.com/users/jfrickson/events{/privacy}","received_events_url":"https://api.github.com/users/jfrickson/received_events","type":"User","site_admin":false},"assignees":[{"login":"jfrickson","id":13370023,"avatar_url":"https://avatars.githubusercontent.com/u/13370023?v=3","gravatar_id":"","url":"https://api.github.com/users/jfrickson","html_url":"https://github.com/jfrickson","followers_url":"https://api.github.com/users/jfrickson/followers","following_url":"https://api.github.com/users/jfrickson/following{/other_user}","gists_url":"https://api.github.com/users/jfrickson/gists{/gist_id}","starred_url":"https://api.github.com/users/jfrickson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jfrickson/subscriptions","organizations_url":"https://api.github.com/users/jfrickson/orgs","repos_url":"https://api.github.com/users/jfrickson/repos","events_url":"https://api.github.com/users/jfrickson/events{/privacy}","received_events_url":"https://api.github.com/users/jfrickson/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2016-09-06T16:19:28Z","updated_at":"2016-09-06T16:54:40Z","closed_at":null,"body":"I'm using ndoutils-2.1.0\r\n\r\nError message:\r\n\r\n    ** Creating tables for version 2.0.1\r\n    Using mysql.sql for installation...\r\n    ERRROR 1072 (42000) at line 27: Key column 'logentry_id' doesn't exit in table\r\n    Installation from mysql.sql failed at ./installdb line 60\r\n\r\nI think this is due to commit bc6088e, and the constraint introduced on `logentry_id`\r\n\r\nI'm using the `installdb` script. The database is created with `grant all privileges...`.\r\n\r\nI'm not a mysql expert, but it seems that there is no such column in `nagios_logentries`?"},"comment":{"url":"https://api.github.com/repos/NagiosEnterprises/ndoutils/issues/comments/245015674","html_url":"https://github.com/NagiosEnterprises/ndoutils/issues/15#issuecomment-245015674","issue_url":"https://api.github.com/repos/NagiosEnterprises/ndoutils/issues/15","id":245015674,"user":{"login":"jfrickson","id":13370023,"avatar_url":"https://avatars.githubusercontent.com/u/13370023?v=3","gravatar_id":"","url":"https://api.github.com/users/jfrickson","html_url":"https://github.com/jfrickson","followers_url":"https://api.github.com/users/jfrickson/followers","following_url":"https://api.github.com/users/jfrickson/following{/other_user}","gists_url":"https://api.github.com/users/jfrickson/gists{/gist_id}","starred_url":"https://api.github.com/users/jfrickson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jfrickson/subscriptions","organizations_url":"https://api.github.com/users/jfrickson/orgs","repos_url":"https://api.github.com/users/jfrickson/repos","events_url":"https://api.github.com/users/jfrickson/events{/privacy}","received_events_url":"https://api.github.com/users/jfrickson/received_events","type":"User","site_admin":false},"created_at":"2016-09-06T16:54:40Z","updated_at":"2016-09-06T16:54:40Z","body":"You are correct. A change was applied to the wrong table. Will be fixed shortly."}}
{"actor":{"display_login":"jfrickson"}}