frappe · ankush · Feb 12, 2024 · Feb 12, 2024
diff --git a/frappe/database/schema.py b/frappe/database/schema.py
@@ -353,13 +353,8 @@ def get_definition(fieldtype, precision=None, length=None):
 
 
 def add_column(doctype, column_name, fieldtype, precision=None, length=None, default=None, not_null=False):
-	if column_name in frappe.db.get_table_columns(doctype):
-		# already exists
-		return
-
 	frappe.db.commit()
-
-	query = "alter table `tab{}` add column {} {}".format(
+	query = "alter table `tab{}` add column if not exists {} {}".format(
 		doctype,
 		column_name,
 		get_definition(fieldtype, precision, length),

diff --git a/frappe/migrate.py b/frappe/migrate.py
@@ -76,6 +76,7 @@ def setUp(self):
 		"""Complete setup required for site migration"""
 		frappe.flags.touched_tables = set()
 		self.touched_tables_file = frappe.get_site_path("touched_tables.json")
+		frappe.clear_cache()
 		add_column(doctype="DocType", column_name="migration_hash", fieldtype="Data")
 		clear_global_cache()