{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/9221","repository_url":"https://api.github.com/repos/joomla/joomla-cms","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9221/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9221/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9221/events","html_url":"https://github.com/joomla/joomla-cms/pull/9221","id":136687984,"number":9221,"title":"Correct utf8mb4 conversion","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},"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":20,"created_at":"2016-02-26T12:44:04Z","updated_at":"2016-02-26T18:21:24Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/joomla/joomla-cms/pulls/9221","html_url":"https://github.com/joomla/joomla-cms/pull/9221","diff_url":"https://github.com/joomla/joomla-cms/pull/9221.diff","patch_url":"https://github.com/joomla/joomla-cms/pull/9221.patch"},"body":"Pull Request for Issue #9156 .\r\n\r\n#### Summary of Changes\r\n\r\nThis PR corrects the errors related to utf8mb4 conversions when updating a pre-3.5 to 3.5 (right now current staging plus this patch).\r\n\r\nIt could be done nicer with a special message for the database problems report instead of abusing the one for a missing table, which could be confusing if someone checks database and finds the missing table beign there, but let's just check if this here works and then we can make it nicer later with another PR.\r\n\r\n#### Testing Instructions\r\n\r\nEither do a Joomla! Update from a 3.4.8 to a \"3.5.0 latest staging plus this PR applied\":\r\n\r\nYou can find an update container here:\r\n[http://test5.richard-fath.de/Joomla_3.5.0-beta2-Beta-Update_Package_test2.zip](http://test5.richard-fath.de/Joomla_3.5.0-beta2-Beta-Update_Package_test2.zip \"http://test5.richard-fath.de/Joomla_3.5.0-beta2-Beta-Update_Package_test2.zip\").\r\n\r\nOr you can use the Joomla! Update component with following custom URL (note it is http, not use https):\r\n[http://test5.richard-fath.de/list_test5.xml](http://test5.richard-fath.de/list_test5.xml \"http://test5.richard-fath.de/list_test5.xml\").\r\n\r\nThe update ends with a PHP error about session already started. This is not related to this PR.\r\n\r\nWhen clicking the button you need to log in again to backend.\r\n\r\nThen goto Extenions -> Manage -> Database.\r\n\r\nThere should be reported at least the problem that table \"#__mysql_utf8mb4_test\" does not exist.\r\n\r\nThen click the Fix button.\r\n\r\nResult: Either all ok now, or some problems are still shown, which then also should be able to be fixed, i.e. clicking the \"Fix\" button might be required several times but not an endless number of times, and at the end all is ok.\r\n\r\nOr do as @wilsonge described in his issue #9156, i.e.\r\n\r\n- Install a new, clean 3.4.8 into an empty database,\r\n- download the branch of this patch here [https://github.com/richard67/joomla-cms/archive/correct-utf8mb4-conversion.zip](https://github.com/richard67/joomla-cms/archive/correct-utf8mb4-conversion.zip)\r\n- unzip it into the 3.4.8 installation, so all the files are updated now by the ones from this PR,\r\n- login at the backend and check for database problems (Extenions -> Manage -> Database).\r\n- The rest is like mentioned before.\r\n\r\nPlease test on database with and without utf8mb4 support if you have both, and if you have time test both extension installer with my Zip and Joomla Update Component with my Custom URL as mentioned above.\r\n\r\nI will add soon info about which versions of mysql and clients support utf8mb4.\r\n\r\nTesters please report the used update methods and your mysql server version and the client library version (mysql, mysqli or pdo driver) with your test result. Thanks in advance."},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/189410398","html_url":"https://github.com/joomla/joomla-cms/pull/9221#issuecomment-189410398","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9221","id":189410398,"user":{"login":"Stevec4","id":6751354,"avatar_url":"https://avatars.githubusercontent.com/u/6751354?v=3","gravatar_id":"","url":"https://api.github.com/users/Stevec4","html_url":"https://github.com/Stevec4","followers_url":"https://api.github.com/users/Stevec4/followers","following_url":"https://api.github.com/users/Stevec4/following{/other_user}","gists_url":"https://api.github.com/users/Stevec4/gists{/gist_id}","starred_url":"https://api.github.com/users/Stevec4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Stevec4/subscriptions","organizations_url":"https://api.github.com/users/Stevec4/orgs","repos_url":"https://api.github.com/users/Stevec4/repos","events_url":"https://api.github.com/users/Stevec4/events{/privacy}","received_events_url":"https://api.github.com/users/Stevec4/received_events","type":"User","site_admin":false},"created_at":"2016-02-26T18:21:23Z","updated_at":"2016-02-26T18:21:23Z","body":"@richard67 \r\n`•Table utf8mb4 conversion does not exist. (From file utf8mb4-conversion.sql.)`\r\nMessage remains no matter how many times I select fix \r\nthis is a beta 2 install if that maters\r\n\r\nSteve"}}