So I’m using erpnext latest version and I want to transfer to a new server. Before I do that I want to test the migration on a vm
I take my last backup file.
Create an new site with
bench new-site site3.local
Then
bench --site [sitename] --force restore /path/to/SQLFILE
bench --site [sitename] migrate
And I get this error:
> Migrating site3.local
Executing erpnext.patches.v11_0.rename_production_order_to_work_order in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v5_7.update_item_description_based_on_item_master in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.fichier_des_ecritures_comptables_for_france in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.added_extra_gst_custom_field in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.workflow_leave_application #2018-01-24 #2018-02-02 #2018-02-08 in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.item_barcode_childtable_migrate in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.rename_price_to_rate_in_pricing_rule in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.set_currency_in_pricing_rule in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.workflow_expense_claim in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.update_translatable_fields in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.rename_offer_letter_to_job_offer in site3.local (1dd227d3c848ccad) Success Executing execute:frappe.delete_doc('DocType', 'Production Planning Tool', ignore_missing=True) in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.migrate_daily_work_summary_settings_to_daily_work_summary_group in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.add_default_cash_flow_mappers in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v11_0.make_quality_inspection_template in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v10_0.remove_and_copy_fields_in_physician in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v11_0.add_index_on_nestedset_doctypes in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v11_0.remove_modules_setup_page in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v11_0.rename_employee_loan_to_loan in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v11_0.move_leave_approvers_from_employee in site3.local (1dd227d3c848ccad) Success Executing erpnext.patches.v11_0.update_department_lft_rgt in site3.local (1dd227d3c848ccad) Traceback (most recent call last): File "/usr/lib/python2.7/runpy.py", line 174, 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 "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 94, in <module> main() File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main click.Group(commands=commands)(prog_name='bench') File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 722, in __call__ return self.main(*args, **kwargs) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main rv = self.invoke(ctx) File "/home/frappe/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 "/home/frappe/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 "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke return callback(*args, **kwargs) File "/home/frappe/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 "/home/frappe/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 24, in _func ret = f(frappe._dict(ctx.obj), *args, **kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 222, in migrate migrate(context.verbose, rebuild_website=rebuild_website) File "/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py", line 31, in migrate frappe.modules.patch_handler.run_all() File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 29, in run_all if not run_single(patchmodule = patch): File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in run_single return execute_patch(patchmodule, method, methodargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 83, in execute_patch frappe.get_attr(patchmodule.split()[0] + ".execute")() File "/home/frappe/frappe-bench/apps/erpnext/erpnext/patches/v11_0/update_department_lft_rgt.py", line 14, in execute }).insert(ignore_permissions=True) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 248, in insert self.run_post_save_methods() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 889, in run_post_save_methods self.run_method("on_update") File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 757, in run_method out = Document.hook(fn)(self, *args, **kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 1026, in composer return composed(self, method, *args, **kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 1009, in runner add_to_return_value(self, fn(self, *args, **kwargs)) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 751, in <lambda> fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs) File "/home/frappe/frappe-bench/apps/erpnext/erpnext/hr/doctype/department/department.py", line 28, in on_update self.update_nsm_model() File "/home/frappe/frappe-bench/apps/erpnext/erpnext/hr/doctype/department/department.py", line 25, in update_nsm_model frappe.utils.nestedset.update_nsm(self) File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/nestedset.py", line 40, in update_nsm update_add_node(doc, p or '', pf) File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/nestedset.py", line 64, in update_add_node validate_loop(doc.doctype, doc.name, left, right) File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/nestedset.py", line 181, in validate_loop frappe.throw(_("Item cannot be added to its own descendents"), NestedSetRecursionError) File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 323, in throw msgprint(msg, raise_exception=exc, title=title, indicator='red') File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 309, in msgprint _raise_exception() File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 282, in _raise_exception raise raise_exception(encode(msg)) frappe.utils.nestedset.NestedSetRecursionError: Item cannot be added to its own descendents