Unable to login to a new erpnext instance after bench migrate

dear all, so I have been unable to log into my new site after I did a bench --site [site name] migrate after a backup and restore procedure. When I tried to log into the new site the screen got stuck on verifying…I have tried to log in a few times more and keeps getting the same message. So, then I decided to try to set up new admin password using

.bench set-admin-password [new password]

then, I restart my bench and when I tried to access the site. I got this message

    Traceback (most recent call last):
  File "/home/zavatra/z-bench/apps/frappe/frappe/app.py", line 52, in application
    init_request(request)
  File "/home/zavatra/z-bench/apps/frappe/frappe/app.py", line 118, in init_request
    frappe.local.http_request = frappe.auth.HTTPRequest()
  File "/home/zavatra/z-bench/apps/frappe/frappe/auth.py", line 51, in __init__
    frappe.local.login_manager = LoginManager()
  File "/home/zavatra/z-bench/apps/frappe/frappe/auth.py", line 113, in __init__
    self.make_session(resume=True)
  File "/home/zavatra/z-bench/apps/frappe/frappe/auth.py", line 182, in make_session
    full_name=self.full_name, user_type=self.user_type)
  File "/home/zavatra/z-bench/apps/frappe/frappe/sessions.py", line 201, in __init__
    self.resume()
  File "/home/zavatra/z-bench/apps/frappe/frappe/sessions.py", line 256, in resume
    data = self.get_session_record()
  File "/home/zavatra/z-bench/apps/frappe/frappe/sessions.py", line 273, in get_session_record
    r = self.get_session_data()
  File "/home/zavatra/z-bench/apps/frappe/frappe/sessions.py", line 289, in get_session_data
    data = self.get_session_data_from_db()
  File "/home/zavatra/z-bench/apps/frappe/frappe/sessions.py", line 323, in get_session_data_from_db
    self.delete_session()
  File "/home/zavatra/z-bench/apps/frappe/frappe/sessions.py", line 335, in delete_session
    delete_session(self.sid, reason="Session Expired")
  File "/home/zavatra/z-bench/apps/frappe/frappe/sessions.py", line 87, in delete_session
    logout_feed(user, reason)
  File "/home/zavatra/z-bench/apps/frappe/frappe/core/doctype/activity_log/feed.py", line 57, in logout_feed
    add_authentication_log(subject, user, operation="Logout")
  File "/home/zavatra/z-bench/apps/frappe/frappe/core/doctype/activity_log/activity_log.py", line 44, in add_authentication_log
    }).insert(ignore_permissions=True, ignore_links=True)
  File "/home/zavatra/z-bench/apps/frappe/frappe/model/document.py", line 249, in insert
    self.run_post_save_methods()
  File "/home/zavatra/z-bench/apps/frappe/frappe/model/document.py", line 916, in run_post_save_methods
    self.run_method("on_update")
  File "/home/zavatra/z-bench/apps/frappe/frappe/model/document.py", line 781, in run_method
    out = Document.hook(fn)(self, *args, **kwargs)
  File "/home/zavatra/z-bench/apps/frappe/frappe/model/document.py", line 1061, in composer
    return composed(self, method, *args, **kwargs)
  File "/home/zavatra/z-bench/apps/frappe/frappe/model/document.py", line 1046, in runner
    add_to_return_value(self, f(self, method, *args, **kwargs))
  File "/home/zavatra/z-bench/apps/frappe/frappe/automation/doctype/assignment_rule/assignment_rule.py", line 116, in apply
    assignment_rules = frappe.cache().get_value('assignment_rule', get_assignment_rules)
  File "/home/zavatra/z-bench/apps/frappe/frappe/utils/redis_wrapper.py", line 79, in get_value
    val = generator()
  File "/home/zavatra/z-bench/apps/frappe/frappe/automation/doctype/assignment_rule/assignment_rule.py", line 146, in get_assignment_rules
    return [d.document_type for d in frappe.db.get_all('Assignment Rule', fields=['document_type'], filters=dict(disabled = 0))]
  File "/home/zavatra/z-bench/apps/frappe/frappe/database/database.py", line 514, in get_all
    return frappe.get_all(*args, **kwargs)
  File "/home/zavatra/z-bench/apps/frappe/frappe/__init__.py", line 1282, in get_all
    return get_list(doctype, *args, **kwargs)
  File "/home/zavatra/z-bench/apps/frappe/frappe/__init__.py", line 1255, in get_list
    return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
  File "/home/zavatra/z-bench/apps/frappe/frappe/model/db_query.py", line 93, in execute
    result = self.build_and_run()
  File "/home/zavatra/z-bench/apps/frappe/frappe/model/db_query.py", line 105, in build_and_run
    args = self.prepare_args()
  File "/home/zavatra/z-bench/apps/frappe/frappe/model/db_query.py", line 124, in prepare_args
    self.set_optional_columns()
  File "/home/zavatra/z-bench/apps/frappe/frappe/model/db_query.py", line 275, in set_optional_columns
    columns = frappe.db.get_table_columns(self.doctype)
  File "/home/zavatra/z-bench/apps/frappe/frappe/database/database.py", line 836, in get_table_columns
    raise self.ProgrammingError
ProgrammingError