{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/9254","repository_url":"https://api.github.com/repos/joomla/joomla-cms","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9254/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9254/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9254/events","html_url":"https://github.com/joomla/joomla-cms/issues/9254","id":137249347,"number":9254,"title":"Force to use HTML: Special Characters during component installation mysql queries","user":{"login":"gunjanpatel","id":2002921,"avatar_url":"https://avatars.githubusercontent.com/u/2002921?v=3","gravatar_id":"","url":"https://api.github.com/users/gunjanpatel","html_url":"https://github.com/gunjanpatel","followers_url":"https://api.github.com/users/gunjanpatel/followers","following_url":"https://api.github.com/users/gunjanpatel/following{/other_user}","gists_url":"https://api.github.com/users/gunjanpatel/gists{/gist_id}","starred_url":"https://api.github.com/users/gunjanpatel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gunjanpatel/subscriptions","organizations_url":"https://api.github.com/users/gunjanpatel/orgs","repos_url":"https://api.github.com/users/gunjanpatel/repos","events_url":"https://api.github.com/users/gunjanpatel/events{/privacy}","received_events_url":"https://api.github.com/users/gunjanpatel/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/joomla/joomla-cms/labels/No%20Code%20Attached%20Yet","name":"No Code Attached Yet","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-02-29T13:08:04Z","updated_at":"2016-03-01T04:58:37Z","closed_at":null,"body":"Not sure if it is a bug or not but found interesting.\r\n\r\n#### Steps to reproduce the issue\r\nWhile installing component I notice that my queries doesn't work in j3.5-beta3.\r\n\r\n**Query Working in J3.4x**\r\n```sql\r\nINSERT IGNORE INTO `#__redshop_mail` (`mail_id`, `mail_body`) VALUES\r\n\t(1, '<p>To Admin, {username} </p>');\r\n```\r\n\r\n**The same query is not working in J3.5-beta3. While I change query as shown below it works.**\r\n```sql\r\nINSERT IGNORE INTO `#__redshop_mail` (`mail_id`, `mail_body`) VALUES\r\n\t(1, '&lt;p&gt;To Admin,&lt;/p&gt;');\r\n```\r\nTo make it working in j3.5-beta3 I have to change,\r\n`'<p>To Admin,</p>'` to `'&lt;p&gt;To Admin, {username} &lt;/p&gt;'`\r\n\r\nNot sure what is changed in j3.5-beta3. But the same query works in j3.4.x and if I paste the query directly in mysql it works.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/190546755","html_url":"https://github.com/joomla/joomla-cms/issues/9254#issuecomment-190546755","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9254","id":190546755,"user":{"login":"gunjanpatel","id":2002921,"avatar_url":"https://avatars.githubusercontent.com/u/2002921?v=3","gravatar_id":"","url":"https://api.github.com/users/gunjanpatel","html_url":"https://github.com/gunjanpatel","followers_url":"https://api.github.com/users/gunjanpatel/followers","following_url":"https://api.github.com/users/gunjanpatel/following{/other_user}","gists_url":"https://api.github.com/users/gunjanpatel/gists{/gist_id}","starred_url":"https://api.github.com/users/gunjanpatel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gunjanpatel/subscriptions","organizations_url":"https://api.github.com/users/gunjanpatel/orgs","repos_url":"https://api.github.com/users/gunjanpatel/repos","events_url":"https://api.github.com/users/gunjanpatel/events{/privacy}","received_events_url":"https://api.github.com/users/gunjanpatel/received_events","type":"User","site_admin":false},"created_at":"2016-03-01T04:58:37Z","updated_at":"2016-03-01T04:58:37Z","body":"@andrepereiradasilva it works with 3.5.0 beta 2. Only issue in 3.5 beta 3<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/9254\">issues.joomla.org/joomla-cms/9254</a>.</sub>"}}