commit 26943184e60b424358c8f6bb91a2a716b2f01f8a
author rohitwaghchaure <rohitw1991@gmail.com> Tue Jun 12 01:16:52 2018 +0530
committer GitHub <noreply@github.com> Tue Jun 12 01:16:52 2018 +0530
tree e0d16bc15b16358f4e7873e8bba6605e70be0447
parent b81e3847531ec8d7219f8f519286149ce2f4b937
parent ec2a2ac47e655261a42cb80c73188e42f53c164c

Merge pull request #14471 from rohitwaghchaure/fix_patch_update_total_qty_field

[Fix] patch

erpnext/patches/v11_0/update_total_qty_field.py

diff --git a/erpnext/patches/v11_0/update_total_qty_field.py b/erpnext/patches/v11_0/update_total_qty_field.py
index 6f78d8a..c5d27d2 100644
--- a/erpnext/patches/v11_0/update_total_qty_field.py
+++ b/erpnext/patches/v11_0/update_total_qty_field.py
@@ -28,7 +28,8 @@
 				when dt.name = '{0}' then {1}
 			""".format(frappe.db.escape(d.get("parent")), d.get("qty")))
 
-		frappe.db.sql('''
-			UPDATE
-				`tab%s` dt SET dt.total_qty = CASE %s END
-		''' % (doctype, " ".join(when_then)))
\ No newline at end of file
+		if when_then:
+			frappe.db.sql('''
+				UPDATE
+					`tab%s` dt SET dt.total_qty = CASE %s END
+			''' % (doctype, " ".join(when_then)))
\ No newline at end of file