Getting error in bench migrate

After restored V6 database backup in V7. Getting error in bench migrate

Migrating site1.local
Executing frappe.patches.v7_0.update_auth in site1.local (1bd3e0294da19198)
Traceback (most recent call last):
File “/usr/lib/python2.7/”, line 162, in _run_module_as_main
main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/”, line 72, in _run_code
exec code in run_globals
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/”, line 79, in
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/”, line 16, in main
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/”, line 716, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/”, line 696, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/”, line 534, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/”, line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/”, line 207, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 27, in migrate
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/”, line 26, in run_all
if not run_single(patchmodule = patch):
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/”, line 60, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/”, line 80, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/frappe/frappe-bench/apps/frappe/frappe/patches/v7_0/”, line 21, in execute
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 622, in reload_doctype
reload_doc(scrub(db.get_value(“DocType”, doctype, “module”)), “doctype”, scrub(doctype), force=force)
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 634, in reload_doc
return frappe.modules.reload_doc(module, dt, dn, force=force)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/”, line 37, in reload_doc
return import_files(module, dt, dn, force=force)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/”, line 17, in import_files
return import_file(module, dt, dn, force=force, pre_process=pre_process)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/”, line 22, in import_file
ret = import_file_by_path(path, force, pre_process=pre_process)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/”, line 54, in import_file_by_path
import_doc(doc, force=force, data_import=data_import, pre_process=pre_process)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/”, line 114, in import_doc
frappe.delete_doc(doc.doctype,, force=1, ignore_doctypes=ignore, for_reload=True)
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 613, in delete_doc
ignore_permissions, flags)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/”, line 38, in delete_doc
remove_all(doctype, name)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/”, line 231, in remove_all
attached_to_doctype=%s and attached_to_name=%s"“”, (dt, dn)):
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 205, in sql_list
return [r[0] for r in self.sql(query, values, debug=debug)]
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 137, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, “Table ‘1bd3e0294da19198.tabFile’ doesn’t exist”)

are you restore use bench restore?
if yes,before bench migrate, use bench switch-to-master and bench update --patch

After run bench restore getting

Usage: bench restore [OPTIONS] SQL_FILE_PATH

Error: Missing argument “sql-file-path”.

frappe-bench$ bench use site1.local
frappe-bench$ bench --force restore sql_file_path
frappe-bench$ bench switch-to-master
frappe-bench$ bench update --upgrade
frappe-bench$ bench update --patch
frappe-bench$ bench migrate

2 months ago, i use this commands with my backup database v6 and restore to v7

Hello Thanks Komsel

I had only 1 site named “site1.local”
I did force restore - Successful.
switch to master - Successful.
bench update --upgrade thows following error → Bench Update --upgrade error -
bench update --patch thows following error → bench update --patch -
and bench migrate throws the same error i guess.

Can any one help. ? I have been using erpnext v6 on vm for a year now. but we need to move it new setup with debian 8 which install version 7 using easy install script. Erp version 7 works fine on fresh installation until restoring the ver 6 backup.

when i try to access the page it says “Updating. We will be back in a few moments…”

Would appreciate your help in this.