{"action":"closed","issue":{"url":"https://api.github.com/repos/sbpp/sourcebans-pp/issues/339","repository_url":"https://api.github.com/repos/sbpp/sourcebans-pp","labels_url":"https://api.github.com/repos/sbpp/sourcebans-pp/issues/339/labels{/name}","comments_url":"https://api.github.com/repos/sbpp/sourcebans-pp/issues/339/comments","events_url":"https://api.github.com/repos/sbpp/sourcebans-pp/issues/339/events","html_url":"https://github.com/sbpp/sourcebans-pp/issues/339","id":249933645,"number":339,"title":"Verify Insert Query Failed: Incorrect string value","user":{"login":"Darkhost","id":3215313,"avatar_url":"https://avatars0.githubusercontent.com/u/3215313?v=4","gravatar_id":"","url":"https://api.github.com/users/Darkhost","html_url":"https://github.com/Darkhost","followers_url":"https://api.github.com/users/Darkhost/followers","following_url":"https://api.github.com/users/Darkhost/following{/other_user}","gists_url":"https://api.github.com/users/Darkhost/gists{/gist_id}","starred_url":"https://api.github.com/users/Darkhost/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Darkhost/subscriptions","organizations_url":"https://api.github.com/users/Darkhost/orgs","repos_url":"https://api.github.com/users/Darkhost/repos","events_url":"https://api.github.com/users/Darkhost/events{/privacy}","received_events_url":"https://api.github.com/users/Darkhost/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2017-08-14T05:02:42Z","updated_at":"2017-09-16T15:09:35Z","closed_at":"2017-09-16T15:09:35Z","author_association":"NONE","body":"<!--- Provide a general summary of the issue in the Title above -->\r\n\r\n## Expected Behavior\r\n<!--- If you're describing a bug, tell us what should happen -->\r\n<!--- If you're suggesting a change/improvement, tell us how it should work -->\r\nBan Register in SourceBans Website, And DB\r\n\r\n## Current Behavior\r\n<!--- If describing a bug, tell us what happens instead of the expected behavior -->\r\n<!--- If suggesting a change/improvement, explain the difference from current behavior -->\r\nTry In-Game Ban include Korean Reason, but can't register ban in Database\r\n(If Reason Write English, I can add ban.)\r\nsourcebans.log Error : L 08/14/2017 - 13:06:26: [sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\\xED \\x85 \\x8C ...' for column 'reason' at row 1\r\n(I'm Korean, So Our Server's Ban Reason is Korean Lanaguage)\r\n\r\n## Possible Solution\r\n<!--- Not obligatory, but suggest a fix/reason for the bug, -->\r\n<!--- or ideas how to implement the addition or change -->\r\n\r\n\r\n## Steps to Reproduce (for bugs)\r\n<!--- Provide a link to a live example, or an unambiguous set of steps to -->\r\n<!--- reproduce this bug. Include code to reproduce, if relevant -->\r\n1. Ban Player include Korean Language Reason (ex. 테스트)\r\n2. Can't find Ban Infomation.\r\n3. sourcebans.log : L 08/14/2017 - 13:06:26: [sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\\xED \\x85 \\x8C ...' for column 'reason' at row 1\r\n\r\n## Context\r\n<!--- How has this issue affected you? What are you trying to accomplish? -->\r\n<!--- Providing context helps us come up with a solution that is most useful in the real world -->\r\nI'm Korean So We need Korean Reason, but We can't add Ban include Korean Language Reason.\r\nI change MySQL characterset\r\nServer characterset:    utf8mb4\r\nDb     characterset:    utf8mb4\r\nClient characterset:    utf8mb4\r\nConn.  characterset:    utf8mb4\r\n\r\nBut Nothing Change. We still can't ban user.\r\n\r\n## Your Environment\r\n<!--- Include as many relevant details about the environment you experienced the bug in -->\r\n* Version used: 1.6.2\r\n* PHP and MySQL version: PHP : 7.0.22-0ubuntu0.16.04.1 / MySQL : 5.7.19-0ubuntu0.16.04.1 - (Ubuntu)\r\n* Operating System and version: Ubuntu 16.04.3 LTS\r\n* Link to your project: http://sb.hdshouse.me/\r\n* Link to gist with phpinfo() output: http://sb.hdshouse.me/phpinfo.php\r\n"}}
{"actor":{"display_login":"Darkhost"}}