[Fix] Patch broken if serial no has single quote (#10262)
diff --git a/erpnext/patches/v8_0/set_sales_invoice_serial_number_from_delivery_note.py b/erpnext/patches/v8_0/set_sales_invoice_serial_number_from_delivery_note.py
index 2ae74cd..5dedc81 100644
--- a/erpnext/patches/v8_0/set_sales_invoice_serial_number_from_delivery_note.py
+++ b/erpnext/patches/v8_0/set_sales_invoice_serial_number_from_delivery_note.py
@@ -26,7 +26,7 @@
if not sales_invoice or not serial_nos:
continue
- serial_nos = ["'%s'"%no for no in serial_nos.split("\n")]
+ serial_nos = ["'%s'"%frappe.db.escape(no) for no in serial_nos.split("\n")]
frappe.db.sql("""
UPDATE
@@ -36,7 +36,7 @@
WHERE
name in ({serial_nos})
""".format(
- sales_invoice=sales_invoice,
+ sales_invoice=frappe.db.escape(sales_invoice),
serial_nos=",".join(serial_nos)
)
)
\ No newline at end of file