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.
{
"unresolved_ranges": [
{
"source": "CPE_STRING",
"cpes": [
"cpe:2.3:a:frappe:erpnext:11.0.3:beta10:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta11:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta12:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta13:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta14:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta15:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta16:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta17:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta18:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta19:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta20:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta21:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta22:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta23:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta24:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta25:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta26:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta27:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta28:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta29:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta2:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta3:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta4:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta5:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta6:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta7:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta8:*:*:*:*:*:*",
"cpe:2.3:a:frappe:erpnext:11.0.3:beta9:*:*:*:*:*:*"
],
"vendor_product": "frappe:erpnext",
"extracted_events": [
{
"introduced": "11.0.3-beta10"
},
{
"last_affected": "11.0.3-beta10"
},
{
"introduced": "11.0.3-beta11"
},
{
"last_affected": "11.0.3-beta11"
},
{
"introduced": "11.0.3-beta12"
},
{
"last_affected": "11.0.3-beta12"
},
{
"introduced": "11.0.3-beta13"
},
{
"last_affected": "11.0.3-beta13"
},
{
"introduced": "11.0.3-beta14"
},
{
"last_affected": "11.0.3-beta14"
},
{
"introduced": "11.0.3-beta15"
},
{
"last_affected": "11.0.3-beta15"
},
{
"introduced": "11.0.3-beta16"
},
{
"last_affected": "11.0.3-beta16"
},
{
"introduced": "11.0.3-beta17"
},
{
"last_affected": "11.0.3-beta17"
},
{
"introduced": "11.0.3-beta18"
},
{
"last_affected": "11.0.3-beta18"
},
{
"introduced": "11.0.3-beta19"
},
{
"last_affected": "11.0.3-beta19"
},
{
"introduced": "11.0.3-beta2"
},
{
"last_affected": "11.0.3-beta2"
},
{
"introduced": "11.0.3-beta20"
},
{
"last_affected": "11.0.3-beta20"
},
{
"introduced": "11.0.3-beta21"
},
{
"last_affected": "11.0.3-beta21"
},
{
"introduced": "11.0.3-beta22"
},
{
"last_affected": "11.0.3-beta22"
},
{
"introduced": "11.0.3-beta23"
},
{
"last_affected": "11.0.3-beta23"
},
{
"introduced": "11.0.3-beta24"
},
{
"last_affected": "11.0.3-beta24"
},
{
"introduced": "11.0.3-beta25"
},
{
"last_affected": "11.0.3-beta25"
},
{
"introduced": "11.0.3-beta26"
},
{
"last_affected": "11.0.3-beta26"
},
{
"introduced": "11.0.3-beta27"
},
{
"last_affected": "11.0.3-beta27"
},
{
"introduced": "11.0.3-beta28"
},
{
"last_affected": "11.0.3-beta28"
},
{
"introduced": "11.0.3-beta29"
},
{
"last_affected": "11.0.3-beta29"
},
{
"introduced": "11.0.3-beta3"
},
{
"last_affected": "11.0.3-beta3"
},
{
"introduced": "11.0.3-beta4"
},
{
"last_affected": "11.0.3-beta4"
},
{
"introduced": "11.0.3-beta5"
},
{
"last_affected": "11.0.3-beta5"
},
{
"introduced": "11.0.3-beta6"
},
{
"last_affected": "11.0.3-beta6"
},
{
"introduced": "11.0.3-beta7"
},
{
"last_affected": "11.0.3-beta7"
},
{
"introduced": "11.0.3-beta8"
},
{
"last_affected": "11.0.3-beta8"
},
{
"introduced": "11.0.3-beta9"
},
{
"last_affected": "11.0.3-beta9"
}
]
}
]
}{
"cpe": "cpe:2.3:a:frappe:erpnext:*:*:*:*:*:*:*:*",
"extracted_events": [
{
"introduced": "10.0.0"
},
{
"last_affected": "10.1.76"
},
{
"introduced": "11.0.0"
},
{
"fixed": "11.0.3"
}
],
"source": "CPE_RANGE"
}