{"action":"created","issue":{"url":"https://api.github.com/repos/tananaev/traccar/issues/1275","labels_url":"https://api.github.com/repos/tananaev/traccar/issues/1275/labels{/name}","comments_url":"https://api.github.com/repos/tananaev/traccar/issues/1275/comments","events_url":"https://api.github.com/repos/tananaev/traccar/issues/1275/events","html_url":"https://github.com/tananaev/traccar/issues/1275","id":91445508,"number":1275,"title":"error starting traccar v3","user":{"login":"and12345","id":12172073,"avatar_url":"https://avatars.githubusercontent.com/u/12172073?v=3","gravatar_id":"","url":"https://api.github.com/users/and12345","html_url":"https://github.com/and12345","followers_url":"https://api.github.com/users/and12345/followers","following_url":"https://api.github.com/users/and12345/following{/other_user}","gists_url":"https://api.github.com/users/and12345/gists{/gist_id}","starred_url":"https://api.github.com/users/and12345/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/and12345/subscriptions","organizations_url":"https://api.github.com/users/and12345/orgs","repos_url":"https://api.github.com/users/and12345/repos","events_url":"https://api.github.com/users/and12345/events{/privacy}","received_events_url":"https://api.github.com/users/and12345/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":14,"created_at":"2015-06-27T10:48:06Z","updated_at":"2015-06-29T03:00:28Z","closed_at":null,"body":"Hi Anton,\r\n\r\nBeen following traccar project, today after upgrade i got an error while starting traccar : \r\n\r\n2015-06-27 17:41:01  WARN: Table 'traccar.user' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder.java:287 < DataManager.java:225 < PermissionsManager.java:50 < ...)\r\n\r\ntraccar doesn't create the required tables."},"comment":{"url":"https://api.github.com/repos/tananaev/traccar/issues/comments/116399458","html_url":"https://github.com/tananaev/traccar/issues/1275#issuecomment-116399458","issue_url":"https://api.github.com/repos/tananaev/traccar/issues/1275","id":116399458,"user":{"login":"tananaev","id":1161863,"avatar_url":"https://avatars.githubusercontent.com/u/1161863?v=3","gravatar_id":"","url":"https://api.github.com/users/tananaev","html_url":"https://github.com/tananaev","followers_url":"https://api.github.com/users/tananaev/followers","following_url":"https://api.github.com/users/tananaev/following{/other_user}","gists_url":"https://api.github.com/users/tananaev/gists{/gist_id}","starred_url":"https://api.github.com/users/tananaev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tananaev/subscriptions","organizations_url":"https://api.github.com/users/tananaev/orgs","repos_url":"https://api.github.com/users/tananaev/repos","events_url":"https://api.github.com/users/tananaev/events{/privacy}","received_events_url":"https://api.github.com/users/tananaev/received_events","type":"User","site_admin":false},"created_at":"2015-06-29T03:00:27Z","updated_at":"2015-06-29T03:00:27Z","body":"I have fixed the problem. It was actually a tricky one.\r\n\r\nThe error message was\r\n<pre>Specified key was too long; max key length is 767 bytes</pre>\r\n\r\nAll keys are 256 characters UTF8, but because MySQL assumes the worst case for UTF8 (3 bytes), we get 256 * 3 = 768 (>767 for InnoDB).\r\n\r\nIt worked for me on the demo server because (I guess) I'm using MyISAM which has 1000 bytes limit.\r\n\r\nI will update the queries to satisfy both engines."}}