{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/8472","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/8472/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/8472/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/8472/events","html_url":"https://github.com/joomla/joomla-cms/pull/8472","id":117456237,"number":8472,"title":"Fixed failure on updating database not supporting UTF8MB4","user":{"login":"roland-d","id":359377,"avatar_url":"https://avatars.githubusercontent.com/u/359377?v=3","gravatar_id":"","url":"https://api.github.com/users/roland-d","html_url":"https://github.com/roland-d","followers_url":"https://api.github.com/users/roland-d/followers","following_url":"https://api.github.com/users/roland-d/following{/other_user}","gists_url":"https://api.github.com/users/roland-d/gists{/gist_id}","starred_url":"https://api.github.com/users/roland-d/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roland-d/subscriptions","organizations_url":"https://api.github.com/users/roland-d/orgs","repos_url":"https://api.github.com/users/roland-d/repos","events_url":"https://api.github.com/users/roland-d/events{/privacy}","received_events_url":"https://api.github.com/users/roland-d/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":2,"created_at":"2015-11-17T21:36:51Z","updated_at":"2015-11-17T22:59:52Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/joomla/joomla-cms/pulls/8472","html_url":"https://github.com/joomla/joomla-cms/pull/8472","diff_url":"https://github.com/joomla/joomla-cms/pull/8472.diff","patch_url":"https://github.com/joomla/joomla-cms/pull/8472.patch"},"body":"## Problem ##\r\nUsers running a MySQL database that does not support UTF8MB4 will get failures during an update to Joomla 3.5.0 because the queries to update the tables to UTF8MB4 are executed.\r\n\r\n## Fix ##\r\nThe fix is to modify the SQL queries that are run on databases not supporting UTF8MB4.\r\n\r\n## Testing ##\r\n1. Setup a Joomla 3.4.5 site with a MySQL database version that does not support UTF8MB4. For example mysqlnd lower than 5.0.9 or libmysql lower than 5.5.3.\r\n2. Download the Joomla 3.5.0 beta 1 package\r\n3. Change the files in the package with the files in this pull request\r\n4. Update the Joomla version to 3.5.0 beta 1\r\n5. The update should run without problems\r\n\r\n## Disclaimer ##\r\nYou may still see database problems on the database tab due to different field definitions. This is not handled in this fix but will be dealt with in another fix."},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/157537430","html_url":"https://github.com/joomla/joomla-cms/pull/8472#issuecomment-157537430","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/8472","id":157537430,"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":"2015-11-17T22:59:52Z","updated_at":"2015-11-17T22:59:52Z","body":"P.S.: When I tested, there were no database problems detected on the database tab after the update had finished, and all 3 new plugins were installed (which also was not the case before and shows that now everything completed).<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/8472\">issues.joomla.org/joomla-cms/8472</a>.</sub>"}}