Fix error in patch due to single quote in name
diff --git a/erpnext/patches/jan_mar_2012/customer_address_contact_patch.py b/erpnext/patches/jan_mar_2012/customer_address_contact_patch.py
index 6a7d405..b55acd4 100644
--- a/erpnext/patches/jan_mar_2012/customer_address_contact_patch.py
+++ b/erpnext/patches/jan_mar_2012/customer_address_contact_patch.py
@@ -31,7 +31,7 @@
GROUP BY sales_partner HAVING SUM(IFNULL(is_primary_contact, 0))=0
)
""", as_list=1)
- names = ", ".join(["'" + str(r[0]) + "'" for r in res if r])
+ names = ", ".join(['"' + str(r[0]) + '"' for r in res if r])
if names: webnotes.conn.sql("UPDATE `tabContact` SET is_primary_contact=1 WHERE name IN (%s)" % names)
def patch_primary_address():
@@ -54,5 +54,5 @@
AND SUM(IFNULL(is_shipping_address, 0))=0
)
""", as_list=1)
- names = ", ".join(["'" + str(r[0]) + "'" for r in res if r])
+ names = ", ".join(['"' + str(r[0]) + '"' for r in res if r])
if names: webnotes.conn.sql("UPDATE `tabAddress` SET is_primary_address=1 WHERE name IN (%s)" % names)