{"action":"created","issue":{"url":"https://api.github.com/repos/GawainLynch/bolt-extension-clientlogin/issues/5","labels_url":"https://api.github.com/repos/GawainLynch/bolt-extension-clientlogin/issues/5/labels{/name}","comments_url":"https://api.github.com/repos/GawainLynch/bolt-extension-clientlogin/issues/5/comments","events_url":"https://api.github.com/repos/GawainLynch/bolt-extension-clientlogin/issues/5/events","html_url":"https://github.com/GawainLynch/bolt-extension-clientlogin/issues/5","id":68325008,"number":5,"title":"installing dev-master sql error","user":{"login":"jadwigo","id":1488214,"avatar_url":"https://avatars.githubusercontent.com/u/1488214?v=3","gravatar_id":"","url":"https://api.github.com/users/jadwigo","html_url":"https://github.com/jadwigo","followers_url":"https://api.github.com/users/jadwigo/followers","following_url":"https://api.github.com/users/jadwigo/following{/other_user}","gists_url":"https://api.github.com/users/jadwigo/gists{/gist_id}","starred_url":"https://api.github.com/users/jadwigo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jadwigo/subscriptions","organizations_url":"https://api.github.com/users/jadwigo/orgs","repos_url":"https://api.github.com/users/jadwigo/repos","events_url":"https://api.github.com/users/jadwigo/events{/privacy}","received_events_url":"https://api.github.com/users/jadwigo/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-04-14T10:01:46Z","updated_at":"2015-04-14T10:54:06Z","closed_at":"2015-04-14T10:54:06Z","body":"When I install dev-master the database update that wants to create the table drops a whoopsie with the following message\r\n\r\n```\r\nAn exception occurred while executing '\r\nCREATE TABLE bolt_client_sessions (\r\n  id INT AUTO_INCREMENT NOT NULL, \r\n  userid INT NOT NULL, \r\n  session VARCHAR(64) NOT NULL, \r\n  token LONGTEXT DEFAULT NULL, \r\n  lastseen DATETIME NOT NULL, \r\n  INDEX IDX_B644867F132696E (userid), \r\n  INDEX IDX_B6448675F37A13B (token), \r\n  PRIMARY KEY(id)\r\n) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':\r\nSQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column 'token' used in key specification without a key length\r\n```\r\n\r\nMy guess is that the index on https://github.com/GawainLynch/bolt-extension-clientlogin/blob/master/src/Database.php#L513 need a length parameter"},"comment":{"url":"https://api.github.com/repos/GawainLynch/bolt-extension-clientlogin/issues/comments/92766530","html_url":"https://github.com/GawainLynch/bolt-extension-clientlogin/issues/5#issuecomment-92766530","issue_url":"https://api.github.com/repos/GawainLynch/bolt-extension-clientlogin/issues/5","id":92766530,"user":{"login":"GawainLynch","id":1427081,"avatar_url":"https://avatars.githubusercontent.com/u/1427081?v=3","gravatar_id":"","url":"https://api.github.com/users/GawainLynch","html_url":"https://github.com/GawainLynch","followers_url":"https://api.github.com/users/GawainLynch/followers","following_url":"https://api.github.com/users/GawainLynch/following{/other_user}","gists_url":"https://api.github.com/users/GawainLynch/gists{/gist_id}","starred_url":"https://api.github.com/users/GawainLynch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GawainLynch/subscriptions","organizations_url":"https://api.github.com/users/GawainLynch/orgs","repos_url":"https://api.github.com/users/GawainLynch/repos","events_url":"https://api.github.com/users/GawainLynch/events{/privacy}","received_events_url":"https://api.github.com/users/GawainLynch/received_events","type":"User","site_admin":false},"created_at":"2015-04-14T10:54:06Z","updated_at":"2015-04-14T10:54:06Z","body":"Fixed in f7a3111110e5e0b29724d5bf97ceaa891402e20c \r\n\r\nApparently it also kinda helps if you index the *correct* column :see_no_evil: "}}