fix bugs in patches
diff --git a/erpnext/patches/v8_10/add_due_date_to_gle.py b/erpnext/patches/v8_10/add_due_date_to_gle.py
index 047c883..ec5e003 100644
--- a/erpnext/patches/v8_10/add_due_date_to_gle.py
+++ b/erpnext/patches/v8_10/add_due_date_to_gle.py
@@ -4,4 +4,4 @@
def execute():
if not frappe.db.has_column("GL Entry", "due_date"):
- frappe.db.sql("ALTER TABLE `tabGL Entry` ADD COLUMN `due_date` DATE DEFAULT NULL")
+ frappe.db.sql("ALTER TABLE `tabGL Entry` ADD COLUMN `due_date` DATE NULL")
diff --git a/erpnext/patches/v8_10/add_payment_terms_field_to_supplier.py b/erpnext/patches/v8_10/add_payment_terms_field_to_supplier.py
index c5a6fb1..b507b2a 100644
--- a/erpnext/patches/v8_10/add_payment_terms_field_to_supplier.py
+++ b/erpnext/patches/v8_10/add_payment_terms_field_to_supplier.py
@@ -4,6 +4,6 @@
def execute():
if not frappe.db.has_column("Customer", "payment_terms"):
- frappe.db.sql("ALTER TABLE `tabCustomer` ADD COLUMN `payment_terms` DATE DEFAULT NULL")
+ frappe.db.sql("ALTER TABLE `tabCustomer` ADD COLUMN `payment_terms` VARCHAR(140) NULL")
if not frappe.db.has_column("Supplier", "payment_terms"):
- frappe.db.sql("ALTER TABLE `tabSupplier` ADD COLUMN `payment_terms` DATE DEFAULT NULL")
+ frappe.db.sql("ALTER TABLE `tabSupplier` ADD COLUMN `payment_terms` VARCHAR(140) NULL")
diff --git a/erpnext/patches/v8_10/change_default_customer_credit_days.py b/erpnext/patches/v8_10/change_default_customer_credit_days.py
index c4376fa..dc52c89 100644
--- a/erpnext/patches/v8_10/change_default_customer_credit_days.py
+++ b/erpnext/patches/v8_10/change_default_customer_credit_days.py
@@ -55,7 +55,7 @@
value_query_str = " ".join(payment_terms)
cond_query_str = " ELSE `payment_terms` END WHERE "
- if customers:
+ if suppliers:
frappe.db.sql(
begin_query_str + value_query_str + cond_query_str + '`supplier_name` IN %s',
(suppliers,)