{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/9247","repository_url":"https://api.github.com/repos/joomla/joomla-cms","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9247/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9247/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9247/events","html_url":"https://github.com/joomla/joomla-cms/issues/9247","id":137125528,"number":9247,"title":"Error on converting to UTF-8 Multibyte ","user":{"login":"810","id":876623,"avatar_url":"https://avatars.githubusercontent.com/u/876623?v=3","gravatar_id":"","url":"https://api.github.com/users/810","html_url":"https://github.com/810","followers_url":"https://api.github.com/users/810/followers","following_url":"https://api.github.com/users/810/following{/other_user}","gists_url":"https://api.github.com/users/810/gists{/gist_id}","starred_url":"https://api.github.com/users/810/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/810/subscriptions","organizations_url":"https://api.github.com/users/810/orgs","repos_url":"https://api.github.com/users/810/repos","events_url":"https://api.github.com/users/810/events{/privacy}","received_events_url":"https://api.github.com/users/810/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2016-02-29T01:47:19Z","updated_at":"2016-02-29T14:51:44Z","closed_at":null,"body":"#### Steps to reproduce the issue\r\n\r\nGo to database fix page, with enabled redirects and have data in there\r\n\r\n#### Expected result\r\n\r\nFix the new database collation  \r\n\r\n#### Actual result\r\n\r\nDuplicate entry 'http://www.kunena.org/Array/169-K-16-and-K-17-Support-Archive/11' for key 'idx_link_old' SQL=ALTER TABLE  #__redirect_links  ADD UNIQUE  idx_link_old  ( old_url (100));\r\n\r\non the fix with the message:\r\n•The Joomla! Core database tables have not been converted yet to UTF-8 Multibyte (utf8mb4).\r\n\r\n\r\n#### System information (as much as possible)\r\n\r\nJ3.5.0-Beta3\r\n\r\n#### Additional comments\r\n\r\n>> \r\nrichard67 \r\nAh, no, sorry! Is not an old issue and not data. The index on this column was in fact introduced by the utf8mb4 conversion, I remember now. https://github.com/joomla/joomla-cms/pull/9221"},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/190243946","html_url":"https://github.com/joomla/joomla-cms/issues/9247#issuecomment-190243946","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9247","id":190243946,"user":{"login":"richard67","id":7413183,"avatar_url":"https://avatars.githubusercontent.com/u/7413183?v=3","gravatar_id":"","url":"https://api.github.com/users/richard67","html_url":"https://github.com/richard67","followers_url":"https://api.github.com/users/richard67/followers","following_url":"https://api.github.com/users/richard67/following{/other_user}","gists_url":"https://api.github.com/users/richard67/gists{/gist_id}","starred_url":"https://api.github.com/users/richard67/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/richard67/subscriptions","organizations_url":"https://api.github.com/users/richard67/orgs","repos_url":"https://api.github.com/users/richard67/repos","events_url":"https://api.github.com/users/richard67/events{/privacy}","received_events_url":"https://api.github.com/users/richard67/received_events","type":"User","site_admin":false},"created_at":"2016-02-29T14:51:44Z","updated_at":"2016-02-29T14:51:44Z","body":"Update 1: Meanwhile I have seen that when updasting 3.4.8 to Beta 3, the column \"profile_value\" of the \"#__user_profiles\" table has data type \"TEXT\", as it should be.\n\nAfter the first use of the \"Fix\" button the data type is then \"MEDIUMTEXT\". I will check if this comes from the utf8mb4 comversion or what else causes this data type changem but it is not another, later update sql as I thought in my 2nd last comment.\n\nThis causes the db schema manager then to see thas it has to be changed to \"TEXT\" in the second run.\n\nIt seems to be an implicit conversion done by mysql, there is not any update sql doing this.\n\nI'll check now if this is caused by statements from the utf8(mb4) conversion and provide an \"Update 2\" comment here.<hr /><sub>This comment was created with the <a href=\"https://github.com/joomla/jissues\">J!Tracker Application</a> at <a href=\"https://issues.joomla.org/tracker/joomla-cms/9247\">issues.joomla.org/joomla-cms/9247</a>.</sub>"}}