Update update_timesheet_communications
diff --git a/erpnext/patches/v7_0/update_timesheet_communications b/erpnext/patches/v7_0/update_timesheet_communications
index 01d3210..ac87d82 100644
--- a/erpnext/patches/v7_0/update_timesheet_communications
+++ b/erpnext/patches/v7_0/update_timesheet_communications
@@ -2,7 +2,7 @@
import frappe
def execute():
- if frappe.db.table_exists("Time Log"):
+ if frappe.db.table_exists("Time Log") and "employee" in frappe.db.get_table_columns("Time Log"):
timesheet = frappe.db.sql("""SELECT ts.name AS name, tl.name AS timelogname,
tl.modified AS modified, tl.modified_by AS modified_by, tl.creation AS creation, tl.owner AS owner
FROM
@@ -13,6 +13,10 @@
AND tl.docstatus < 2""", as_dict=1)
for data in timesheet:
+ frappe.db.sql(""" update `tabTimesheet` set creation = %(creation)s,
+ owner = %(owner)s, modified = %(modified)s, modified_by = %(modified_by)s
+ where name = %(name)s""", data)
+
frappe.db.sql("""
update
tabCommunication