commit fc0a5833a52a329ecad5c32179f2e60cb48e5030
author Zarrar <zarrar65@gmail.com> Tue Jul 17 11:57:06 2018 +0530
committer Nabin Hait <nabinhait@gmail.com> Tue Jul 17 11:57:06 2018 +0530
tree 3a66fdb4922ea6167a8d5d5e54f5a0a88cb82ba3
parent 107dbcdff8fcd7eded4ad0952959769ba4547c05

run set query if doctype exist (#14929)

erpnext/patches/v11_0/set_department_for_doctypes.py

diff --git a/erpnext/patches/v11_0/set_department_for_doctypes.py b/erpnext/patches/v11_0/set_department_for_doctypes.py
index 8fc6656..9edadd9 100644
--- a/erpnext/patches/v11_0/set_department_for_doctypes.py
+++ b/erpnext/patches/v11_0/set_department_for_doctypes.py
@@ -10,7 +10,8 @@
         'Timesheet', 'Sales Person', 'Payroll Employee Detail']
 
     for doctype in doctypes_to_update:
-        frappe.db.sql("""
-            update `tab%s` dt
-            set department=(select department from `tabEmployee` where name=dt.employee)
-        """ % doctype)
+		if frappe.db.table_exists(doctype):
+			frappe.db.sql("""
+				update `tab%s` dt
+				set department=(select department from `tabEmployee` where name=dt.employee)
+			""" % doctype)