{"schemaVersion":3,"id":"CVE-2018-20061","aliases":[],"status":"published","duplicateOf":null,"title":null,"description":"A SQL injection issue was discovered in ERPNext 10.x and 11.x through 11.0.3-beta.29. This attack is only available to a logged-in user; however, many ERPNext sites allow account creation via the web. No special privileges are needed to conduct the attack. By calling a JavaScript function that calls a server-side Python function with carefully chosen arguments, a SQL attack can be carried out which allows SQL queries to be constructed to return any columns from any tables in the database. This is related to /api/resource/Item?fields= URIs, frappe.get_list, and frappe.call.","dates":{"published":"2018-12-11T17:00:00.000Z","modified":"2024-08-05T11:51:18.930Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":7.5,"severity":"high","version":"3.0","versionLabel":"v3.0","source":"NVD","vector":"CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N","computed":false,"selection":"backend-summary"},"metrics":[{"version":"3.0","versionLabel":"v3.0","source":"NVD","score":7.5,"severity":"high","vector":"CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N","exploitability":null,"impact":null,"computed":false},{"version":"2.0","versionLabel":"v2.0","source":"NVD","score":5,"severity":"medium","vector":"AV:N/AC:L/Au:N/C:P/I:N/A:N","exploitability":null,"impact":null,"computed":false}]},"epss":{"probability":0.01433,"percentile":0.72831,"severity":"low","asOf":"2026-10-21T00:00:00.000Z","change":{"pp":0.15800000000000014,"baselineDate":"2026-09-21T00:00:00.000Z","baselineScore":0.01275},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.01275,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-20T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-21T00:00:00.000Z","score":0.01433,"percentile":0.72831}],"last30":[{"date":"2026-09-21T00:00:00.000Z","score":0.01275,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-20T00:00:00.000Z","score":0.01433,"percentile":null},{"date":"2026-10-21T00:00:00.000Z","score":0.01433,"percentile":0.72831}]},"kev":{"state":"not-listed","entries":[],"listedCount":0,"totalCatalogs":3,"catalogs":[{"source":"cisa","label":"CISA","listed":false,"entry":null},{"source":"enisa","label":"ENISA","listed":false,"entry":null},{"source":"circl","label":"CIRCL","listed":false,"entry":null}]},"ransomware":{"state":"none-recorded","sources":[]},"exploits":[],"exploitCount":0,"weaknesses":[{"id":"CWE-89","name":"Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')","description":"The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.","type":"weakness","status":"Stable","abstraction":"Base","likelihoodOfExploit":"High","url":"https://cwe.mitre.org/data/definitions/89.html"}],"affected":[{"vendor":"frappe","product":"erpnext","name":"erpnext","label":"erpnext","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"≥ 10.0.0, ≤ 10.1.76","noFixRecorded":false,"fixedIn":null},{"text":"≥ 11.0.0, < 11.0.3","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta10","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta11","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta12","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta13","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta14","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta15","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta16","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta17","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta18","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta19","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta2","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta20","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta21","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta22","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta23","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta24","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta25","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta26","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta27","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta28","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta29","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta3","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta4","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta5","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta6","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta7","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta8","noFixRecorded":false,"fixedIn":null},{"text":"11.0.3:beta9","noFixRecorded":false,"fixedIn":null}],"versionsText":"≥ 10.0.0, ≤ 10.1.76 | ≥ 11.0.0, < 11.0.3 | 11.0.3:beta10 | 11.0.3:beta11 | 11.0.3:beta12 | 11.0.3:beta13 | 11.0.3:beta14 | 11.0.3:beta15 | 11.0.3:beta16 | 11.0.3:beta17 | 11.0.3:beta18 | 11.0.3:beta19 | 11.0.3:beta2 | 11.0.3:beta20 | 11.0.3:beta21 | 11.0.3:beta22 | 11.0.3:beta23 | 11.0.3:beta24 | 11.0.3:beta25 | 11.0.3:beta26 | 11.0.3:beta27 | 11.0.3:beta28 | 11.0.3:beta29 | 11.0.3:beta3 | 11.0.3:beta4 | 11.0.3:beta5 | 11.0.3:beta6 | 11.0.3:beta7 | 11.0.3:beta8 | 11.0.3:beta9","eol":null,"hubHref":"/vendor/frappe/erpnext"}],"affectedCount":1,"eol":{"hasEol":false,"count":0},"references":[{"url":"https://github.com/frappe/erpnext/issues/15337","label":"github.com/frappe/erpnext/issues/15337","hostname":"github.com","tags":["X Refsource MISC","Third Party Advisory"]}],"lineage":{"upstream":[],"downstream":[],"duplicates":[],"related":[]},"timeline":[{"kind":"published","date":"2018-12-11T17:00:00.000Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2024-08-05T11:51:18.930Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":30,"level":"medium","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-21T18:42:26.083Z","stale":false,"partial":false}}