Closed edmir31 closed 3 months ago
Hi @edmir31 , The log in raw format is a bit clustered to understand. Can you please send the screenshot of the error page ?
With Regards, Team Horilla
Hi @edmir31 , Any updates?
With Regards, Team Horilla
Hi @edmir31 , We are closing this issue due to inactivity. It seems that there hasn't been any recent activity or discussion, and we believe it may have been resolved or is no longer relevant. If you feel this issue is still important and should be addressed, please feel free to reopen it or create a new issue with updated details.
With Regards, Team Horilla
I made the update to the new version with the old database i have this error.
OperationalError at / no such column: recruitment_interviewschedule.description Request Method: GET Request URL: http://127.0.0.1:8000/ Django Version: 4.2.11 Exception Type: OperationalError Exception Value:
no such column: recruitment_interviewschedule.description 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.4 Python Path:
['C:\horillahrm\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: Sun, 30 Jun 2024 01:58:08 +0530 Traceback Switch to copy-and-paste view 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars The above exception (no such column: recruitment_interviewschedule.description) was the direct cause of the following exception: C:\horillahrm\horilla\horilla\decorators.py, line 194, in wrapped_view func = view_func(request, *args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\horillahrm\horilla\base\views.py, line 449, in home return render(request, "index.html", context) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\shortcuts.py, line 24, in render content = loader.render_to_string(template_name, context, request, using=using) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\template\loader.py, line 62, in render_to_string return template.render(context, request) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\template\backends\django.py, line 61, in render return self.template.render(context) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\template\base.py, line 173, in render with context.bind_template(self): ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\contextlib.py, line 137, in enter return next(self.gen) ^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\template\context.py, line 254, in bind_template updates.update(processor(self.request)) ^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\horillahrm\horilla\horilla\config.py, line 87, in get_MENUS sidebar(request) ^^^^^^^^^^^^^^^^ … Local vars C:\horillahrm\horilla\horilla\config.py, line 76, in sidebar if not accessibility or accessibility( … Local vars C:\horillahrm\horilla\recruitment\sidebar.py, line 104, in interview_accessibility for interview in interviews: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\query.py, line 398, in iter self._fetch_all() ^^^^^^^^^^^^^^^^^ … Local vars 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)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\query.py, line 91, in iter results = compiler.execute_sql( … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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( … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars During handling of the above exception (no such column: recruitment_interviewschedule.description), another exception occurred: 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars The above exception (no such column: recruitment_interviewschedule.description) was the direct cause of the following exception: C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\handlers\exception.py, line 55, in inner response = get_response(request) ^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\handlers\base.py, line 197, in _get_response response = wrapped_callback(request, *callback_args, *callback_kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\horillahrm\horilla\horilla\decorators.py, line 209, in wrapped_view return view_func(request, args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\horillahrm\horilla\base\views.py, line 449, in home return render(request, "index.html", context) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\shortcuts.py, line 24, in render content = loader.render_to_string(template_name, context, request, using=using) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\template\loader.py, line 62, in render_to_string return template.render(context, request) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\template\backends\django.py, line 61, in render return self.template.render(context) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\template\base.py, line 173, in render with context.bind_template(self): ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\contextlib.py, line 137, in enter return next(self.gen) ^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\template\context.py, line 254, in bind_template updates.update(processor(self.request)) ^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\horillahrm\horilla\horilla\config.py, line 87, in get_MENUS sidebar(request) ^^^^^^^^^^^^^^^^ … Local vars C:\horillahrm\horilla\horilla\config.py, line 76, in sidebar if not accessibility or accessibility( … Local vars C:\horillahrm\horilla\recruitment\sidebar.py, line 104, in interview_accessibility for interview in interviews: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\query.py, line 398, in iter self._fetch_all() ^^^^^^^^^^^^^^^^^ … Local vars 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)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\query.py, line 91, in iter results = compiler.execute_sql( … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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( … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars 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) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ … Local vars Request information USER admin
GET No GET data
POST No POST data
FILES No FILES data
COOKIES Variable Value messages
<_io.TextIOWrapper name=''W1siX19qc29uX21lc3NhZ2UiLDAsMjUsIkxvZ2luIFN1Y2Nlc3MiLCIiXV0:1sNeg4:YeT7GdxZH4dvjOiqke9ttVjOi1O7RiFTU2TO16gi7Ho' csrftoken
'****' sessionid
'****' META Variable Value ALLUSERSPROFILE 'C:\ProgramData' APPDATA 'C:\Users\user\AppData\Roaming' COMMONPROGRAMFILES
'C:\Program Files\Common Files' COMMONPROGRAMFILES(X86) 'C:\Program Files (x86)\Common Files' COMMONPROGRAMW6432
'C:\Program Files\Common Files' COMPUTERNAME
'DESKTOP-0GJI2TS' COMSPEC 'C:\WINDOWS\system32\cmd.exe' CONTENT_LENGTH
'' CONTENT_TYPE
'text/plain' CSRF_COOKIE 'FiCbObAevnGAFa2LIqyXjHR2uOc0Z5KU' CSRF_COOKIE_NEEDS_UPDATE
True DJANGO_SETTINGS_MODULE
'horilla.settings' DRIVERDATA
'C:\Windows\System32\Drivers\DriverData' GATEWAY_INTERFACE
'CGI/1.1' HOMEDRIVE
'C:' HOMEPATH
'\Users\user' HTTP_ACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,/;q=0.8,application/signed-exchange;v=b3;q=0.7' HTTP_ACCEPT_ENCODING
'gzip, deflate, br, zstd' HTTP_ACCEPT_LANGUAGE
'en-US,en;q=0.9' HTTP_CACHE_CONTROL
'max-age=0' HTTP_CONNECTION 'keep-alive' HTTP_COOKIE '****' HTTP_HOST
'127.0.0.1:8000' HTTP_REFERER
'http://127.0.0.1:8000/login/?next=/' HTTP_SEC_CH_UA
'"Not/A)Brand";v="8", "Chromium";v="126", "Google Chrome";v="126"' HTTP_SEC_CH_UA_MOBILE
'?0' HTTP_SEC_CH_UA_PLATFORM '"Windows"' HTTP_SEC_FETCH_DEST 'document' HTTP_SEC_FETCH_MODE 'navigate' HTTP_SEC_FETCH_SITE 'same-origin' HTTP_SEC_FETCH_USER '?1' HTTP_UPGRADE_INSECURE_REQUESTS
'1' HTTP_USER_AGENT ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like ' 'Gecko) Chrome/126.0.0.0 Safari/537.36') LOCALAPPDATA
'C:\Users\user\AppData\Local' LOGONSERVER '\\DESKTOP-0GJI2TS' NUMBER_OF_PROCESSORS
'2' ONEDRIVE
'C:\Users\user\OneDrive - Relikaj Ltd' ONEDRIVECOMMERCIAL
'C:\Users\user\OneDrive - Relikaj Ltd' OS
'Windows_NT' PATH
('C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program ' 'Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS ' 'Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program ' 'Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program ' 'Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files ' '(x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program ' 'Files\Intel\Intel(R) Management Engine ' 'Components\IPT;C:\WINDOWS\System32\OpenSSH\;C:\Program Files ' '(x86)\dotnet\;C:\Program Files\Git\cmd;C:\Program ' 'Files\Git\bin\;C:\Program ' 'Files\Git\cmd\;C:\Users\user\AppData\Local\Programs\Python\Python312\Scripts\;C:\Users\user\AppData\Local\Programs\Python\Python312\;C:\Users\user\AppData\Local\Microsoft\WindowsApps') PATHEXT '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC' PATH_INFO
'/' PROCESSOR_ARCHITECTURE
'AMD64' PROCESSOR_IDENTIFIER
'Intel64 Family 6 Model 60 Stepping 3, GenuineIntel' PROCESSOR_LEVEL '6' PROCESSOR_REVISION
'3c03' PROGRAMDATA 'C:\ProgramData' PROGRAMFILES
'C:\Program Files' PROGRAMFILES(X86)
'C:\Program Files (x86)' PROGRAMW6432
'C:\Program Files' PROMPT
'$P$G' PSMODULEPATH
('C:\Program ' 'Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules') PUBLIC
'C:\Users\Public' QUERY_STRING
'' REMOTE_ADDR '127.0.0.1' REMOTE_HOST '' REQUEST_METHOD
'GET' RUN_MAIN
'true' SCRIPT_NAME '' SERVER_NAME 'DESKTOP-0GJI2TS' SERVER_PORT '8000' SERVER_PROTOCOL 'HTTP/1.1' SERVER_SOFTWARE 'WSGIServer/0.2' SYSTEMDRIVE 'C:' SYSTEMROOT
'C:\WINDOWS' TEMP
'C:\Users\user\AppData\Local\Temp' TMP 'C:\Users\user\AppData\Local\Temp' USERDOMAIN
'DESKTOP-0GJI2TS' USERDOMAIN_ROAMINGPROFILE
'DESKTOP-0GJI2TS' USERNAME
'user' USERPROFILE 'C:\Users\user' WINDIR
'C:\WINDOWS' wsgi.errors