{"action":"created","issue":{"url":"https://api.github.com/repos/e107inc/e107/issues/1255","repository_url":"https://api.github.com/repos/e107inc/e107","labels_url":"https://api.github.com/repos/e107inc/e107/issues/1255/labels{/name}","comments_url":"https://api.github.com/repos/e107inc/e107/issues/1255/comments","events_url":"https://api.github.com/repos/e107inc/e107/issues/1255/events","html_url":"https://github.com/e107inc/e107/issues/1255","id":119391341,"number":1255,"title":"Trouble with database verification","user":{"login":"pierre0042","id":4124597,"avatar_url":"https://avatars.githubusercontent.com/u/4124597?v=3","gravatar_id":"","url":"https://api.github.com/users/pierre0042","html_url":"https://github.com/pierre0042","followers_url":"https://api.github.com/users/pierre0042/followers","following_url":"https://api.github.com/users/pierre0042/following{/other_user}","gists_url":"https://api.github.com/users/pierre0042/gists{/gist_id}","starred_url":"https://api.github.com/users/pierre0042/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pierre0042/subscriptions","organizations_url":"https://api.github.com/users/pierre0042/orgs","repos_url":"https://api.github.com/users/pierre0042/repos","events_url":"https://api.github.com/users/pierre0042/events{/privacy}","received_events_url":"https://api.github.com/users/pierre0042/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/e107inc/e107/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":14,"created_at":"2015-11-29T22:06:18Z","updated_at":"2016-02-09T18:18:07Z","closed_at":null,"body":"Hello,\r\n\r\nWhen I check the database validity, it says that I have a problem in table 'user_extended' with 3 fields :\r\n\r\nuser_extended \tuser_extended_id  \tField missing! \tshould be\r\nINT(10) UNSIGNED NOT NULL DEFAULT '0'\r\n  \t\r\nuser_extended \tuser_hidden_fields  \tField missing! \tshould be\r\nTEXT\r\n  \t\r\nuser_extended \tuser_extended_id  \tIndex missing! \tshould be\r\nPRIMARY (user_extended_id);\r\n\r\n\r\nThe problem is that these fields and the index are not missing, I can see them in phpmyadmin.\r\n\r\nAnd if I try to fix these issues with the button \"fix issues\", I got those errors :\r\n\r\n\r\nWarning\r\nUpdate Unsuccessful [ALTER TABLE `e107_user_extended` ADD `user_extended_id` INT(10) UNSIGNED NOT NULL DEFAULT '0']\r\nDuplicate column name 'user_extended_id'\r\nUpdate Unsuccessful [ALTER TABLE `e107_user_extended` ADD PRIMARY KEY (user_extended_id) ]\r\nMultiple primary key defined\r\nUpdate Unsuccessful [ALTER TABLE `e107_user_extended` ADD `user_hidden_fields` TEXT ]\r\nDuplicate column name 'user_hidden_fields'\r\n\r\n\r\nWhat could be wrong ?\r\nI am trying to upgrade e107 from 1.x to 2.0.\r\n"},"comment":{"url":"https://api.github.com/repos/e107inc/e107/issues/comments/181989730","html_url":"https://github.com/e107inc/e107/issues/1255#issuecomment-181989730","issue_url":"https://api.github.com/repos/e107inc/e107/issues/1255","id":181989730,"user":{"login":"tgtje","id":1811857,"avatar_url":"https://avatars.githubusercontent.com/u/1811857?v=3","gravatar_id":"","url":"https://api.github.com/users/tgtje","html_url":"https://github.com/tgtje","followers_url":"https://api.github.com/users/tgtje/followers","following_url":"https://api.github.com/users/tgtje/following{/other_user}","gists_url":"https://api.github.com/users/tgtje/gists{/gist_id}","starred_url":"https://api.github.com/users/tgtje/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tgtje/subscriptions","organizations_url":"https://api.github.com/users/tgtje/orgs","repos_url":"https://api.github.com/users/tgtje/repos","events_url":"https://api.github.com/users/tgtje/events{/privacy}","received_events_url":"https://api.github.com/users/tgtje/received_events","type":"User","site_admin":false},"created_at":"2016-02-09T18:18:07Z","updated_at":"2016-02-09T18:18:07Z","body":"Please provide a mail address (previous messages never arrived)\n\n\n\n---\nDit e-mailbericht is gecontroleerd op virussen met Avast antivirussoftware.\nhttps://www.avast.com/antivirus\n"}}