I am still finding out how do I do that? If you can be so nice please elaborate to the uninitiated plz…
I saw the below commands from your link. I am going to try it just now then I will give you feedback thanks @clarkej
shreyaspNov '16
@noetico
bench --site your_site console
In console: frappe.reload_doc(‘core’, ‘doctype’, ‘language’)
frappe.db.commit()
then proceed with bench --site your_site migrate
Like this:
frappe@erpnext:~/frappe-bench$ bench console
Python 2.7.6 (default, Jun 22 2015, 18:00:18)
Type “copyright”, “credits” or “license” for more information.
IPython 5.1.0 – An enhanced Interactive Python.
? → Introduction and overview of IPython’s features.
%quickref → Quick reference.
help → Python’s own help system.
object? → Details about ‘object’, use ‘object??’ for extra details.
In [1]: frappe.reload_doc(“integrations”, “doctype”, “webhook”)
That’s good progress, now check the logs for signs of an error…
For me, it’s:
Traceback (most recent call last):
File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 54, in application
init_request(request)
File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 116, in init_request
frappe.local.http_request = frappe.auth.HTTPRequest()
File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 53, in __init__
frappe.local.login_manager = LoginManager()
File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 111, in __init__
self.run_trigger('on_session_creation')
File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 232, in run_trigger
frappe.call(frappe.get_attr(method), login_manager=self)
File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 935, in call
return fn(*args, **newargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/communication/feed.py", line 59, in login_feed
add_authentication_log(subject, login_manager.user)
File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/authentication_log/authentication_log.py", line 22, in add_authentication_log
}).insert(ignore_permissions=True)
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 211, in insert
self.run_method("before_insert")
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 705, in run_method
run_webhooks(self, method)
File "/home/frappe/frappe-bench/apps/frappe/frappe/integrations/doctype/webhook/__init__.py", line 21, in run_webhooks
fields=["name", "webhook_docevent", "webhook_doctype"])
File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1173, in get_all
return get_list(doctype, *args, **kwargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1146, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 88, in execute
result = self.build_and_run()
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 100, in build_and_run
args = self.prepare_args()
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 117, in prepare_args
self.set_optional_columns()
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 218, in set_optional_columns
columns = frappe.db.get_table_columns(self.doctype)
File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 823, in get_table_columns
return self.get_db_table_columns('tab' + doctype)
File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 819, in get_db_table_columns
return [r[0] for r in self.sql("DESC `%s`" % table)]
File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 163, in sql
self._cursor.execute(query)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 250, in execute
self.errorhandler(self, exc, value)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
raise errorvalue
ProgrammingError: (1146, "Table 'd56cb677eaab3383.tabWebhook' doesn't exist")
That’s not end. Here is screenshot when I applied below command in bench console as suggested above i.e.
In [1]: frappe.reload_doc(“integrations”, “doctype”, “webhook”)
Ok… to know your site name; enter th terminal if you don’t have gui… do
Cd /home and hit enter from wherever you are
Then…
Cd frappe/frappe-bench/sites
Your site should be something like site1.local or maybe some other name like erpnext.vm if you got a vm image.
So the site name you can then use in the command.
Like this
Bench --site site1.local console
Hit enter.
Then continue.
One of the logs file; frappe.txt shows following traceback:
[DEBUG] 2017-11-01 03:39:18,290 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 03:43:19,397 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 03:47:19,475 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 03:51:20,517 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 03:55:21,570 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 03:59:22,629 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:03:23,695 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:07:24,711 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:11:25,720 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:15:26,750 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:19:27,772 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:23:28,777 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:27:29,807 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:31:31,095 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:35:31,179 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:39:32,203 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:43:33,283 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:47:34,352 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:51:35,393 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:55:36,490 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:59:37,583 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:03:38,636 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:07:39,641 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:11:40,678 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:15:41,751 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:19:42,784 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:23:43,909 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:27:45,025 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:31:46,470 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:35:47,551 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:39:48,660 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:43:49,781 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:47:50,830 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:51:51,280 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:55:52,393 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:59:53,471 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:03:53,554 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:07:54,610 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:11:55,688 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:15:56,872 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:19:57,923 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:24:22,740 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:28:22,856 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:32:24,354 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:36:25,456 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:40:26,513 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:44:27,525 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:48:28,556 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:52:29,603 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:56:30,654 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:00:31,665 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:04:32,771 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:08:33,810 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:12:34,900 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:16:35,946 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:20:36,960 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:24:37,974 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:28:39,000 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:32:40,269 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:36:40,319 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:40:41,341 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:44:42,403 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:48:43,464 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:52:44,494 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:56:45,560 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:00:46,622 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:04:48,107 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:08:49,129 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:12:50,151 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:19:32,144 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:23:33,210 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 05:59:20,115 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:03:20,317 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:07:20,471 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:11:21,520 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:22:15,049 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:26:16,006 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:30:17,023 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:34:18,024 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
No those are not tracebacks, they are identified like this:
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, in runmodule_as_main
“main”, fname, loader, pkg_name)
The bottom of the traceback typically has an Exception or Error message with clue to highlight hopefully the problem…
Also please rather than post pages of logs, to try to digest and focus on their content to get to the root of the problem, thanks…
Hello @clarkej, might you missed my comment: Unable to start ERPNext fter update from 8.xx to 9.xx - #29 by aaimaa .
This contains Traceback as well as a screenshot. This comment is just to bump, might you missed my comment.
Oh…thanks sir…I am now learning the basics of tracebacks…thanks for invaluable advise…
I am copying part of the traceback in worker.error log
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 79, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, 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 716, in call
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 79, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, 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 716, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, 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/core.py”, 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/core.py”, line 889, 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 534, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py”, line 166, in start_worker
start_worker(queue)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, in _run_module_as_main
“main”, fname, loader, pkg_name)
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, 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/core.py”, 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/core.py”, line 889, 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 534, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py”, line 166, in start_worker
start_worker(queue)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 102, in start_worker
Worker(queues, name=get_worker_name(queue)).work()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 457, in work
self.register_death()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 265, in register_death
p.execute()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2641, in execute
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 79, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, 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 716, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, 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/core.py”, 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/core.py”, line 889, 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 534, in invoke
return execute(conn, stack, raise_on_error)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2495, in _execute_transaction
connection.send_packed_command(all_cmds)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 538, in send_packed_command
self.connect()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 442, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 102, in start_worker
Worker(queues, name=get_worker_name(queue)).work()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 457, in work
self.register_death()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 265, in register_death
p.execute()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2641, in execute
return execute(conn, stack, raise_on_error)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2495, in _execute_transaction
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py”, line 166, in start_worker
start_worker(queue)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 102, in start_worker
Worker(queues, name=get_worker_name(queue)).work()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 457, in work
self.register_death()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 265, in register_death
p.execute()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2641, in execute
return execute(conn, stack, raise_on_error)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2495, in _execute_transaction
connection.send_packed_command(all_cmds)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 538, in send_packed_command
self.connect()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 442, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
connection.send_packed_command(all_cmds)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 538, in send_packed_command
self.connect()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 442, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
06:27:36 RQ worker u’rq:worker:erpnext.1502.short’ started, version 0.6.0
06:27:36 RQ worker u’rq:worker:erpnext.1488.default’ started, version 0.6.0
06:27:36 Cleaning registries for queue: default
06:27:36 RQ worker u’rq:worker:erpnext.1495.long’ started, version 0.6.0
06:27:36 Cleaning registries for queue: long
06:27:36 Cleaning registries for queue: short
06:27:36
06:27:36 *** Listening on short…
06:27:36
06:27:36 *** Listening on default…
06:27:36
06:27:36 *** Listening on long…
06:53:40 short: frappe.utils.background_jobs.execute_job(async=True, event=u’all’, job_name=u’frappe.email.queue.flush’, kwargs={}, method=u’frappe.email.queue.flush’, site=u’erpnext.vm’, user=u’Administrator’) (92bc1349-8c3f-44ba-ae46-4e356b199ab5)
06:53:41 short: Job OK (92bc1349-8c3f-44ba-ae46-4e356b199ab5)
06:53:41 Result is kept for 500 seconds
06:53:42
06:53:42 *** Listening on short…
06:53:42 short: frappe.utils.background_jobs.execute_job(async=True, event=u’all’, job_name=u’frappe.email.doctype.email_account.email_account.pull’, kwargs={}, method=u’frappe.email.doctype.email_account.email_account.pull’, site=u’erpnext.vm’, user=u’Administrator’) (991b266f-82e5-4451-a6e7-e0bacfc684d3)
06:53:43 short: Job OK (991b266f-82e5-4451-a6e7-e0bacfc684d3)
06:53:43 Result is kept for 500 seconds
06:53:43
06:53:43 *** Listening on short…
06:53:43 short: frappe.utils.background_jobs.execute_job(async=True, event=u’all’, job_name=u’frappe.email.doctype.email_account.email_account.notify_unreplied’, kwargs={}, method=u’frappe.email.doctype.email_account.email_account.notify_unreplied’, site=u’erpnext.vm’, user=u’Administrator’) (eb030e89-cc80-4c34-b9db-cab4041c0f3b)
06:53:44 short: Job OK (eb030e89-cc80-4c34-b9db-cab4041c0f3b)
06:53:44 Result is kept for 500 seconds
06:53:44
06:53:44 *** Listening on short…
06:55:41 short: frappe.utils.background_jobs.execute_job(async=True, event=u’all’, job_name=u’frappe.email.queue.flush’, kwargs={}, method=u’frappe.email.queue.flush’, site=u’erpnext.vm’, user=u’Administrator’) (37adfec7-3d6e-44af-9c3b-b262048ce2b6)
06:55:42 short: Job OK (37adfec7-3d6e-44af-9c3b-b262048ce2b6)
Wonderful, your update completed successfully.
This seems to be a server startup issue:
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
You may just need to restart you supervisor?
A forum search will point to how to do this.
best wishes
Right now I am searching the forum…thanks dear sir
I got this command from forum. I hope it’s the one you mean
sudo supervisorctl start all
and after “enter” nothing happened just went back to frappe-bench$
AND AFTER I UPDATED SITE AGAIN AND THEN WHEN I TRY TO MIGRATE FOLLOWING ERROR IS SHOWN ON THE TERMINAL DURING MIGRATE:
Well, you should see this
frappe@erpnext:~/frappe-bench$ sudo supervisorctl stop all
frappe-bench-frappe-schedule: stopped
frappe-bench-frappe-default-worker-0: stopped
frappe-bench-frappe-long-worker-0: stopped
frappe-bench-frappe-short-worker-0: stopped
frappe-bench-frappe-web: stopped
frappe-bench-node-socketio: stopped
frappe-bench-redis-queue: stopped
frappe-bench-redis-cache: stopped
frappe-bench-redis-socketio: stopped
frappe@erpnext:~/frappe-bench$ sudo supervisorctl start all
frappe-bench-frappe-schedule: started
frappe-bench-frappe-default-worker-0: started
frappe-bench-frappe-long-worker-0: started
frappe-bench-frappe-short-worker-0: started
frappe-bench-frappe-web: started
frappe-bench-node-socketio: started
frappe-bench-redis-queue: started
frappe-bench-redis-cache: started
frappe-bench-redis-socketio: started
frappe@erpnext:~/frappe-bench$
Please I suggest you start another thread
OK. I did stop all first that start all and then it shows the all started just like your post above but when I type localhost:8080 in my browser it still shows “updating, please refresh after sometime”
I also did
In [1]: frappe.reload_doc(“core”, “doctype”, “has_domain”)
The result is: False
1 Like
Hi
I have same error ( tabFees table is missing grand_total field) and run bench migrate can’t solved.
So I try to update tabFees table by manual script. I don’t know this way is good or not,
But After run script is ok. Before run script update your database first.
ALTER TABLE `tabFees` ADD COLUMN `fee_schedule` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `total_amount`;
ALTER TABLE `tabFees` ADD COLUMN `receivable_account` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `fee_schedule`;
ALTER TABLE `tabFees` ADD COLUMN `letter_head` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `receivable_account`;
ALTER TABLE `tabFees` ADD COLUMN `cost_center` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `letter_head`;
ALTER TABLE `tabFees` ADD COLUMN `income_account` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `cost_center`;
ALTER TABLE `tabFees` ADD COLUMN `posting_time` time(6) NULL DEFAULT NULL AFTER `income_account`;
ALTER TABLE `tabFees` ADD COLUMN `send_payment_request` int(1) NOT NULL DEFAULT 0 AFTER `posting_time`;
ALTER TABLE `tabFees` ADD COLUMN `set_posting_time` int(1) NOT NULL DEFAULT 0 AFTER `send_payment_request`;
ALTER TABLE `tabFees` ADD COLUMN `company` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `set_posting_time`;
ALTER TABLE `tabFees` ADD COLUMN `grand_total_in_words` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `company`;
ALTER TABLE `tabFees` ADD COLUMN `grand_total` decimal(18,6) NOT NULL DEFAULT 0.000000 AFTER `grand_total_in_words`;
ALTER TABLE `tabFees` ADD COLUMN `posting_date` date NULL DEFAULT NULL AFTER `grand_total`;
ALTER TABLE `tabFees` ADD COLUMN `include_payment` int(1) NOT NULL DEFAULT 0 AFTER `posting_date`;
ALTER TABLE `tabFees` ADD COLUMN `currency` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `include_payment`;
ALTER TABLE `tabFees` ADD COLUMN `student_batch` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `currency`;
ALTER TABLE `tabFees` ADD COLUMN `select_print_heading` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `student_batch`;
ALTER TABLE `tabFees` ADD COLUMN `student_email` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `select_print_heading`;