commit 6578bc11b6e24decd9feb92e56be11f1f21e7fa8
author Zarrar <zarrar65@gmail.com> Thu Mar 01 10:54:55 2018 +0530
committer Nabin Hait <nabinhait@gmail.com> Thu Mar 01 10:54:55 2018 +0530
tree a770ca89ab471d3488ebf65dc9540ae4a367e287
parent f68dc69078cc51c5655d49ea56717bdfbf1a8a74

wrong query formed to delete events (#13119)

erpnext/utilities/transaction_base.py

diff --git a/erpnext/utilities/transaction_base.py b/erpnext/utilities/transaction_base.py
index 0032e80..341c511 100644
--- a/erpnext/utilities/transaction_base.py
+++ b/erpnext/utilities/transaction_base.py
@@ -43,7 +43,7 @@
 		events = frappe.db.sql_list("""select name from `tabEvent`
 			where ref_type=%s and ref_name=%s""", (self.doctype, self.name))
 		if events:
-			frappe.db.sql("delete from `tabEvent` where name in (%s)"
+			frappe.db.sql("delete from `tabEvent` where name in ({0})"
 				.format(", ".join(['%s']*len(events))), tuple(events))
 
 	def _add_calendar_event(self, opts):