Hi,
I have an installation of erpnext in a server that I want to update (the version of erpnext is 8.0.25 ).
I do the following steps:
1- cd /home/frappe/frape-bench
2- bench update → then I get an error with the following message:
Here are your choices:
- Merge the frappe app manually with “git pull” / “git pull --rebase” and fix conflicts.
- Temporarily remove your changes with “git stash” or discard them completely
with “bench update --reset” or for individual repositries “git reset --hard” - If your changes are helpful for others, send in a pull request via GitHub and
wait for them to be merged in the core.
–
3- I’m going to the folders /home/frappe/.bench and do the commands “git pull” and after seeing an error about uncommited files I do the command “git commit -a” and after that “git pull”
4- After that I’m going again to /home/frappe/frape-bench/apps/frappe and I do again “git pull” get an error message, so I do it again “git commit -a” and after that again “git pull” … I think everything it goes all right …
5- After doing a “bench update” again I obtain message that erpnext app needs to commit and pull, so I did the same “git commit -a” and “git pull”
6- Then again in /home/frappe/frappe-bench I run the command “bench update” … and after this I get an error … This is the complete (ok, I cuted the message because is too long, it stat just before the first warn) on screen message after do it “bench update”
│ └─┬ socks@1.1.10
│ ├── ip@1.1.5
│ └── smart-buffer@1.1.15
└── q@1.4.1
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: fsevents@^1.0.0 (node_modules/chokidar/node_modules/fsevents):
npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for fsevents@1.1.2: wanted {"os":"darwin","arch":"any"} (current: {"os":"linux","arch":"x64"})
npm WARN frappe@ No description
Backing up sites...
Patching sites...
Migrating demoerp.umuq.local
Executing frappe.patches.v8_0.update_records_in_global_search #11-05-2017 in demoerp.umuq.local (05a2edf112b9de9e)
Updating Global Search : [========================================]Success
Executing execute:frappe.reload_doc('core', 'doctype', 'role') #2017-05-23 in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing frappe.patches.v8_0.update_gender_and_salutation in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing execute:frappe.db.sql('update tabReport set module="Desk" where name="ToDo"') in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing frappe.patches.v8_1.enable_allow_error_traceback_in_system_settings in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing frappe.patches.v8_1.update_format_options_in_auto_email_report in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing frappe.patches.v8_1.delete_custom_docperm_if_doctype_not_exists in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing frappe.patches.v8_5.delete_email_group_member_with_invalid_emails in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing frappe.patches.v8_x.update_user_permission in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.move_perpetual_inventory_setting in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing execute:frappe.reload_doc('stock', 'doctype', 'warehouse') # 2017-04-24 in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.create_domain_docs #16-05-2017 in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.fix_status_for_invoices_with_negative_outstanding in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.make_payments_table_blank_for_non_pos_invoice in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.set_sales_invoice_serial_number_from_delivery_note in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.delete_schools_depricated_doctypes in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.update_customer_pos_id in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.rename_items_in_status_field_of_material_request in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.delete_bin_indexes in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.move_account_head_from_account_to_warehouse_for_inventory in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.change_in_words_varchar_length in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.update_stock_qty_value_in_bom_item in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.update_sales_cost_in_project in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.save_system_settings in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.delete_deprecated_reports in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.setup_gst_india #2017-06-27 in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing execute:frappe.reload_doc('regional', 'doctype', 'gst_hsn_code') in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.removed_roles_from_gst_report_non_indian_account in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.gst_fixes #2017-07-06 in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_0.update_production_orders in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.remove_sales_invoice_from_returned_serial_no in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.allow_invoice_copy_to_edit_after_submit in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.add_hsn_sac_codes in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.update_gst_state #17-07-2017 in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.removed_report_support_hours in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.add_indexes_in_transaction_doctypes in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_3.set_restrict_to_domain_for_module_def in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.update_expense_claim_status in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_3.update_company_total_sales in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_4.make_scorecard_records in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_1.set_delivery_date_in_so_item #2017-07-28 in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_5.fix_tax_breakup_for_non_invoice_docs in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_5.remove_quotations_route_in_sidebar in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_5.update_existing_data_in_project_type in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_5.set_default_mode_of_payment in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_5.update_customer_group_in_POS_profile in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_6.update_timesheet_company_from_PO in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_6.set_write_permission_for_quotation_for_sales_manager in demoerp.umuq.local (05a2edf112b9de9e)
Success
Executing erpnext.patches.v8_5.remove_project_type_property_setter in demoerp.umuq.local (05a2edf112b9de9e)
Success
Updating DocTypes for frappe : [========================================]
Updating DocTypes for erpnext : [========================================]
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 "/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 217, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File "/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py", line 46, in migrate
router.sync_global_search()
File "/home/frappe/frappe-bench/apps/frappe/frappe/website/router.py", line 360, in sync_global_search
sync_global_search()
File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/global_search.py", line 264, in sync_global_search
content = %(content)s''', value)
File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 154, in sql
self._cursor.execute(query, values)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 232, in execute
args = dict((key, db.literal(item)) for key, item in args.items())
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 232, in <genexpr>
args = dict((key, db.literal(item)) for key, item in args.items())
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 316, in literal
s = self.escape(o, self.encoders)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 215, in string_literal
return db.string_literal(obj)
UnicodeEncodeError: 'ascii' codec can't encode character u'\xfa' in position 2: ordinal not in range(128)
frappe@galadriel:~/frappe-bench$
What is the error? I hope somebody can help me because off course my erpnext instance don’t working anymore …
Thanks
Best