{"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":6,"closed_issues":407,"state":"open","created_at":"2015-01-21T08:12:44Z","updated_at":"2015-11-25T07:34:47Z","due_on":"2015-12-07T23:00:00Z","closed_at":null},"comments":127,"created_at":"2015-11-17T21:36:51Z","updated_at":"2015-11-25T13:34:11Z","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/159609437","html_url":"https://github.com/joomla/joomla-cms/pull/8472#issuecomment-159609437","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/8472","id":159609437,"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-25T13:34:11Z","updated_at":"2015-11-25T13:34:11Z","body":"I have tested this item :red_circle: unsuccessfully on e7ba512acaa0da40057f2c4900c23fd5732a40de<br /><br />I did not redo all my 4 tests (update and nww install on both kinds of databases) again with the mysqli driver as I did before, and then again with the PDO driver. 8 tests ... uffff.\n\nAll installations and updates succeed, i.e. there are no errors and all 3 new plugins are installed, **but**:\n\nWhen I compared with previous correct results, I have seen that with the PDO driver all is correct, but with for the mysqli driver for both kinds of databases, the conversion to utf8mb4 has not taken place, i.e. the databases updated from 3.4.5 to patched 3.5.0 beta 1 using the mysqli driver still have utf8 collations (without mb4) and old text length (e.g. 255).<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>"}}