{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/10611","repository_url":"https://api.github.com/repos/joomla/joomla-cms","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/10611/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/10611/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/10611/events","html_url":"https://github.com/joomla/joomla-cms/issues/10611","id":156456260,"number":10611,"title":"[3.6.0 Alpha1] 3.6.0-2016-04-01.sql does not apply","user":{"login":"shur","id":1245155,"avatar_url":"https://avatars.githubusercontent.com/u/1245155?v=3","gravatar_id":"","url":"https://api.github.com/users/shur","html_url":"https://github.com/shur","followers_url":"https://api.github.com/users/shur/followers","following_url":"https://api.github.com/users/shur/following{/other_user}","gists_url":"https://api.github.com/users/shur/gists{/gist_id}","starred_url":"https://api.github.com/users/shur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shur/subscriptions","organizations_url":"https://api.github.com/users/shur/orgs","repos_url":"https://api.github.com/users/shur/repos","events_url":"https://api.github.com/users/shur/events{/privacy}","received_events_url":"https://api.github.com/users/shur/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-05-24T09:07:35Z","updated_at":"2016-05-24T10:05:06Z","closed_at":"2016-05-24T10:05:06Z","body":"I'm trying to test the new update on my test platform (j3.5.1, updated, not freshly installed).\r\nI noticed that this file [3.6.0-2016-04-01.sql](https://github.com/joomla/joomla-cms/blob/staging/administrator/components/com_admin/sql/updates/mysql/3.6.0-2016-04-01.sql) doesn't apply its changes in #__update_sites table in my database. Digging deeper I found out that this file refers to these names:\r\n```\"Joomla! Core\" and \"Joomla! Extension Directory\"```\r\nbut in my case this table contains such names (without symbol \"!\"):\r\n```\"Joomla Core\" and \"Joomla Extension Directory\"```\r\nSure sql cannot find these names and cannot apply.\r\n\r\n\r\n\r\n#### Steps to reproduce the issue\r\nInstall Joomla 3.3.0 or earlier version.\r\nUpdate to Joomla 3.5.1\r\n\r\n#### Expected result\r\nGo to database #__update_sites table\r\nThere should be \"Joomla! Core\" and \"Joomla! Extension Directory\" site names.\r\n\r\n#### Actual result\r\nIn fact, the names are without symbol \"!\".\r\nSo we get an obvious difference between updated Joomla and freshly installed Joomla.\r\nBecause of this 3.6.0-2016-04-01.sql cannot be applied.\r\n\r\n#### Additional comments\r\nExploring the problem I discovered when this inconsistency was made.\r\nIn Joomla 3.3.1 installation joomla.sql file contains:\r\n```\r\nINSERT INTO `#__update_sites` (`update_site_id`, `name`, `type`, `location`, `enabled`, `last_check_timestamp`) VALUES\r\n(1, 'Joomla Core', 'collection', 'http://update.joomla.org/core/list.xml', 1, 0),\r\n(2, 'Joomla Extension Directory', 'collection', 'http://update.joomla.org/jed/list.xml', 1, 0),\r\n(3, 'Accredited Joomla! Translations', 'collection', 'http://update.joomla.org/language/translationlist_3.xml', 1, 0);\r\n```\r\n\r\n\r\n\r\nIn Joomla 3.3.3 installation joomla.sql file contains:\r\n```\r\nINSERT INTO `#__update_sites` (`update_site_id`, `name`, `type`, `location`, `enabled`, `last_check_timestamp`) VALUES\r\n(1, 'Joomla! Core', 'collection', 'http://update.joomla.org/core/list.xml', 1, 0),\r\n(2, 'Joomla! Extension Directory', 'collection', 'http://update.joomla.org/jed/list.xml', 1, 0),\r\n(3, 'Accredited Joomla! Translations', 'collection', 'http://update.joomla.org/language/translationlist_3.xml', 1, 0);\r\n```\r\n\r\nAs you see, exclamation mark has appeared, but only for freshly installed Joomla.\r\nBut how about those site that update their Joomla? These names were never renamed.\r\n"},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/221223906","html_url":"https://github.com/joomla/joomla-cms/issues/10611#issuecomment-221223906","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/10611","id":221223906,"user":{"login":"Bakual","id":1018684,"avatar_url":"https://avatars.githubusercontent.com/u/1018684?v=3","gravatar_id":"","url":"https://api.github.com/users/Bakual","html_url":"https://github.com/Bakual","followers_url":"https://api.github.com/users/Bakual/followers","following_url":"https://api.github.com/users/Bakual/following{/other_user}","gists_url":"https://api.github.com/users/Bakual/gists{/gist_id}","starred_url":"https://api.github.com/users/Bakual/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bakual/subscriptions","organizations_url":"https://api.github.com/users/Bakual/orgs","repos_url":"https://api.github.com/users/Bakual/repos","events_url":"https://api.github.com/users/Bakual/events{/privacy}","received_events_url":"https://api.github.com/users/Bakual/received_events","type":"User","site_admin":false},"created_at":"2016-05-24T10:05:06Z","updated_at":"2016-05-24T10:05:06Z","body":"Closing as we have a PR"}}
{"actor":{"display_login":"Bakual"}}