Restore on Local Machine

Installed fresh VM. Ran bench update after bech-repo tweak.

No errors - progress:)

Installed erpnext and made sure the installed apps matched what I have on the live version. The only one I could not install is the frappe subscription app as that was not available. (is there a way of installing that from VM?)

when i run the restore command i get
Traceback (innermost last): File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 54, in application init_request(request) File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 115, in init_request frappe.local.http_request = frappe.auth.HTTPRequest() File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 45, in __init__ frappe.local.login_manager = LoginManager() File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 103, in __init__ self.make_session(resume=True) File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 154, in make_session full_name=self.full_name, user_type=self.user_type) File "/home/frappe/frappe-bench/apps/frappe/frappe/sessions.py", line 166, in __init__ self.resume() File "/home/frappe/frappe-bench/apps/frappe/frappe/sessions.py", line 232, in resume frappe.local.user_lang = frappe.translate.get_user_lang(self.data.user) File "/home/frappe/frappe-bench/apps/frappe/frappe/translate.py", line 55, in get_user_lang user_lang = frappe.db.get_value("User", user, "language") File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 397, in get_value ret = self.get_values(doctype, filters, fieldname, ignore, as_dict, debug, cache=cache) File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 445, in get_values out = self.get_values_from_single(fields, filters, doctype, as_dict, debug, update) File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 485, in get_values_from_single tuple(fields) + (doctype,), as_dict=False, debug=debug) File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 136, in sql self._cursor.execute(query, values) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue ProgrammingError: (1146, "Table 'd56cb677ea.tabSingles' doesn't exist")

At what point in the restore does this happen?

It looks like it is having an issue finding the data for one of your users, or maybe an issue getting the language setting for one of your users. Iā€™m really not too sure how to fix this one. Try a bench migrate on your database before backup and restore?

Does anyone have any other suggestions?

Sorted!

I think. I dare not uninstall and try again to check :wink:

I installed a fresh VM then tried the restore without running the bench update and it seems to have worked

2 Likes

Hello @vjFaLk , while doing bench migrate, I got this error. Can you please help.