I have a working site. I want to do some customizations and i take backup of site by bench backup which gives a sql file. When i’m restoring it on local server than it it showing this error _mysql_exceptions.ProgrammingError: (1146, "Table '1bd3e0294da19198.tabCustom DocPerm' doesn't exist")
i’m trying around 1 week.
Below are the steps i followed
- Install fresh frappe
- Create new site
- Restore the backup file
this not worked so i followed a another step - Install fresh frappe
- Install erpnext
- Install customized app on local server which is on remove server
- restore the file
but results is same. - Create new site
- Restore the backup file
Here is the traceback
php@php-H81M-S:/opt/erp/frappe-bench$ bench --site site1.local --force restore /home/php/Davinder/Projects/2017/erpnext/Site_Bacup/20170325_002817_2cfb8c16_database.sql MySQL root password: Traceback (most recent call last): File "/usr/lib/python2.7/runpy.py", line 162, in _run_module_as_main "__main__", fname, loader, pkg_name) File "/usr/lib/python2.7/runpy.py", line 72, in _run_code exec code in run_globals File "/opt/erp/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 79, in <module> main() File "/opt/erp/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 16, in main click.Group(commands=commands)(prog_name='bench') File "/opt/erp/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 722, in __call__ return self.main(*args, **kwargs) File "/opt/erp/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main rv = self.invoke(ctx) File "/opt/erp/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/opt/erp/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/opt/erp/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke return ctx.invoke(self.callback, **ctx.params) File "/opt/erp/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke return callback(*args, **kwargs) File "/opt/erp/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func return f(get_current_context(), *args, **kwargs) File "/opt/erp/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 24, in _func ret = f(frappe._dict(ctx.obj), *args, **kwargs) File "/opt/erp/frappe-bench/apps/frappe/frappe/commands/site.py", line 104, in restore force=context.force) File "/opt/erp/frappe-bench/apps/frappe/frappe/commands/site.py", line 63, in _new_site frappe.utils.scheduler.toggle_scheduler(enable_scheduler) File "/opt/erp/frappe-bench/apps/frappe/frappe/utils/scheduler.py", line 210, in toggle_scheduler ss = frappe.get_doc("System Settings") File "/opt/erp/frappe-bench/apps/frappe/frappe/__init__.py", line 606, in get_doc return frappe.model.document.get_doc(arg1, arg2) File "/opt/erp/frappe-bench/apps/frappe/frappe/model/document.py", line 51, in get_doc return controller(arg1, arg2) File "/opt/erp/frappe-bench/apps/frappe/frappe/model/document.py", line 84, in __init__ self.load_from_db() File "/opt/erp/frappe-bench/apps/frappe/frappe/model/document.py", line 101, in load_from_db if not getattr(self, "_metaclass", False) and self.meta.issingle: File "/opt/erp/frappe-bench/apps/frappe/frappe/model/base_document.py", line 61, in meta self._meta = frappe.get_meta(self.doctype) File "/opt/erp/frappe-bench/apps/frappe/frappe/__init__.py", line 623, in get_meta return frappe.model.meta.get_meta(doctype, cached=cached) File "/opt/erp/frappe-bench/apps/frappe/frappe/model/meta.py", line 30, in get_meta return frappe.cache().hget("meta", doctype, lambda: Meta(doctype)) File "/opt/erp/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py", line 171, in hget value = generator() File "/opt/erp/frappe-bench/apps/frappe/frappe/model/meta.py", line 30, in <lambda> return frappe.cache().hget("meta", doctype, lambda: Meta(doctype)) File "/opt/erp/frappe-bench/apps/frappe/frappe/model/meta.py", line 66, in __init__ self.process() File "/opt/erp/frappe-bench/apps/frappe/frappe/model/meta.py", line 226, in process self.set_custom_permissions() File "/opt/erp/frappe-bench/apps/frappe/frappe/model/meta.py", line 313, in set_custom_permissions filters=dict(parent=self.name), update=dict(doctype='Custom DocPerm')) File "/opt/erp/frappe-bench/apps/frappe/frappe/__init__.py", line 1139, in get_all return get_list(doctype, *args, **kwargs) File "/opt/erp/frappe-bench/apps/frappe/frappe/__init__.py", line 1112, in get_list return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs) File "/opt/erp/frappe-bench/apps/frappe/frappe/model/db_query.py", line 83, in execute result = self.build_and_run() File "/opt/erp/frappe-bench/apps/frappe/frappe/model/db_query.py", line 95, in build_and_run args = self.prepare_args() File "/opt/erp/frappe-bench/apps/frappe/frappe/model/db_query.py", line 112, in prepare_args self.set_optional_columns() File "/opt/erp/frappe-bench/apps/frappe/frappe/model/db_query.py", line 212, in set_optional_columns columns = frappe.db.get_table_columns(self.doctype) File "/opt/erp/frappe-bench/apps/frappe/frappe/database.py", line 808, in get_table_columns return self.get_db_table_columns('tab' + doctype) File "/opt/erp/frappe-bench/apps/frappe/frappe/database.py", line 804, in get_db_table_columns return [r[0] for r in self.sql("DESC
%s" % table)] File "/opt/erp/frappe-bench/apps/frappe/frappe/database.py", line 149, in sql self._cursor.execute(query) File "/opt/erp/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/opt/erp/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.ProgrammingError: (1146, "Table '1bd3e0294da19198.tabCustom DocPerm' doesn't exist")