ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Missing column after v10->v11 update and no error

erpnext-version-11

#1

After update without any error, i found warning when use erpnext.
Missing column in various module, like HR, Project.
I need to manually create this

ALTER TABLE 1bd3e0294d.tabAttendance Request
ADD COLUMN leave_type VARCHAR(140) NULL DEFAULT NULL AFTER _liked_by;

ALTER TABLE 1bd3e0294d.tabSalary Structure Assignment
ADD COLUMN leave_type VARCHAR(140) NULL DEFAULT NULL AFTER _liked_by;

ALTER TABLE 1bd3e0294d.tabLeave Application
ADD COLUMN leave_policy VARCHAR(140) NULL DEFAULT NULL AFTER salary_slip;

ALTER TABLE 1bd3e0294d.tabLeave Allocation
ADD COLUMN leave_policy VARCHAR(140) NULL DEFAULT NULL AFTER total_leaves_encashed;

ALTER TABLE 1bd3e0294d.tabAttendance
ADD COLUMN leave_policy VARCHAR(140) NULL DEFAULT NULL AFTER attendance_request;

ALTER TABLE 1bd3e0294d.tabLeave Encashment
ADD COLUMN leave_policy VARCHAR(140) NULL DEFAULT NULL AFTER _user_tags;

ALTER TABLE 1bd3e0294d.tabEmployee Grade
ADD COLUMN employee VARCHAR(140) NULL DEFAULT NULL AFTER _user_tags;

ALTER TABLE 1bd3e0294d.tabLeave Allocation
ADD COLUMN project VARCHAR(140) NULL DEFAULT NULL AFTER leave_policy;

ALTER TABLE 1bd3e0294d.tabEmployee
ADD COLUMN project VARCHAR(140) NULL DEFAULT NULL AFTER leave_policy;

ALTER TABLE 1bd3e0294d.tabEmployee Grade
ADD COLUMN project VARCHAR(140) NULL DEFAULT NULL AFTER employee;


#2

you dont need to manually create these…

just run
bench migrate

it’ll create all required columns