{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/4781","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/4781/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/4781/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/4781/events","html_url":"https://github.com/joomla/joomla-cms/pull/4781","id":46098818,"number":4781,"title":"com_redirect adding urls larger than 255","user":{"login":"Kixo","id":3668669,"avatar_url":"https://avatars.githubusercontent.com/u/3668669?v=3","gravatar_id":"","url":"https://api.github.com/users/Kixo","html_url":"https://github.com/Kixo","followers_url":"https://api.github.com/users/Kixo/followers","following_url":"https://api.github.com/users/Kixo/following{/other_user}","gists_url":"https://api.github.com/users/Kixo/gists{/gist_id}","starred_url":"https://api.github.com/users/Kixo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kixo/subscriptions","organizations_url":"https://api.github.com/users/Kixo/orgs","repos_url":"https://api.github.com/users/Kixo/repos","events_url":"https://api.github.com/users/Kixo/events{/privacy}","received_events_url":"https://api.github.com/users/Kixo/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/joomla/joomla-cms/labels/PR-staging","name":"PR-staging","color":"c7def8"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":15,"created_at":"2014-10-17T13:26:15Z","updated_at":"2015-03-06T16:41:13Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/joomla/joomla-cms/pulls/4781","html_url":"https://github.com/joomla/joomla-cms/pull/4781","diff_url":"https://github.com/joomla/joomla-cms/pull/4781.diff","patch_url":"https://github.com/joomla/joomla-cms/pull/4781.patch"},"body":".after some reading up I found up that maximum allowed URL in IE is 2083, other browsers allow much higher numbers, even over 100.000, but we must stand with the lowest one, so I set it up for 2083.\r\nExample description here: http://www.boutell.com/newfaq/misc/urllength.html\r\n\r\nIn this PR I have removed unique constraint. When we insert new row we are actually doing this check inside of the Joomla code, so this is not needed. And it was making a trouble because maximum varchar key for unique key is 767. So while removing it for mysql, I removed it for all DBs because as stated above, it is not needed.\r\n\r\nPlease check this code against Postgre and sqlazure if possible."},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/77590436","html_url":"https://github.com/joomla/joomla-cms/pull/4781#issuecomment-77590436","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/4781","id":77590436,"user":{"login":"Kixo","id":3668669,"avatar_url":"https://avatars.githubusercontent.com/u/3668669?v=3","gravatar_id":"","url":"https://api.github.com/users/Kixo","html_url":"https://github.com/Kixo","followers_url":"https://api.github.com/users/Kixo/followers","following_url":"https://api.github.com/users/Kixo/following{/other_user}","gists_url":"https://api.github.com/users/Kixo/gists{/gist_id}","starred_url":"https://api.github.com/users/Kixo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kixo/subscriptions","organizations_url":"https://api.github.com/users/Kixo/orgs","repos_url":"https://api.github.com/users/Kixo/repos","events_url":"https://api.github.com/users/Kixo/events{/privacy}","received_events_url":"https://api.github.com/users/Kixo/received_events","type":"User","site_admin":false},"created_at":"2015-03-06T16:41:13Z","updated_at":"2015-03-06T16:41:13Z","body":"ok updated"}}