Hello Friends,
I am faced with a situation with restoring data from an older backup on a locally hosted server.
erpnext 14.27.1
frappe 14.38.3
hrms 15.0.0-dev
india_compliance 14.10.1
payments 0.0.1
The older backup (with files) is of Mar-2023 and I need to restore (with files) in a site created with current releases. When I restore data, I get some errors such as:
SETVAL(access_log_id_seq
, 226, 0)
226
SETVAL(activity_log_id_seq
, 1195, 0)
1195
SETVAL(console_log_id_seq
, 1, 0)
1
SETVAL(crm_note_id_seq
, 1, 0)
1
SETVAL(docshare_id_seq
, 35, 0)
35
SETVAL(document_follow_id_seq
, 1, 0)
1
SETVAL(email_queue_id_seq
, 58, 0)
58
SETVAL(energy_point_log_id_seq
, 1, 0)
1
SETVAL(error_log_id_seq
, 24693, 0)
24693
SETVAL(event_sync_log_id_seq
, 1, 0)
1
SETVAL(event_update_log_id_seq
, 1, 0)
1
SETVAL(notification_log_id_seq
, 11, 0)
11
SETVAL(prospect_opportunity_id_seq
, 1, 0)
1
SETVAL(scheduled_job_log_id_seq
, 65411, 0)
65411
SETVAL(tax_withheld_vouchers_id_seq
, 1, 0)
1
SETVAL(version_id_seq
, 6272, 0)
6272
SETVAL(view_log_id_seq
, 1, 0)
1
SETVAL(web_form_list_column_id_seq
, 1, 0)
1
Bench Start is usual with one message in Red:
WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.
I am able to see the Website (and can see data populated in links (Quotations & Invoices etc.) under “My Account”, BUT on logging in to the Desk gives error screen:
Uncaught Server Exception
There was an error building this page
Error Code: 500
And, there is a traceback:
Traceback (most recent call last):
File “apps/frappe/frappe/www/app.py”, line 28, in get_context
boot = frappe.sessions.get()
File “apps/frappe/frappe/sessions.py”, line 166, in get
bootinfo = get_bootinfo()
File “apps/frappe/frappe/boot.py”, line 38, in get_bootinfo
get_user(bootinfo)
File “apps/frappe/frappe/boot.py”, line 279, in get_user
bootinfo.user = frappe.get_user().load_user()
File “apps/frappe/frappe/utils/user.py”, line 210, in load_user
d = frappe.db.get_value(
File “apps/frappe/frappe/database/database.py”, line 510, in get_value
result = self.get_values(
File “apps/frappe/frappe/database/database.py”, line 607, in get_values
out = self._get_values_from_table(
File “apps/frappe/frappe/database/database.py”, line 837, in _get_values_from_table
return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck)
File “apps/frappe/frappe/query_builder/utils.py”, line 76, in execute_query
return frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
File “apps/frappe/frappe/database/database.py”, line 221, in sql
self._cursor.execute(query, values)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 158, in execute
result = self._query(query)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 325, in _query
conn.query(q)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 779, in _read_query_result
result.read()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1157, in read
first_packet = self.connection._read_packet()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 729, in _read_packet
packet.raise_for_error()
File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘onboarding_status’ in ‘field list’”)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File “apps/frappe/frappe/website/serve.py”, line 18, in get_response
response = renderer_instance.render()
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 84, in render
html = self.get_html()
File “apps/frappe/frappe/website/utils.py”, line 510, in cache_html_decorator
html = func(*args, **kwargs)
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 95, in get_html
self.update_context()
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 163, in update_context
data = self.run_pymodule_method(“get_context”)
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 225, in run_pymodule_method
return method(self.context)
File “apps/frappe/frappe/www/app.py”, line 30, in get_context
raise frappe.SessionBootFailed from e
frappe.exceptions.SessionBootFailed
Can I be please guided to set this right ?
Thanks in advance
Ratninder