Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Migration issue during an upgrade v1.2.1 -> v1.2.2 #482

Open
Roboman341 opened this issue Feb 3, 2025 · 2 comments
Open

Migration issue during an upgrade v1.2.1 -> v1.2.2 #482

Roboman341 opened this issue Feb 3, 2025 · 2 comments

Comments

@Roboman341
Copy link

Roboman341 commented Feb 3, 2025 •
edited
Loading

Bug Report

Description

After running the "python3 manage.py makemigrations && python3 manage.py migrate" commands I can see such error logs from the horilla-app:

Traceback (most recent call last): File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) psycopg2.errors.UndefinedColumn: column auth_user.is_new_employee does not exist

Traceback (most recent call last): File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) psycopg2.errors.UndefinedColumn: column leave_leavetype.carryforward_expire_date does not exist

Detailed trace

2025-02-03 11:29:53 +0000] [1] [INFO] Starting gunicorn 23.0.0
[2025-02-03 11:29:53 +0000] [1] [INFO] Listening at: http://0.0.0.0:8000 (1)
[2025-02-03 11:29:53 +0000] [1] [INFO] Using worker: sync
[2025-02-03 11:29:53 +0000] [7] [INFO] Booting worker with pid: 7
Internal Server Error: /login/
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column auth_user.is_new_employee does not exist
LINE 1: ...uth_user"."is_active", "auth_user"."date_joined", "auth_user...
                                                             ^


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
  File "/usr/local/lib/python3.10/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/app/base/views.py", line 603, in login_user
    request, "login.html", {"initialize_database": initialize_database_condition()}
  File "/app/base/views.py", line 222, in initialize_database_condition
    for user in superusers:
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 398, in __iter__
    self._fetch_all()
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1881, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 91, in __iter__
    results = compiler.execute_sql(
  File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 102, in execute
    return super().execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
    with self.db.wrap_database_errors:
  File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column auth_user.is_new_employee does not exist
LINE 1: ...uth_user"."is_active", "auth_user"."date_joined", "auth_user...
                                                             ^

Internal Server Error: /login/
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column auth_user.is_new_employee does not exist
LINE 1: ...uth_user"."is_active", "auth_user"."date_joined", "auth_user...
                                                             ^


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
  File "/usr/local/lib/python3.10/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/app/base/views.py", line 603, in login_user
    request, "login.html", {"initialize_database": initialize_database_condition()}
  File "/app/base/views.py", line 222, in initialize_database_condition
    for user in superusers:
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 398, in __iter__
    self._fetch_all()
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1881, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 91, in __iter__
    results = compiler.execute_sql(
  File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 102, in execute
    return super().execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
    with self.db.wrap_database_errors:
  File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column auth_user.is_new_employee does not exist
LINE 1: ...uth_user"."is_active", "auth_user"."date_joined", "auth_user...
                                                             ^

Internal Server Error: /login/
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column auth_user.is_new_employee does not exist
LINE 1: ...uth_user"."is_active", "auth_user"."date_joined", "auth_user...
                                                             ^

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
  File "/usr/local/lib/python3.10/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/app/base/views.py", line 603, in login_user
    request, "login.html", {"initialize_database": initialize_database_condition()}
  File "/app/base/views.py", line 222, in initialize_database_condition
    for user in superusers:
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 398, in __iter__
    self._fetch_all()
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1881, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 91, in __iter__
    results = compiler.execute_sql(
  File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 102, in execute
    return super().execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
    with self.db.wrap_database_errors:
  File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column auth_user.is_new_employee does not exist
LINE 1: ...uth_user"."is_active", "auth_user"."date_joined", "auth_user...
                                                             ^

Job "leave_reset (trigger: interval[0:00:20], next run at: 2025-02-03 17:00:33 IST)" raised an exception
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column leave_leavetype.carryforward_expire_date does not exist
LINE 1: ..., "leave_leavetype"."carryforward_expire_period", "leave_lea...
                                                             ^


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/apscheduler/executors/base.py", line 131, in run_job
    retval = job.func(*job.args, **job.kwargs)
  File "/app/leave/scheduler.py", line 18, in leave_reset
    for leave_type in leave_types:
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 398, in __iter__
    self._fetch_all()
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1881, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 91, in __iter__
    results = compiler.execute_sql(
  File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 102, in execute
    return super().execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
    with self.db.wrap_database_errors:
  File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column leave_leavetype.carryforward_expire_date does not exist
LINE 1: ..., "leave_leavetype"."carryforward_expire_period", "leave_lea...
                                                             ^

Second run of the "python3 manage.py makemigrations && python3 manage.py migrate && python3 manage.py showmigrations" commands

Migrations for 'auth':
  /usr/local/lib/python3.10/site-packages/django/contrib/auth/migrations/0013_user_is_new_employee.py
    - Add field is_new_employee to user
Migrations for 'horilla_audit':
  horilla_audit/migrations/0001_initial.py
    - Create model AuditTag
    - Create model HistoryTrackingFields
    - Create model AccountBlockUnblock
Migrations for 'horilla_views':
  horilla_views/migrations/0001_initial.py
    - Create model ToggleColumn
    - Create model SavedFilter
    - Create model ActiveView
    - Create model ActiveTab
    - Create model ActiveGroup
Migrations for 'accessibility':
  accessibility/migrations/0001_initial.py
    - Create model DefaultAccessibility
  accessibility/migrations/0002_initial.py
    - Add field employees to defaultaccessibility
    - Add field modified_by to defaultaccessibility
Migrations for 'asset':
  asset/migrations/0001_initial.py
    - Create model Asset
    - Create model AssetAssignment
    - Create model AssetCategory
    - Create model AssetDocuments
    - Create model AssetLot
    - Create model AssetReport
    - Create model ReturnImages
    - Create model AssetRequest
  asset/migrations/0002_initial.py
    - Add field requested_employee_id to assetrequest
    - Add field asset_id to assetreport
    - Add field created_by to assetreport
    - Add field modified_by to assetreport
    - Add field company_id to assetlot
    - Add field created_by to assetlot
    - Add field modified_by to assetlot
    - Add field asset_report to assetdocuments
    - Add field created_by to assetdocuments
    - Add field modified_by to assetdocuments
    - Add field company_id to assetcategory
    - Add field created_by to assetcategory
    - Add field modified_by to assetcategory
    - Add field asset_id to assetassignment
    - Add field assign_images to assetassignment
    - Add field assigned_by_employee_id to assetassignment
    - Add field assigned_to_employee_id to assetassignment
    - Add field created_by to assetassignment
    - Add field modified_by to assetassignment
    - Add field return_images to assetassignment
    - Add field asset_category_id to asset
    - Add field asset_lot_number_id to asset
    - Add field created_by to asset
    - Add field modified_by to asset
    - Add field owner to asset
Migrations for 'attendance':
  attendance/migrations/0001_initial.py
    - Create model Attendance
    - Create model AttendanceActivity
    - Create model AttendanceGeneralSetting
    - Create model AttendanceLateComeEarlyOut
    - Create model AttendanceOverTime
    - Create model AttendanceRequestComment
    - Create model AttendanceRequestFile
    - Create model AttendanceValidationCondition
    - Create model BatchAttendance
    - Create model GraceTime
    - Create model HistoricalAttendance
    - Create model PenaltyAccount
    - Create model WorkRecords
    - Create model OverrideAttendances
  attendance/migrations/0002_initial.py
    - Add field employee_id to workrecords
    - Add field created_by to penaltyaccount
    - Add field employee_id to penaltyaccount
    - Add field late_early_id to penaltyaccount
    - Add field leave_request_id to penaltyaccount
    - Add field leave_type_id to penaltyaccount
    - Add field modified_by to penaltyaccount
    - Add field attendance_day to historicalattendance
    - Add field batch_attendance_id to historicalattendance
    - Add field created_by to historicalattendance
    - Add field employee_id to historicalattendance
    - Add field history_relation to historicalattendance
    - Add field history_tags to historicalattendance
    - Add field history_user to historicalattendance
    - Add field modified_by to historicalattendance
    - Add field shift_id to historicalattendance
    - Add field work_type_id to historicalattendance
    - Add field company_id to gracetime
    - Add field created_by to gracetime
    - Add field modified_by to gracetime
    - Add field created_by to batchattendance
    - Add field modified_by to batchattendance
    - Add field company_id to attendancevalidationcondition
    - Add field created_by to attendancevalidationcondition
    - Add field modified_by to attendancevalidationcondition
    - Add field created_by to attendancerequestfile
    - Add field modified_by to attendancerequestfile
    - Add field created_by to attendancerequestcomment
    - Add field employee_id to attendancerequestcomment
    - Add field files to attendancerequestcomment
    - Add field modified_by to attendancerequestcomment
    - Add field request_id to attendancerequestcomment
    - Add field created_by to attendanceovertime
    - Add field employee_id to attendanceovertime
    - Add field modified_by to attendanceovertime
    - Add field attendance_id to attendancelatecomeearlyout
    - Add field created_by to attendancelatecomeearlyout
    - Add field employee_id to attendancelatecomeearlyout
    - Add field modified_by to attendancelatecomeearlyout
    - Add field company_id to attendancegeneralsetting
    - Add field created_by to attendancegeneralsetting
    - Add field modified_by to attendancegeneralsetting
    - Add field created_by to attendanceactivity
    - Add field employee_id to attendanceactivity
    - Add field modified_by to attendanceactivity
    - Add field shift_day to attendanceactivity
    - Add field attendance_day to attendance
    - Add field batch_attendance_id to attendance
    - Add field created_by to attendance
    - Add field employee_id to attendance
    - Add field modified_by to attendance
    - Add field shift_id to attendance
    - Add field work_type_id to attendance
    - Alter unique_together for attendanceovertime (1 constraint(s))
    - Alter unique_together for attendancelatecomeearlyout (1 constraint(s))
    - Alter unique_together for attendance (1 constraint(s))
Migrations for 'base':
  base/migrations/0001_initial.py
    - Create model Announcement
    - Create model AnnouncementComment
    - Create model AnnouncementExpire
    - Create model AnnouncementView
    - Create model Attachment
    - Create model AttendanceAllowedIP
    - Create model BaserequestFile
    - Create model BiometricAttendance
    - Create model Company
    - Create model CompanyLeaves
    - Create model DashboardEmployeeCharts
    - Create model Department
    - Create model DriverViewed
    - Create model DynamicEmailConfiguration
    - Create model DynamicPagination
    - Create model EmailLog
    - Create model EmployeeShift
    - Create model EmployeeShiftDay
    - Create model EmployeeShiftSchedule
    - Create model EmployeeType
    - Create model HistoricalRotatingShiftAssign
    - Create model HistoricalRotatingWorkTypeAssign
    - Create model HistoricalShiftRequest
    - Create model HistoricalWorkTypeRequest
    - Create model Holidays
    - Create model HorillaMailTemplate
    - Create model JobPosition
    - Create model JobRole
    - Create model MultipleApprovalCondition
    - Create model MultipleApprovalManagers
    - Create model NotificationSound
    - Create model PenaltyAccounts
    - Create model RotatingShift
    - Create model RotatingShiftAssign
    - Create model RotatingWorkType
    - Create model RotatingWorkTypeAssign
    - Create model ShiftRequest
    - Create model ShiftRequestComment
    - Create model Tags
    - Create model TrackLateComeEarlyOut
    - Create model WorkType
    - Create model WorkTypeRequest
    - Create model WorkTypeRequestComment
  base/migrations/0002_initial.py
    - Add field employee_id to worktyperequestcomment
    - Add field files to worktyperequestcomment
    - Add field modified_by to worktyperequestcomment
    - Add field request_id to worktyperequestcomment
    - Add field created_by to worktyperequest
    - Add field employee_id to worktyperequest
    - Add field modified_by to worktyperequest
    - Add field previous_work_type_id to worktyperequest
    - Add field work_type_id to worktyperequest
    - Add field company_id to worktype
    - Add field created_by to worktype
    - Add field modified_by to worktype
    - Add field created_by to tracklatecomeearlyout
    - Add field modified_by to tracklatecomeearlyout
    - Add field company_id to tags
    - Add field created_by to tags
    - Add field modified_by to tags
    - Add field created_by to shiftrequestcomment
    - Add field employee_id to shiftrequestcomment
    - Add field files to shiftrequestcomment
    - Add field modified_by to shiftrequestcomment
    - Add field request_id to shiftrequestcomment
    - Add field created_by to shiftrequest
    - Add field employee_id to shiftrequest
    - Add field modified_by to shiftrequest
    - Add field previous_shift_id to shiftrequest
    - Add field reallocate_to to shiftrequest
    - Add field shift_id to shiftrequest
    - Add field created_by to rotatingworktypeassign
    - Add field current_work_type to rotatingworktypeassign
    - Add field employee_id to rotatingworktypeassign
    - Add field modified_by to rotatingworktypeassign
    - Add field next_work_type to rotatingworktypeassign
    - Add field rotating_work_type_id to rotatingworktypeassign
    - Add field created_by to rotatingworktype
    - Add field employee_id to rotatingworktype
    - Add field modified_by to rotatingworktype
    - Add field work_type1 to rotatingworktype
    - Add field work_type2 to rotatingworktype
    - Add field created_by to rotatingshiftassign
    - Add field current_shift to rotatingshiftassign
    - Add field employee_id to rotatingshiftassign
    - Add field modified_by to rotatingshiftassign
    - Add field next_shift to rotatingshiftassign
    - Add field rotating_shift_id to rotatingshiftassign
    - Add field created_by to rotatingshift
    - Add field employee_id to rotatingshift
    - Add field modified_by to rotatingshift
    - Add field shift1 to rotatingshift
    - Add field shift2 to rotatingshift
    - Add field created_by to penaltyaccounts
    - Add field employee_id to penaltyaccounts
    - Add field late_early_id to penaltyaccounts
    - Add field leave_request_id to penaltyaccounts
    - Add field leave_type_id to penaltyaccounts
    - Add field modified_by to penaltyaccounts
    - Add field employee to notificationsound
    - Add field condition_id to multipleapprovalmanagers
    - Add field company_id to multipleapprovalcondition
    - Add field created_by to multipleapprovalcondition
    - Add field department to multipleapprovalcondition
    - Add field modified_by to multipleapprovalcondition
    - Add field company_id to jobrole
    - Add field created_by to jobrole
    - Add field job_position_id to jobrole
    - Add field modified_by to jobrole
    - Add field company_id to jobposition
    - Add field created_by to jobposition
    - Add field department_id to jobposition
    - Add field modified_by to jobposition
    - Add field company_id to horillamailtemplate
    - Add field created_by to horillamailtemplate
    - Add field modified_by to horillamailtemplate
    - Add field company_id to holidays
    - Add field created_by to holidays
    - Add field modified_by to holidays
    - Add field created_by to historicalworktyperequest
    - Add field employee_id to historicalworktyperequest
    - Add field history_relation to historicalworktyperequest
    - Add field history_tags to historicalworktyperequest
    - Add field history_user to historicalworktyperequest
    - Add field modified_by to historicalworktyperequest
    - Add field previous_work_type_id to historicalworktyperequest
    - Add field work_type_id to historicalworktyperequest
    - Add field created_by to historicalshiftrequest
    - Add field employee_id to historicalshiftrequest
    - Add field history_relation to historicalshiftrequest
    - Add field history_tags to historicalshiftrequest
    - Add field history_user to historicalshiftrequest
    - Add field modified_by to historicalshiftrequest
    - Add field previous_shift_id to historicalshiftrequest
    - Add field reallocate_to to historicalshiftrequest
    - Add field shift_id to historicalshiftrequest
    - Add field created_by to historicalrotatingworktypeassign
    - Add field current_work_type to historicalrotatingworktypeassign
    - Add field employee_id to historicalrotatingworktypeassign
    - Add field history_relation to historicalrotatingworktypeassign
    - Add field history_tags to historicalrotatingworktypeassign
    - Add field history_user to historicalrotatingworktypeassign
    - Add field modified_by to historicalrotatingworktypeassign
    - Add field next_work_type to historicalrotatingworktypeassign
    - Add field rotating_work_type_id to historicalrotatingworktypeassign
    - Add field created_by to historicalrotatingshiftassign
    - Add field current_shift to historicalrotatingshiftassign
    - Add field employee_id to historicalrotatingshiftassign
    - Add field history_relation to historicalrotatingshiftassign
    - Add field history_tags to historicalrotatingshiftassign
    - Add field history_user to historicalrotatingshiftassign
    - Add field modified_by to historicalrotatingshiftassign
    - Add field next_shift to historicalrotatingshiftassign
    - Add field rotating_shift_id to historicalrotatingshiftassign
    - Add field company_id to employeetype
    - Add field created_by to employeetype
    - Add field modified_by to employeetype
    - Add field company_id to employeeshiftschedule
    - Add field created_by to employeeshiftschedule
    - Add field day to employeeshiftschedule
    - Add field modified_by to employeeshiftschedule
    - Add field shift_id to employeeshiftschedule
    - Add field company_id to employeeshiftday
    - Add field company_id to employeeshift
    - Add field created_by to employeeshift
    - Add field days to employeeshift
    - Add field grace_time_id to employeeshift
    - Add field modified_by to employeeshift
    - Add field company_id to emaillog
    - Add field user_id to dynamicpagination
    - Add field company_id to dynamicemailconfiguration
    - Add field created_by to dynamicemailconfiguration
    - Add field modified_by to dynamicemailconfiguration
    - Add field user to driverviewed
    - Add field company_id to department
    - Add field created_by to department
    - Add field modified_by to department
    - Add field created_by to dashboardemployeecharts
    - Add field employee to dashboardemployeecharts
    - Add field modified_by to dashboardemployeecharts
    - Add field company_id to companyleaves
    - Add field created_by to companyleaves
    - Add field modified_by to companyleaves
    - Add field created_by to company
    - Add field modified_by to company
    - Add field company_id to biometricattendance
    - Add field announcement to announcementview
    - Add field user to announcementview
    - Add field announcement_id to announcementcomment
    - Add field created_by to announcementcomment
    - Add field employee_id to announcementcomment
    - Add field modified_by to announcementcomment
    - Add field attachments to announcement
    - Add field company_id to announcement
    - Add field created_by to announcement
    - Add field department to announcement
    - Add field employees to announcement
    - Add field job_position to announcement
    - Add field modified_by to announcement
    - Alter unique_together for jobrole (1 constraint(s))
    - Alter unique_together for employeeshiftschedule (1 constraint(s))
    - Alter unique_together for companyleaves (1 constraint(s))
    - Alter unique_together for company (1 constraint(s))
Migrations for 'employee':
  employee/migrations/0001_initial.py
    - Create model Actiontype
    - Create model BonusPoint
    - Create model Employee
    - Create model EmployeeTag
    - Create model EmployeeWorkInformation
    - Create model PolicyMultipleFile
    - Create model Policy
    - Create model NoteFiles
    - Create model HistoricalEmployeeWorkInformation
    - Create model HistoricalBonusPoint
    - Create model EmployeeNote
    - Create model EmployeeGeneralSetting
    - Create model EmployeeBankDetails
    - Create model DisciplinaryAction
    - Add field employee_id to bonuspoint
    - Add field modified_by to bonuspoint
    - Create constraint unique_badge_id on model employee
    - Alter unique_together for employee (1 constraint(s))
Migrations for 'helpdesk':
  helpdesk/migrations/0001_initial.py
    - Create model TicketType
    - Create model Ticket
    - Create model HistoricalTicket
    - Create model FAQCategory
    - Create model FAQ
    - Create model Comment
    - Create model Attachment
    - Create model DepartmentManager
    - Create model ClaimRequest
Migrations for 'horilla_automations':
  horilla_automations/migrations/0001_initial.py
    - Create model MailAutomation
Migrations for 'horilla_documents':
  horilla_documents/migrations/0001_initial.py
    - Create model DocumentRequest
    - Create model Document
Migrations for 'leave':
  leave/migrations/0001_initial.py
    - Create model AvailableLeave
    - Create model CompensatoryLeaveRequest
    - Create model LeaveAllocationRequest
    - Create model LeaveRequest
    - Create model LeaverequestFile
    - Create model LeaveType
    - Create model OverrideLeaveRequests
    - Create model RestrictLeave
    - Create model LeaveRequestConditionApproval
    - Create model LeaverequestComment
    - Add field leave_type_id to leaverequest
    - Add field modified_by to leaverequest
    - Create model LeaveGeneralSetting
    - Create model LeaveallocationrequestComment
    - Add field leave_type_id to leaveallocationrequest
    - Add field modified_by to leaveallocationrequest
    - Create model Holiday
    - Create model HistoricalLeaveRequest
    - Create model HistoricalLeaveAllocationRequest
    - Create model HistoricalCompensatoryLeaveRequest
    - Create model HistoricalAvailableLeave
    - Create model EmployeePastLeaveRestrict
    - Create model CompensatoryLeaverequestComment
    - Add field leave_type_id to compensatoryleaverequest
    - Add field modified_by to compensatoryleaverequest
    - Add field leave_type_id to availableleave
    - Add field modified_by to availableleave
    - Create model CompanyLeave
    - Alter unique_together for availableleave (1 constraint(s))
Migrations for 'offboarding':
  offboarding/migrations/0001_initial.py
    - Create model EmployeeTask
    - Create model Offboarding
    - Create model OffboardingEmployee
    - Create model OffboardingStage
    - Create model ResignationLetter
    - Create model OffboardingTask
    - Create model OffboardingStageMultipleFile
    - Create model OffboardingNote
    - Create model OffboardingGeneralSetting
    - Add field stage_id to offboardingemployee
    - Create model HistoricalEmployeeTask
    - Create model ExitReason
    - Add field employee_id to employeetask
    - Add field modified_by to employeetask
    - Add field task_id to employeetask
    - Alter unique_together for employeetask (1 constraint(s))
Migrations for 'payroll':
  payroll/migrations/0001_initial.py
    - Create model Allowance
    - Create model Contract
    - Create model Deduction
    - Create model EncashmentGeneralSettings
    - Create model FilingStatus
    - Create model MultipleCondition
    - Create model OverrideAttendance
    - Create model OverrideLeaveRequest
    - Create model OverrideWorkInfo
    - Create model Reimbursement
    - Create model ReimbursementFile
    - Create model ReimbursementMultipleAttachment
    - Create model WorkRecord
    - Create model TaxBracket
    - Create model ReimbursementrequestComment
    - Add field other_attachments to reimbursement
    - Create model PayslipAutoGenerate
    - Create model Payslip
    - Create model PayrollSettings
    - Create model PayrollGeneralSetting
    - Create model LoanAccount
    - Create model HistoricalPayslip
    - Create model HistoricalContract
    - Add field other_conditions to deduction
    - Add field specific_employees to deduction
    - Add field filing_status to contract
    - Add field job_position to contract
    - Add field job_role to contract
    - Add field modified_by to contract
    - Add field shift to contract
    - Add field work_type to contract
    - Add field other_conditions to allowance
    - Add field shift_id to allowance
    - Add field specific_employees to allowance
    - Add field work_type_id to allowance
    - Alter unique_together for contract (1 constraint(s))
    - Alter unique_together for allowance (1 constraint(s))
Migrations for 'pms':
  pms/migrations/0001_initial.py
    - Create model BonusPointSetting
    - Create model EmployeeKeyResult
    - Create model EmployeeObjective
    - Create model Feedback
    - Create model KeyResult
    - Create model Meetings
    - Create model Question
    - Create model QuestionTemplate
    - Create model QuestionOptions
    - Add field template_id to question
    - Create model Period
    - Create model Objective
    - Create model MeetingsAnswer
    - Add field question_template to meetings
    - Create model KeyResultFeedback
    - Create model HistoricalObjective
    - Create model HistoricalKeyResult
    - Create model HistoricalEmployeeObjective
    - Create model HistoricalEmployeeKeyResult
    - Create model HistoricalComment
    - Add field question_template_id to feedback
    - Add field subordinate_id to feedback
    - Add field key_result_id to employeeobjective
    - Add field modified_by to employeeobjective
    - Add field objective_id to employeeobjective
    - Add field employee_objective_id to employeekeyresult
    - Add field key_result_id to employeekeyresult
    - Create model EmployeeBonusPoint
    - Create model Comment
    - Create model Answer
    - Create model AnonymousFeedback
    - Alter unique_together for employeeobjective (1 constraint(s))
Migrations for 'recruitment':
  recruitment/migrations/0001_initial.py
    - Create model Candidate
    - Create model Recruitment
    - Create model SkillZone
    - Create model Stage
    - Create model StageFiles
    - Create model SurveyTemplate
    - Create model StageNote
    - Create model SkillZoneCandidate
    - Create model Skill
    - Create model Resume
    - Create model RejectReason
    - Create model RejectedCandidate
    - Create model RecruitmentSurveyAnswer
    - Create model RecruitmentSurvey
    - Create model RecruitmentMailTemplate
    - Create model RecruitmentGeneralSetting
    - Add field skills to recruitment
    - Add field survey_templates to recruitment
    - Create model QuestionOrdering
    - Create model InterviewSchedule
    - Create model HistoricalRejectedCandidate
    - Create model HistoricalCandidate
    - Create model CandidateDocumentRequest
    - Create model CandidateDocument
    - Add field recruitment_id to candidate
    - Add field referral to candidate
    - Add field stage_id to candidate
    - Alter unique_together for recruitment (2 constraint(s))
    - Create model CandidateRating
    - Alter unique_together for candidate (1 constraint(s))
Migrations for 'biometric':
  biometric/migrations/0001_initial.py
    - Create model BiometricDevices
    - Create model COSECAttendanceArguments
    - Create model BiometricEmployees
Migrations for 'onboarding':
  onboarding/migrations/0001_initial.py
    - Create model CandidateTask
    - Create model OnboardingStage
    - Create model OnboardingTask
    - Create model OnboardingPortal
    - Create model HistoricalCandidateTask
    - Add field onboarding_task_id to candidatetask
    - Add field stage_id to candidatetask
    - Create model CandidateStage
Migrations for 'notifications':
  notifications/migrations/0001_initial.py
    - Create model Notification
Operations to perform:
  Apply all migrations: accessibility, admin, asset, attendance, auditlog, auth, base, biometric, contenttypes, django_apscheduler, employee, helpdesk, horilla_audit, horilla_automations, horilla_documents, horilla_views, leave, notifications, offboarding, onboarding, payroll, pms, recruitment, sessions
Running migrations:
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 87, in _execute
    return self.cursor.execute(sql)
psycopg2.errors.DuplicateColumn: column "modified_by_id" of relation "accessibility_defaultaccessibility" already exists


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/app/manage.py", line 22, in <module>
    main()
  File "/app/manage.py", line 18, in main
    execute_from_command_line(sys.argv)
  File "/usr/local/lib/python3.10/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/usr/local/lib/python3.10/site-packages/django/core/management/__init__.py", line 436, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
    output = self.handle(*args, **options)
  File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
    res = handle_func(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 356, in handle
    post_migrate_state = executor.migrate(
  File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 135, in migrate
    state = self._migrate_all_forwards(
  File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards
    state = self.apply_migration(
  File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 252, in apply_migration
    state = migration.apply(state, schema_editor)
  File "/usr/local/lib/python3.10/site-packages/django/db/migrations/migration.py", line 132, in apply
    operation.database_forwards(
  File "/usr/local/lib/python3.10/site-packages/django/db/migrations/operations/fields.py", line 108, in database_forwards
    schema_editor.add_field(
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/schema.py", line 713, in add_field
    self.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/schema.py", line 48, in execute
    return super().execute(sql, None)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/schema.py", line 201, in execute
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 102, in execute
    return super().execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
    with self.db.wrap_database_errors:
  File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 87, in _execute
    return self.cursor.execute(sql)
django.db.utils.ProgrammingError: column "modified_by_id" of relation "accessibility_defaultaccessibility" already exists

  Applying accessibility.0002_initial...

The subsequent runs will result in the same error logs

django.db.utils.ProgrammingError: column "modified_by_id" of relation "accessibility_defaultaccessibility" already exists

Steps to Reproduce

  1. Deploy the Horilla v1.2.1 to an environment (k8s pod with nginx container as a sidecar in my case)
  2. Fill up with some data (create an organization, users)
  3. Switch to 1.2.2 tag, build docker image, deploy to the environment

Actual Behavior

The error logs provided above show that the application does not work, unlike the previous version.

Environment

  • Django Version: 4.2.11
  • Python Version: 3.10.16
  • Operating System: python:3.10-slim-bullseye

Labels

bug, v1.2.2
@horilla-opensource
Copy link
Owner

horilla-opensource commented Feb 6, 2025 •
edited
Loading

Hi @Roboman341 ,

Thank you for reporting this issue! 🙌 This seems to be related to mismatched migration files between versions. The missing columns (auth_user.is_new_employee and leave_leavetype.carryforward_expire_date) indicate that some migrations may not have been applied correctly.

We will investigate and work on resolving the database migration inconsistencies.

If the issue persists, please let us know the version you upgraded from and any custom database modifications you might have made. Thanks again for your patience! 🚀

Best regards,
Team Horilla

@tkajen
Copy link

tkajen commented Feb 13, 2025 •
edited
Loading

Hello @horilla-opensource,

Unfortunately, we are experiencing the same issue. We are unable to upgrade from version 1.2.1 to 1.2.2.

Do you already have a solution?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@tkajen @Roboman341 @horilla-opensource