I have updated to the new version. and I have the old database. The program don't work.

[edmir31]

I have updated to the new files. and I have the old database. My site gives me this error.

OperationalError at / no such column: base_employeeshiftschedule.is_auto_punch_out_enabled Request Method: GET Request URL: http://127.0.0.1:8000/ Django Version: 4.2.11 Exception Type: OperationalError Exception Value: no such column: base_employeeshiftschedule.is_auto_punch_out_enabled Exception Location: C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\sqlite3\base.py, line 328, in execute Raised during: horilla.decorators.wrapped_view Python Executable: C:\Users\User\AppData\Local\Programs\Python\Python312\python.exe Python Version: 3.12.3 Python Path: ['C:\Users\User\Desktop\horilla2024\horilla', 'C:\Users\User\AppData\Local\Programs\Python\Python312\python312.zip', 'C:\Users\User\AppData\Local\Programs\Python\Python312\DLLs', 'C:\Users\User\AppData\Local\Programs\Python\Python312\Lib', 'C:\Users\User\AppData\Local\Programs\Python\Python312', 'C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages'] Server time: Wed, 04 Sep 2024 14:53:31 +0530

Request Method:	GET
http://127.0.0.1:8000/
4.2.11
OperationalError
no such column: base_employeeshiftschedule.is_auto_punch_out_enabled
C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\sqlite3\base.py, line 328, in execute
horilla.decorators.wrapped_view
C:\Users\User\AppData\Local\Programs\Python\Python312\python.exe
3.12.3
['C:\Users\User\Desktop\horilla2024\horilla', 'C:\Users\User\AppData\Local\Programs\Python\Python312\python312.zip', 'C:\Users\User\AppData\Local\Programs\Python\Python312\DLLs', 'C:\Users\User\AppData\Local\Programs\Python\Python312\Lib', 'C:\Users\User\AppData\Local\Programs\Python\Python312', 'C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages']
Wed, 04 Sep 2024 14:53:31 +0530

Environment:

Request Method: GET Request URL: http://127.0.0.1:8000/

Django Version: 4.2.11 Python Version: 3.12.3 Installed Applications: ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'notifications', 'mathfilters', 'corsheaders', 'simple_history', 'django_filters', 'base', 'employee', 'recruitment', 'leave', 'pms', 'onboarding', 'asset', 'attendance', 'payroll', 'widget_tweaks', 'django_apscheduler', 'horilla_audit', 'horilla_widgets', 'horilla_crumbs', 'horilla_documents', 'haystack', 'horilla_views', 'horilla_automations', 'auditlog', 'biometric', 'helpdesk', 'offboarding'] Installed Middleware: ['django.middleware.security.SecurityMiddleware', 'whitenoise.middleware.WhiteNoiseMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'corsheaders.middleware.CorsMiddleware', 'simple_history.middleware.HistoryRequestMiddleware', 'django.middleware.locale.LocaleMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'auditlog.middleware.AuditlogMiddleware', 'base.middleware.CompanyMiddleware', 'horilla.horilla_middlewares.MethodNotAllowedMiddleware', 'horilla.horilla_middlewares.ThreadLocalMiddleware', 'attendance.middleware.AttendanceMiddleware']

Traceback (most recent call last): File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py", line 89, in _execute return self.cursor.execute(sql, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\sqlite3\base.py", line 328, in execute return super().execute(query, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

The above exception (no such column: base_employeeshiftschedule.is_auto_punch_out_enabled) was the direct cause of the following exception: File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\handlers\exception.py", line 55, in inner response = get_response(request) ^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\deprecation.py", line 133, in call response = self.process_request(request) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\Desktop\horilla2024\horilla\attendance\middleware.py", line 11, in process_request self.trigger_function() ^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\Desktop\horilla2024\horilla\attendance\middleware.py", line 22, in trigger_function for shift_schedule in automatic_check_out_shifts: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\query.py", line 398, in iter self._fetch_all() ^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\query.py", line 1881, in _fetch_all self._result_cache = list(self._iterable_class(self)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\query.py", line 91, in iter results = compiler.execute_sql(

File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\sql\compiler.py", line 1562, in execute_sql cursor.execute(sql, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py", line 102, in execute return super().execute(sql, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py", line 67, in execute return self._execute_with_wrappers(

File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py", line 80, in _execute_with_wrappers return executor(sql, params, many, context) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py", line 84, in _execute with self.db.wrap_database_errors: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\utils.py", line 91, in exit raise dj_exc_value.with_traceback(traceback) from exc_value ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\utils.py", line 89, in _execute return self.cursor.execute(sql, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\sqlite3\base.py", line 328, in execute return super().execute(query, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Exception Type: OperationalError at / Exception Value: no such column: base_employeeshiftschedule.is_auto_punch_out_enabled