{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/shorty/issues/121","labels_url":"https://api.github.com/repos/owncloud/shorty/issues/121/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/shorty/issues/121/comments","events_url":"https://api.github.com/repos/owncloud/shorty/issues/121/events","html_url":"https://github.com/owncloud/shorty/issues/121","id":58401301,"number":121,"title":"SQL error while installing on 8.0.0","user":{"login":"chadrien","id":1788218,"avatar_url":"https://avatars.githubusercontent.com/u/1788218?v=3","gravatar_id":"","url":"https://api.github.com/users/chadrien","html_url":"https://github.com/chadrien","followers_url":"https://api.github.com/users/chadrien/followers","following_url":"https://api.github.com/users/chadrien/following{/other_user}","gists_url":"https://api.github.com/users/chadrien/gists{/gist_id}","starred_url":"https://api.github.com/users/chadrien/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chadrien/subscriptions","organizations_url":"https://api.github.com/users/chadrien/orgs","repos_url":"https://api.github.com/users/chadrien/repos","events_url":"https://api.github.com/users/chadrien/events{/privacy}","received_events_url":"https://api.github.com/users/chadrien/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-02-20T19:47:50Z","updated_at":"2015-02-23T10:48:10Z","closed_at":null,"body":"> An exception occurred while executing 'CREATE TABLE `oc_shorty` (`id` VARCHAR(12) NOT NULL, `status` VARCHAR(10) DEFAULT 'shared' NOT NULL, `title` VARCHAR(1024) DEFAULT '' NOT NULL, `favicon` VARCHAR(1024) DEFAULT NULL, `source` VARCHAR(500) NOT NULL, `target` VARCHAR(4096) NOT NULL, `user` VARCHAR(64) NOT NULL, `until` DATE DEFAULT NULL, `created` DATE DEFAULT NULL, `accessed` BIGINT UNSIGNED DEFAULT 0, `clicks` BIGINT UNSIGNED DEFAULT 0 NOT NULL, `notes` VARCHAR(4096) DEFAULT '' NOT NULL, UNIQUE INDEX index_shorty_id (`id`), INDEX index_shorty_user (`user`), INDEX index_shorty_source (`source`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes\r\n\r\nOwncloud version: 8.0.0\r\nShorty version: 0.4.4\r\nPHP: 5.6\r\nMySQL: 5.6.23\r\n\r\nI don't think its really related to the owncloud version, but who knows :smiley: "},"comment":{"url":"https://api.github.com/repos/owncloud/shorty/issues/comments/75521631","html_url":"https://github.com/owncloud/shorty/issues/121#issuecomment-75521631","issue_url":"https://api.github.com/repos/owncloud/shorty/issues/121","id":75521631,"user":{"login":"arkascha","id":2156237,"avatar_url":"https://avatars.githubusercontent.com/u/2156237?v=3","gravatar_id":"","url":"https://api.github.com/users/arkascha","html_url":"https://github.com/arkascha","followers_url":"https://api.github.com/users/arkascha/followers","following_url":"https://api.github.com/users/arkascha/following{/other_user}","gists_url":"https://api.github.com/users/arkascha/gists{/gist_id}","starred_url":"https://api.github.com/users/arkascha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arkascha/subscriptions","organizations_url":"https://api.github.com/users/arkascha/orgs","repos_url":"https://api.github.com/users/arkascha/repos","events_url":"https://api.github.com/users/arkascha/events{/privacy}","received_events_url":"https://api.github.com/users/arkascha/received_events","type":"User","site_admin":false},"created_at":"2015-02-23T10:48:10Z","updated_at":"2015-02-23T10:48:10Z","body":"Sure, as already written in my last comment: \r\nthe changes fixing the known issue with index length were introduced before Shorty-0.4.4. Therefore there are no changes to that aspect in current master. \r\n\r\nI know this is frustrating, sorry again. But as written before I have no clue what is going on...\r\nOne reason might be that you have a somewhat special, non default configuration inside your mysql server. As said: I am unable to reproduce that issue on any of my servers. If you want to share your configuration to tackle this down you are welcome. If you have details you don't want to publish here then you will find an email address to reach me in the head of every single file of the apps code. \r\n"}}