Hello,
I used the command suggested by you, and after that I ran bench --site site1.local migrate.
I got this error.
root@ubuntu:/home/ubuntu# cd /home/frappe/
root@ubuntu:/home/frappe# cd frappe-bench/
root@ubuntu:/home/frappe/frappe-bench# cd sites/
root@ubuntu:/home/frappe/frappe-bench/sites# cd site1.local/
root@ubuntu:/home/frappe/frappe-bench/sites/site1.local# cd public/
root@ubuntu:/home/frappe/frappe-bench/sites/site1.local/public# cd files/
root@ubuntu:/home/frappe/frappe-bench/sites/site1.local/public/files# ls
20190318_120002_05f53e6f_database.sql
root@ubuntu:/home/frappe/frappe-bench/sites/site1.local/public/files# cd /home/frappe/
root@ubuntu:/home/frappe# cd frappe-bench/
root@ubuntu:/home/frappe/frappe-bench# sudo bench --force --site site1.local restore /sites/site1.local/public/files/20190318_120002_05f53e6f_database.sql
MySQL root password:
Creating Database…
172MiB 0:00:58 [2.94MiB/s] [=====================================================================================================================================================>] 100%
*** Scheduler is disabled ***
root@ubuntu:/home/frappe/frappe-bench# bench - -site site1.local migrate
Usage: bench [OPTIONS] COMMAND [ARGS]…
Bench manager for Frappe
Options:
–version
–help Show this message and exit.
Commands:
backup backup site
backup-all-sites backup all sites
config change bench configuration
disable-production Disables production environment for the bench.
download-translations Download latest translations
exclude-app Exclude app from updating
get-app clone an app from the internet and set it up in…
include-app Include app from updating
init Create a New Bench Instance.
install Install system dependancies
migrate-env Migrate Virtual Environment to desired Python…
new-app start a new app
prepare-beta-release Prepare major beta release from develop branch
release Release app (internal to the Frappe team)
remote-reset-url Reset app remote url to frappe official
remote-set-url Set app remote url
remote-urls Show apps remote url
remove-app completely remove app from bench
renew-lets-encrypt Renew Let’s Encrypt certificate
restart Restart supervisor processes or systemd units
retry-upgrade
set-default-site Set default site for bench
set-mariadb-host Set MariaDB host for bench
set-nginx-port Set nginx port for site
set-ssl-certificate Set ssl certificate path for site
set-ssl-key Set ssl certificate private key path for site
set-url-root Set url root for site
setup Setup bench
shell
src Prints bench source folder path, which can be used…
start Start Frappe development processes
switch-to-branch Switch all apps to specified branch, or specify…
switch-to-develop Switch frappe and erpnext to develop branch
switch-to-master Switch frappe and erpnext to master branch
update Update bench
root@ubuntu:/home/frappe/frappe-bench# bench --site site1.local migrate
Migrating site1.local
Executing frappe.patches.v8_0.drop_in_dialog #2017-09-22 in site1.local (1bd3e0294da19198)
Success: Done in 0.144s
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘doctype’, force=True) #2017-09-22 in site1.local (1bd3e0294da19198)
Success: Done in 1.178s
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘docfield’, force=True) #2018-02-20 in site1.local (1bd3e0294da19198)
Success: Done in 1.261s
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘docperm’) #2018-05-29 in site1.local (1bd3e0294da19198)
Success: Done in 0.518s
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘module_def’) #2017-09-22 in site1.local (1bd3e0294da19198)
Success: Done in 0.341s
Executing frappe.patches.v11_0.replicate_old_user_permissions in site1.local (1bd3e0294da19198)
Success: Done in 0.073s
Executing frappe.patches.v11_0.drop_column_apply_user_permissions in site1.local (1bd3e0294da19198)
Success: Done in 1.485s
Executing frappe.patches.v11_0.reload_and_rename_view_log #2019-01-03 in site1.local (1bd3e0294da19198)
Success: Done in 0.179s
Executing frappe.patches.v11_0.copy_fetch_data_from_options in site1.local (1bd3e0294da19198)
Success: Done in 2.007s
Executing frappe.patches.v11_0.change_email_signature_fieldtype in site1.local (1bd3e0294da19198)
Success: Done in 0.828s
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘activity_log’) in site1.local (1bd3e0294da19198)
Success: Done in 0.423s
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘domain_settings’) in site1.local (1bd3e0294da19198)
Success: Done in 0.136s
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘user’) #2017-10-27 in site1.local (1bd3e0294da19198)
Success: Done in 0.03s
Executing frappe.patches.v8_1.delete_custom_docperm_if_doctype_not_exists in site1.local (1bd3e0294da19198)
Success: Done in 0.039s
Executing frappe.patches.v8_5.delete_email_group_member_with_invalid_emails in site1.local (1bd3e0294da19198)
Success: Done in 0.155s
Executing frappe.patches.v8_x.update_user_permission in site1.local (1bd3e0294da19198)
Success: Done in 1.515s
Executing frappe.patches.v8_5.patch_event_colors in site1.local (1bd3e0294da19198)
Success: Done in 0.053s
Executing frappe.patches.v8_10.delete_static_web_page_from_global_search in site1.local (1bd3e0294da19198)
Success: Done in 0.03s
Executing frappe.patches.v9_1.add_sms_sender_name_as_parameters in site1.local (1bd3e0294da19198)
Success: Done in 0.285s
Executing frappe.patches.v9_1.resave_domain_settings in site1.local (1bd3e0294da19198)
Success: Done in 0.099s
Executing frappe.patches.v9_1.revert_domain_settings in site1.local (1bd3e0294da19198)
Success: Done in 0.763s
Executing frappe.patches.v9_1.move_feed_to_activity_log in site1.local (1bd3e0294da19198)
Success: Done in 11.998s
Executing execute:frappe.delete_doc(‘Page’, ‘data-import-tool’, ignore_missing=True) in site1.local (1bd3e0294da19198)
Success: Done in 1.685s
Executing frappe.patches.v10_0.reload_countries_and_currencies in site1.local (1bd3e0294da19198)
Updating country info : [========================================]
Success: Done in 0.727s
Executing frappe.patches.v10_0.refactor_social_login_keys in site1.local (1bd3e0294da19198)
Success: Done in 2.082s
Executing frappe.patches.v10_0.enable_chat_by_default_within_system_settings in site1.local (1bd3e0294da19198)
Success: Done in 3.553s
Executing frappe.patches.v10_0.remove_custom_field_for_disabled_domain in site1.local (1bd3e0294da19198)
Success: Done in 0.282s
Executing execute:frappe.delete_doc(“Page”, “chat”) in site1.local (1bd3e0294da19198)
Success: Done in 0.201s
Executing frappe.patches.v10_0.migrate_passwords_passlib in site1.local (1bd3e0294da19198)
Success: Done in 2.718s
Executing frappe.patches.v11_0.rename_standard_reply_to_email_template in site1.local (1bd3e0294da19198)
Success: Done in 2.204s
Executing execute:frappe.delete_doc_if_exists(‘Page’, ‘user-permissions’) in site1.local (1bd3e0294da19198)
Success: Done in 0.389s
Executing frappe.patches.v10_0.set_no_copy_to_workflow_state in site1.local (1bd3e0294da19198)
Success: Done in 0.061s
Executing frappe.patches.v10_0.increase_single_table_column_length in site1.local (1bd3e0294da19198)
Success: Done in 0.039s
Executing frappe.patches.v11_0.create_contact_for_user in site1.local (1bd3e0294da19198)
Success: Done in 24.094s
Executing frappe.patches.v11_0.sync_stripe_settings_before_migrate in site1.local (1bd3e0294da19198)
Success: Done in 0.036s
Executing frappe.patches.v11_0.update_list_user_settings in site1.local (1bd3e0294da19198)
Success: Done in 0.462s
Executing frappe.patches.v11_0.rename_workflow_action_to_workflow_action_master #13-06-2018 in site1.local (1bd3e0294da19198)
Success: Done in 1.364s
Executing frappe.patches.v11_0.rename_email_alert_to_notification #13-06-2018 in site1.local (1bd3e0294da19198)
Success: Done in 3.68s
Executing frappe.patches.v11_0.delete_duplicate_user_permissions in site1.local (1bd3e0294da19198)
Success: Done in 0.048s
Executing frappe.patches.v11_0.set_dropbox_file_backup in site1.local (1bd3e0294da19198)
Success: Done in 1.018s
Executing frappe.patches.v10_0.set_default_locking_time in site1.local (1bd3e0294da19198)
Success: Done in 0.035s
Executing frappe.patches.v11_0.rename_google_maps_doctype in site1.local (1bd3e0294da19198)
Success: Done in 0.04s
Executing frappe.patches.v10_0.modify_smallest_currency_fraction in site1.local (1bd3e0294da19198)
Success: Done in 0.033s
Executing frappe.patches.v10_0.modify_naming_series_table in site1.local (1bd3e0294da19198)
Success: Done in 0.067s
Executing frappe.patches.v10_0.enhance_security in site1.local (1bd3e0294da19198)
Success: Done in 2.695s
Executing frappe.patches.v11_0.multiple_references_in_events in site1.local (1bd3e0294da19198)
Success: Done in 0.768s
Executing frappe.patches.v11_0.set_allow_self_approval_in_workflow in site1.local (1bd3e0294da19198)
Success: Done in 0.325s
Executing frappe.patches.v11_0.remove_skip_for_doctype in site1.local (1bd3e0294da19198)
Success: Done in 19.875s
Executing frappe.patches.v11_0.migrate_report_settings_for_new_listview in site1.local (1bd3e0294da19198)
Success: Done in 0.24s
Executing frappe.patches.v11_0.delete_all_prepared_reports in site1.local (1bd3e0294da19198)
Success: Done in 0.073s
Executing frappe.patches.v11_0.fix_order_by_in_reports_json in site1.local (1bd3e0294da19198)
Success: Done in 0.035s
Executing execute:frappe.delete_doc(‘Page’, ‘applications’, ignore_missing=True) in site1.local (1bd3e0294da19198)
Success: Done in 0.19s
Executing frappe.patches.v11_0.set_missing_creation_and_modified_value_for_user_permissions in site1.local (1bd3e0294da19198)
Success: Done in 0.051s
Executing frappe.patches.v11_0.remove_doctype_user_permissions_for_page_and_report in site1.local (1bd3e0294da19198)
Success: Done in 0.066s
Executing erpnext.patches.v8_9.set_print_zero_amount_taxes in site1.local (1bd3e0294da19198)
Success: Done in 0.712s
Executing erpnext.patches.v11_0.rename_production_order_to_work_order in site1.local (1bd3e0294da19198)
rename_field: work_order not found in Timesheet
Success: Done in 7.694s
Executing erpnext.patches.v11_0.refactor_naming_series in site1.local (1bd3e0294da19198)
Success: Done in 0.618s
Executing erpnext.patches.v11_0.refactor_autoname_naming in site1.local (1bd3e0294da19198)
Success: Done in 0.305s
Executing erpnext.patches.v10_0.rename_schools_to_education in site1.local (1bd3e0294da19198)
Success: Done in 2.08s
Executing erpnext.patches.v5_7.update_item_description_based_on_item_master in site1.local (1bd3e0294da19198)
Success: Done in 0.292s
Executing execute:frappe.reload_doc(“stock”, “doctype”, “stock_settings”) in site1.local (1bd3e0294da19198)
Success: Done in 0.259s
Executing execute:frappe.db.sql(“update tabStock Entry
set total_amount = 0 where purpose in(‘Repack’, ‘Manufacture’)”) in site1.local (1bd3e0294da19198)
Success: Done in 0.031s
Executing erpnext.patches.v9_0.remove_subscription_module in site1.local (1bd3e0294da19198)
Success: Done in 0.223s
Executing erpnext.patches.v8_7.make_subscription_from_recurring_data in site1.local (1bd3e0294da19198)
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 97, in
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 764, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1137, 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 1137, 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 956, 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 555, 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 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py”, line 227, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 38, 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/v8_7/make_subscription_from_recurring_data.py”, line 27, in execute
make_subscription(doctype, data, date_field)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/patches/v8_7/make_subscription_from_recurring_data.py”, line 55, in make_subscription
}).insert(ignore_permissions=True)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 211, in insert
self._set_defaults()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 598, in _set_defaults
new_doc = frappe.new_doc(df.options, as_dict=True)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 658, in new_doc
return get_new_doc(doctype, parent_doc, parentfield, as_dict=as_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/create_new.py”, line 21, in get_new_doc
frappe.local.new_doc_templates[doctype] = make_new_doc(doctype)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/create_new.py”, line 39, in make_new_doc
“docstatus”: 0
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 724, in get_doc
doc = frappe.model.document.get_doc(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 67, in get_doc
controller = get_controller(doctype)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 36, in get_controller
module = load_doctype_module(doctype, module_name)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/utils.py”, line 187, in load_doctype_module
raise ImportError(‘Module import failed for {0} ({1})’.format(doctype, module_name + ’ Error: ’ + str(e)))
ImportError: Module import failed for Subscription Plan Detail (frappe.core.doctype.subscription_plan_detail.subscription_plan_detail Error: No module named subscription_plan_detail.subscription_plan_detail)
root@ubuntu:/home/frappe/frappe-bench#
Please help.