{"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":{"url":"https://api.github.com/repos/joomla/joomla-cms/milestones/7","html_url":"https://github.com/joomla/joomla-cms/milestones/Joomla!%203.5.0","labels_url":"https://api.github.com/repos/joomla/joomla-cms/milestones/7/labels","id":944889,"number":7,"title":"Joomla! 3.5.0","description":"","creator":{"login":"rdeutz","id":467356,"avatar_url":"https://avatars.githubusercontent.com/u/467356?v=3","gravatar_id":"","url":"https://api.github.com/users/rdeutz","html_url":"https://github.com/rdeutz","followers_url":"https://api.github.com/users/rdeutz/followers","following_url":"https://api.github.com/users/rdeutz/following{/other_user}","gists_url":"https://api.github.com/users/rdeutz/gists{/gist_id}","starred_url":"https://api.github.com/users/rdeutz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rdeutz/subscriptions","organizations_url":"https://api.github.com/users/rdeutz/orgs","repos_url":"https://api.github.com/users/rdeutz/repos","events_url":"https://api.github.com/users/rdeutz/events{/privacy}","received_events_url":"https://api.github.com/users/rdeutz/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":406,"state":"open","created_at":"2015-01-21T08:12:44Z","updated_at":"2015-11-24T23:23:28Z","due_on":"2015-12-07T23:00:00Z","closed_at":null},"comments":121,"created_at":"2015-11-17T21:36:51Z","updated_at":"2015-11-25T01:41:05Z","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/159459655","html_url":"https://github.com/joomla/joomla-cms/pull/8472#issuecomment-159459655","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/8472","id":159459655,"user":{"login":"zero-24","id":2596554,"avatar_url":"https://avatars.githubusercontent.com/u/2596554?v=3","gravatar_id":"","url":"https://api.github.com/users/zero-24","html_url":"https://github.com/zero-24","followers_url":"https://api.github.com/users/zero-24/followers","following_url":"https://api.github.com/users/zero-24/following{/other_user}","gists_url":"https://api.github.com/users/zero-24/gists{/gist_id}","starred_url":"https://api.github.com/users/zero-24/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zero-24/subscriptions","organizations_url":"https://api.github.com/users/zero-24/orgs","repos_url":"https://api.github.com/users/zero-24/repos","events_url":"https://api.github.com/users/zero-24/events{/privacy}","received_events_url":"https://api.github.com/users/zero-24/received_events","type":"User","site_admin":false},"created_at":"2015-11-25T01:41:05Z","updated_at":"2015-11-25T01:41:05Z","body":"Sorry @roland-d i have just discoverd two issues with the pdosql driver ;)"}}