Restored db backup from ERPNext v12 to v14 and got this after after restoring the db backup its not being resolved.
Please help.
Traceback (most recent call last):
File “/usr/lib/python3.10/runpy.py”, line 196, in _run_module_as_main
return _run_code(code, main_globals, None,
File “/usr/lib/python3.10/runpy.py”, line 86, in _run_code
exec(code, run_globals)
File “/home/usr/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 109, in
main()
File “/home/usr/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=“bench”)
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 829, in call
return self.main(*args, **kwargs)
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 782, in main
rv = self.invoke(ctx)
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 610, in invoke
return callback(*args, **kwargs)
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/click/decorators.py”, line 21, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/usr/frappe-bench/apps/frappe/frappe/commands/init.py”, line 29, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/usr/frappe-bench/apps/frappe/frappe/commands/site.py”, line 552, in migrate
SiteMigration(
File “/home/usr/frappe-bench/apps/frappe/frappe/migrate.py”, line 172, in run
self.setUp()
File “/home/usr/frappe-bench/apps/frappe/frappe/migrate.py”, line 74, in setUp
clear_global_cache()
File “/home/usr/frappe-bench/apps/frappe/frappe/cache_manager.py”, line 102, in clear_global_cache
clear_website_cache()
File “/home/usr/frappe-bench/apps/frappe/frappe/website/utils.py”, line 387, in clear_website_cache
clear_cache(path)
File “/home/usr/frappe-bench/apps/frappe/frappe/website/utils.py”, line 370, in clear_cache
frappe.clear_cache(“Guest”)
File “/home/usr/frappe-bench/apps/frappe/frappe/init.py”, line 872, in clear_cache
frappe.cache_manager.clear_user_cache(user)
File “/home/usr/frappe-bench/apps/frappe/frappe/cache_manager.py”, line 78, in clear_user_cache
clear_notifications(user)
File “/home/usr/frappe-bench/apps/frappe/frappe/desk/notifications.py”, line 143, in clear_notifications
config = get_notification_config()
File “/home/usr/frappe-bench/apps/frappe/frappe/desk/notifications.py”, line 236, in get_notification_config
return frappe.cache().hget(“notification_config”, user, _get)
File “/home/usr/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py”, line 201, in hget
value = generator()
File “/home/usr/frappe-bench/apps/frappe/frappe/desk/notifications.py”, line 214, in _get
subscribed_documents = get_subscribed_documents()
File “/home/usr/frappe-bench/apps/frappe/frappe/desk/doctype/notification_settings/notification_settings.py”, line 69, in get_subscribed_documents
doc = frappe.get_doc(“Notification Settings”, frappe.session.user)
File “/home/usr/frappe-bench/apps/frappe/frappe/init.py”, line 1180, in get_doc
doc = frappe.model.document.get_doc(*args, **kwargs)
File “/home/usr/frappe-bench/apps/frappe/frappe/model/document.py”, line 74, in get_doc
return controller(*args, **kwargs)
File “/home/usr/frappe-bench/apps/frappe/frappe/model/document.py”, line 106, in init
self.load_from_db()
File “/home/usr/frappe-bench/apps/frappe/frappe/model/document.py”, line 158, in load_from_db
if hasattr(self, “doctype”) and not hasattr(self, “module”) and is_virtual_doctype(df.options):
File “/home/usr/frappe-bench/apps/frappe/frappe/utils/caching.py”, line 119, in site_cache_wrapper
_SITE_CACHE[func_key][frappe.local.site][func_call_key] = func(*args, **kwargs)
File “/home/usr/frappe-bench/apps/frappe/frappe/model/utils/init.py”, line 133, in is_virtual_doctype
return frappe.db.get_value(“DocType”, doctype, “is_virtual”)
File “/home/usr/frappe-bench/apps/frappe/frappe/database/database.py”, line 473, in get_value
result = self.get_values(
File “/home/usr/frappe-bench/apps/frappe/frappe/database/database.py”, line 570, in get_values
out = self._get_values_from_table(
File “/home/usr/frappe-bench/apps/frappe/frappe/database/database.py”, line 800, in _get_values_from_table
return self.sql(query, as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck)
File “/home/usr/frappe-bench/apps/frappe/frappe/database/database.py”, line 207, in sql
self._cursor.execute(query, values)
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/pymysql/cursors.py”, line 148, in execute
result = self._query(query)
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/pymysql/cursors.py”, line 310, in _query
conn.query(q)
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_query_result
result.read()
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 1156, in read
first_packet = self.connection._read_packet()
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “/home/usr/frappe-bench/env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “/home/usr/frappe-bench/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 ‘is_virtual’ in ‘field list’”)