{"action":"closed","number":15220,"pull_request":{"url":"https://api.github.com/repos/frappe/erpnext/pulls/15220","id":210935567,"node_id":"MDExOlB1bGxSZXF1ZXN0MjEwOTM1NTY3","html_url":"https://github.com/frappe/erpnext/pull/15220","diff_url":"https://github.com/frappe/erpnext/pull/15220.diff","patch_url":"https://github.com/frappe/erpnext/pull/15220.patch","issue_url":"https://api.github.com/repos/frappe/erpnext/issues/15220","number":15220,"state":"closed","locked":false,"title":"[Fix] Speacial character issue in searching project in sales invoice","user":{"login":"rohitwaghchaure","id":8780500,"node_id":"MDQ6VXNlcjg3ODA1MDA=","avatar_url":"https://avatars0.githubusercontent.com/u/8780500?v=4","gravatar_id":"","url":"https://api.github.com/users/rohitwaghchaure","html_url":"https://github.com/rohitwaghchaure","followers_url":"https://api.github.com/users/rohitwaghchaure/followers","following_url":"https://api.github.com/users/rohitwaghchaure/following{/other_user}","gists_url":"https://api.github.com/users/rohitwaghchaure/gists{/gist_id}","starred_url":"https://api.github.com/users/rohitwaghchaure/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rohitwaghchaure/subscriptions","organizations_url":"https://api.github.com/users/rohitwaghchaure/orgs","repos_url":"https://api.github.com/users/rohitwaghchaure/repos","events_url":"https://api.github.com/users/rohitwaghchaure/events{/privacy}","received_events_url":"https://api.github.com/users/rohitwaghchaure/received_events","type":"User","site_admin":false},"body":"**Issue**\r\n```\r\nTraceback (most recent call last):\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/apps/frappe/frappe/app.py\", line 62, in application\r\n    response = frappe.handler.handle()\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/apps/frappe/frappe/handler.py\", line 22, in handle\r\n    data = execute_cmd(cmd)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/apps/frappe/frappe/handler.py\", line 53, in execute_cmd\r\n    return frappe.call(method, **frappe.form_dict)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/apps/frappe/frappe/__init__.py\", line 939, in call\r\n    return fn(*args, **newargs)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/apps/frappe/frappe/desk/search.py\", line 51, in search_link\r\n    search_widget(doctype, txt, query, searchfield=searchfield, page_length=page_length, filters=filters)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/apps/frappe/frappe/desk/search.py\", line 75, in search_widget\r\n    searchfield, start, page_length, filters, as_dict=as_dict)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/apps/frappe/frappe/__init__.py\", line 939, in call\r\n    return fn(*args, **newargs)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/apps/erpnext/erpnext/controllers/queries.py\", line 236, in get_project_name\r\n    \"_txt\": txt.replace('%', '')\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/apps/frappe/frappe/database.py\", line 166, in sql\r\n    self._cursor.execute(query, values)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/env/lib/python2.7/site-packages/pymysql/cursors.py\", line 165, in execute\r\n    result = self._query(query)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/env/lib/python2.7/site-packages/pymysql/cursors.py\", line 321, in _query\r\n    conn.query(q)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py\", line 860, in query\r\n    self._affected_rows = self._read_query_result(unbuffered=unbuffered)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py\", line 1061, in _read_query_result\r\n    result.read()\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py\", line 1349, in read\r\n    first_packet = self.connection._read_packet()\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py\", line 1018, in _read_packet\r\n    packet.check_error()\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py\", line 384, in check_error\r\n    err.raise_mysql_exception(self._data)\r\n  File \"/Users/rohitwaghchaure/Documents/new_erpnext/frappe-bench/env/lib/python2.7/site-packages/pymysql/err.py\", line 107, in raise_mysql_exception\r\n    raise errorclass(errno, errval)\r\nProgrammingError: (1064, u'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \\'\\u041c\\u0406\\u0420\\u0410\\u0422\\u0415\\u0425 \\u041a\\u041e\\u0420\\u041f\\u041e\\u0420\\u0410\\u0426\\u0406\\u042f\"TOB\" or ifnull(`tabProject`.customer,\"\")=\"\")\\' at line 3')\r\n```","created_at":"2018-08-26T05:45:13Z","updated_at":"2018-08-27T06:13:58Z","closed_at":"2018-08-27T06:13:58Z","merged_at":"2018-08-27T06:13:58Z","merge_commit_sha":"e33047250e66ac10e2d0be16262ed744e3c08af7","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/frappe/erpnext/pulls/15220/commits","review_comments_url":"https://api.github.com/repos/frappe/erpnext/pulls/15220/comments","review_comment_url":"https://api.github.com/repos/frappe/erpnext/pulls/comments{/number}","comments_url":"https://api.github.com/repos/frappe/erpnext/issues/15220/comments","statuses_url":"https://api.github.com/repos/frappe/erpnext/statuses/5e263c159a98d3a22550d82366096e88dc5681a0","head":{"label":"rohitwaghchaure:project_search_issue_sales_invoice","ref":"project_search_issue_sales_invoice","sha":"5e263c159a98d3a22550d82366096e88dc5681a0","user":{"login":"rohitwaghchaure","id":8780500,"node_id":"MDQ6VXNlcjg3ODA1MDA=","avatar_url":"https://avatars0.githubusercontent.com/u/8780500?v=4","gravatar_id":"","url":"https://api.github.com/users/rohitwaghchaure","html_url":"https://github.com/rohitwaghchaure","followers_url":"https://api.github.com/users/rohitwaghchaure/followers","following_url":"https://api.github.com/users/rohitwaghchaure/following{/other_user}","gists_url":"https://api.github.com/users/rohitwaghchaure/gists{/gist_id}","starred_url":"https://api.github.com/users/rohitwaghchaure/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rohitwaghchaure/subscriptions","organizations_url":"https://api.github.com/users/rohitwaghchaure/orgs","repos_url":"https://api.github.com/users/rohitwaghchaure/repos","events_url":"https://api.github.com/users/rohitwaghchaure/events{/privacy}","received_events_url":"https://api.github.com/users/rohitwaghchaure/received_events","type":"User","site_admin":false},"repo":{"id":52080333,"node_id":"MDEwOlJlcG9zaXRvcnk1MjA4MDMzMw==","name":"erpnext_develop","full_name":"rohitwaghchaure/erpnext_develop","owner":{"login":"rohitwaghchaure","id":8780500,"node_id":"MDQ6VXNlcjg3ODA1MDA=","avatar_url":"https://avatars0.githubusercontent.com/u/8780500?v=4","gravatar_id":"","url":"https://api.github.com/users/rohitwaghchaure","html_url":"https://github.com/rohitwaghchaure","followers_url":"https://api.github.com/users/rohitwaghchaure/followers","following_url":"https://api.github.com/users/rohitwaghchaure/following{/other_user}","gists_url":"https://api.github.com/users/rohitwaghchaure/gists{/gist_id}","starred_url":"https://api.github.com/users/rohitwaghchaure/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rohitwaghchaure/subscriptions","organizations_url":"https://api.github.com/users/rohitwaghchaure/orgs","repos_url":"https://api.github.com/users/rohitwaghchaure/repos","events_url":"https://api.github.com/users/rohitwaghchaure/events{/privacy}","received_events_url":"https://api.github.com/users/rohitwaghchaure/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/rohitwaghchaure/erpnext_develop","description":"Open Source ERP built for the Web. Uses Python, MariaDB.","fork":true,"url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop","forks_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/forks","keys_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/keys{/key_id}","collaborators_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/teams","hooks_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/hooks","issue_events_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/issues/events{/number}","events_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/events","assignees_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/assignees{/user}","branches_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/branches{/branch}","tags_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/tags","blobs_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/git/refs{/sha}","trees_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/git/trees{/sha}","statuses_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/statuses/{sha}","languages_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/languages","stargazers_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/stargazers","contributors_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/contributors","subscribers_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/subscribers","subscription_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/subscription","commits_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/commits{/sha}","git_commits_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/git/commits{/sha}","comments_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/comments{/number}","issue_comment_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/issues/comments{/number}","contents_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/contents/{+path}","compare_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/compare/{base}...{head}","merges_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/merges","archive_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/downloads","issues_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/issues{/number}","pulls_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/pulls{/number}","milestones_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/milestones{/number}","notifications_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/labels{/name}","releases_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/releases{/id}","deployments_url":"https://api.github.com/repos/rohitwaghchaure/erpnext_develop/deployments","created_at":"2016-02-19T10:24:57Z","updated_at":"2017-03-14T07:57:05Z","pushed_at":"2018-08-26T05:44:47Z","git_url":"git://github.com/rohitwaghchaure/erpnext_develop.git","ssh_url":"git@github.com:rohitwaghchaure/erpnext_develop.git","clone_url":"https://github.com/rohitwaghchaure/erpnext_develop.git","svn_url":"https://github.com/rohitwaghchaure/erpnext_develop","homepage":"http://erpnext.com","size":620416,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"gpl-3.0","name":"GNU General Public License v3.0","spdx_id":"GPL-3.0","url":"https://api.github.com/licenses/gpl-3.0","node_id":"MDc6TGljZW5zZTk="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"develop"}},"base":{"label":"frappe:hotfix","ref":"hotfix","sha":"c4e38ffd4dc78dfccb799cda73c1c408e7cf284e","user":{"login":"frappe","id":836974,"node_id":"MDEyOk9yZ2FuaXphdGlvbjgzNjk3NA==","avatar_url":"https://avatars2.githubusercontent.com/u/836974?v=4","gravatar_id":"","url":"https://api.github.com/users/frappe","html_url":"https://github.com/frappe","followers_url":"https://api.github.com/users/frappe/followers","following_url":"https://api.github.com/users/frappe/following{/other_user}","gists_url":"https://api.github.com/users/frappe/gists{/gist_id}","starred_url":"https://api.github.com/users/frappe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frappe/subscriptions","organizations_url":"https://api.github.com/users/frappe/orgs","repos_url":"https://api.github.com/users/frappe/repos","events_url":"https://api.github.com/users/frappe/events{/privacy}","received_events_url":"https://api.github.com/users/frappe/received_events","type":"Organization","site_admin":false},"repo":{"id":1864233,"node_id":"MDEwOlJlcG9zaXRvcnkxODY0MjMz","name":"erpnext","full_name":"frappe/erpnext","owner":{"login":"frappe","id":836974,"node_id":"MDEyOk9yZ2FuaXphdGlvbjgzNjk3NA==","avatar_url":"https://avatars2.githubusercontent.com/u/836974?v=4","gravatar_id":"","url":"https://api.github.com/users/frappe","html_url":"https://github.com/frappe","followers_url":"https://api.github.com/users/frappe/followers","following_url":"https://api.github.com/users/frappe/following{/other_user}","gists_url":"https://api.github.com/users/frappe/gists{/gist_id}","starred_url":"https://api.github.com/users/frappe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frappe/subscriptions","organizations_url":"https://api.github.com/users/frappe/orgs","repos_url":"https://api.github.com/users/frappe/repos","events_url":"https://api.github.com/users/frappe/events{/privacy}","received_events_url":"https://api.github.com/users/frappe/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/frappe/erpnext","description":"Open Source ERP built for the web","fork":false,"url":"https://api.github.com/repos/frappe/erpnext","forks_url":"https://api.github.com/repos/frappe/erpnext/forks","keys_url":"https://api.github.com/repos/frappe/erpnext/keys{/key_id}","collaborators_url":"https://api.github.com/repos/frappe/erpnext/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/frappe/erpnext/teams","hooks_url":"https://api.github.com/repos/frappe/erpnext/hooks","issue_events_url":"https://api.github.com/repos/frappe/erpnext/issues/events{/number}","events_url":"https://api.github.com/repos/frappe/erpnext/events","assignees_url":"https://api.github.com/repos/frappe/erpnext/assignees{/user}","branches_url":"https://api.github.com/repos/frappe/erpnext/branches{/branch}","tags_url":"https://api.github.com/repos/frappe/erpnext/tags","blobs_url":"https://api.github.com/repos/frappe/erpnext/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/frappe/erpnext/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/frappe/erpnext/git/refs{/sha}","trees_url":"https://api.github.com/repos/frappe/erpnext/git/trees{/sha}","statuses_url":"https://api.github.com/repos/frappe/erpnext/statuses/{sha}","languages_url":"https://api.github.com/repos/frappe/erpnext/languages","stargazers_url":"https://api.github.com/repos/frappe/erpnext/stargazers","contributors_url":"https://api.github.com/repos/frappe/erpnext/contributors","subscribers_url":"https://api.github.com/repos/frappe/erpnext/subscribers","subscription_url":"https://api.github.com/repos/frappe/erpnext/subscription","commits_url":"https://api.github.com/repos/frappe/erpnext/commits{/sha}","git_commits_url":"https://api.github.com/repos/frappe/erpnext/git/commits{/sha}","comments_url":"https://api.github.com/repos/frappe/erpnext/comments{/number}","issue_comment_url":"https://api.github.com/repos/frappe/erpnext/issues/comments{/number}","contents_url":"https://api.github.com/repos/frappe/erpnext/contents/{+path}","compare_url":"https://api.github.com/repos/frappe/erpnext/compare/{base}...{head}","merges_url":"https://api.github.com/repos/frappe/erpnext/merges","archive_url":"https://api.github.com/repos/frappe/erpnext/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/frappe/erpnext/downloads","issues_url":"https://api.github.com/repos/frappe/erpnext/issues{/number}","pulls_url":"https://api.github.com/repos/frappe/erpnext/pulls{/number}","milestones_url":"https://api.github.com/repos/frappe/erpnext/milestones{/number}","notifications_url":"https://api.github.com/repos/frappe/erpnext/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/frappe/erpnext/labels{/name}","releases_url":"https://api.github.com/repos/frappe/erpnext/releases{/id}","deployments_url":"https://api.github.com/repos/frappe/erpnext/deployments","created_at":"2011-06-08T08:20:56Z","updated_at":"2018-08-26T05:50:23Z","pushed_at":"2018-08-27T06:13:58Z","git_url":"git://github.com/frappe/erpnext.git","ssh_url":"git@github.com:frappe/erpnext.git","clone_url":"https://github.com/frappe/erpnext.git","svn_url":"https://github.com/frappe/erpnext","homepage":"http://erpnext.com","size":624222,"stargazers_count":3670,"watchers_count":3670,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":1718,"mirror_url":null,"archived":false,"open_issues_count":1627,"license":{"key":"gpl-3.0","name":"GNU General Public License v3.0","spdx_id":"GPL-3.0","url":"https://api.github.com/licenses/gpl-3.0","node_id":"MDc6TGljZW5zZTk="},"forks":1718,"open_issues":1627,"watchers":3670,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/frappe/erpnext/pulls/15220"},"html":{"href":"https://github.com/frappe/erpnext/pull/15220"},"issue":{"href":"https://api.github.com/repos/frappe/erpnext/issues/15220"},"comments":{"href":"https://api.github.com/repos/frappe/erpnext/issues/15220/comments"},"review_comments":{"href":"https://api.github.com/repos/frappe/erpnext/pulls/15220/comments"},"review_comment":{"href":"https://api.github.com/repos/frappe/erpnext/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/frappe/erpnext/pulls/15220/commits"},"statuses":{"href":"https://api.github.com/repos/frappe/erpnext/statuses/5e263c159a98d3a22550d82366096e88dc5681a0"}},"author_association":"CONTRIBUTOR","merged":true,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":{"login":"nabinhait","id":836784,"node_id":"MDQ6VXNlcjgzNjc4NA==","avatar_url":"https://avatars2.githubusercontent.com/u/836784?v=4","gravatar_id":"","url":"https://api.github.com/users/nabinhait","html_url":"https://github.com/nabinhait","followers_url":"https://api.github.com/users/nabinhait/followers","following_url":"https://api.github.com/users/nabinhait/following{/other_user}","gists_url":"https://api.github.com/users/nabinhait/gists{/gist_id}","starred_url":"https://api.github.com/users/nabinhait/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nabinhait/subscriptions","organizations_url":"https://api.github.com/users/nabinhait/orgs","repos_url":"https://api.github.com/users/nabinhait/repos","events_url":"https://api.github.com/users/nabinhait/events{/privacy}","received_events_url":"https://api.github.com/users/nabinhait/received_events","type":"User","site_admin":false},"comments":0,"review_comments":0,"maintainer_can_modify":false,"commits":1,"additions":2,"deletions":1,"changed_files":1}}
{"actor":{"display_login":"nabinhait"}}