do bench migrate and bench build
bench --site <site name> migrate
bench --site <site name> build
enclosed error screen after running
bench --site erp.nhclindia.com migrate
still home page is not served URL
http://192.168.168.83:8000
Try running
bench setup requirementsbench build- and then
bench --site <sitename> migrate
what output do you get on running bench version and bench doctor ?
ubuntu@ubunu2004:/opt/bench/erpnext$ ls -l
total 28
drwxrwxrwx 4 erpnext erpnext 4096 Apr 29 14:42 apps
drwxrwxrwx 3 erpnext erpnext 4096 Apr 29 16:53 config
drwxrwxrwx 5 erpnext erpnext 4096 Apr 29 11:28 env
drwxrwxrwx 2 erpnext erpnext 4096 May 2 15:56 logs
-rwxrwxrwx 1 erpnext erpnext 346 Apr 29 11:24 patches.txt
-rwxrwxrwx 1 erpnext erpnext 546 Apr 29 11:24 Procfile
drwxrwxrwx 4 erpnext erpnext 4096 Apr 29 11:36 sites
ubuntu@ubunu2004:/opt/bench/erpnext$ bench version
Traceback (most recent call last):
File “/usr/lib/python3.8/runpy.py”, line 194, in _run_module_as_main
return _run_code(code, main_globals, None,
File “/usr/lib/python3.8/runpy.py”, line 87, in _run_code
exec(code, run_globals)
File “/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py”, line 109, in
main()
File “/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py”, line 18, i n main
click.Group(commands=commands)(prog_name=“bench”)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 829, in call
return self.main(*args, **kwargs)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 782, in main
rv = self.invoke(ctx)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 610, in invoke
return callback(*args, **kwargs)
File “/opt/bench/erpnext/apps/frappe/frappe/commands/utils.py”, line 1042, in get_version
app_info.commit = Repo(frappe.get_app_path(app, “…”)).head.object.hexsha[:7 ]
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/git/refs/symbolic.py” , line 210, in _get_object
return Object.new_from_sha(self.repo, hex_to_bin(self.dereference_recursive( self.repo, self.path)))
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/git/objects/base.py”, line 85, in new_from_sha
oinfo = repo.odb.info(sha1)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/git/db.py”, line 43, in info
hexsha, typename, size = self._git.get_object_header(bin_to_hex(binsha))
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/git/cmd.py”, line 125 3, in get_object_header
return self.__get_object_header(cmd, ref)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/git/cmd.py”, line 124 0, in __get_object_header
return self._parse_object_header(cmd.stdout.readline())
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/git/cmd.py”, line 119 8, in _parse_object_header
raise ValueError(“SHA could not be resolved, git returned: %r” % (header_lin e.strip()))
ValueError: SHA could not be resolved, git returned: b’’
ubuntu@ubunu2004:/opt/bench/erpnext$
ubuntu@ubunu2004:/opt/bench/erpnext$ bench doctor
-----Checking scheduler status-----
Traceback (most recent call last):
File “/usr/lib/python3.8/runpy.py”, line 194, in _run_module_as_main
return _run_code(code, main_globals, None,
File “/usr/lib/python3.8/runpy.py”, line 87, in _run_code
exec(code, run_globals)
File “/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py”, line 109, in
main()
File “/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=“bench”)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 829, in call
return self.main(*args, **kwargs)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 782, in main
rv = self.invoke(ctx)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/core.py”, line 610, in invoke
return callback(*args, **kwargs)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/click/decorators.py”, line 21, in new_func
return f(get_current_context(), *args, **kwargs)
File “/opt/bench/erpnext/apps/frappe/frappe/commands/init.py”, line 29, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/opt/bench/erpnext/apps/frappe/frappe/commands/scheduler.py”, line 152, in doctor
return _doctor(site=site)
File “/opt/bench/erpnext/apps/frappe/frappe/utils/doctor.py”, line 109, in doctor
if is_scheduler_disabled():
File “/opt/bench/erpnext/apps/frappe/frappe/utils/scheduler.py”, line 125, in is_scheduler_disabled
frappe.db.get_single_value(“System Settings”, “enable_scheduler”)
File “/opt/bench/erpnext/apps/frappe/frappe/database/database.py”, line 671, in get_single_value
val = self.query.get_sql(
File “/opt/bench/erpnext/apps/frappe/frappe/query_builder/utils.py”, line 71, in execute_query
return frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
File “/opt/bench/erpnext/apps/frappe/frappe/database/database.py”, line 169, in sql
self._cursor.execute(query, values)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/pymysql/cursors.py”, line 148, in execute
result = self._query(query)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/pymysql/cursors.py”, line 310, in _query
conn.query(q)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/pymysql/connections.py”, line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/pymysql/connections.py”, line 775, in _read_query_result
result.read()
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/pymysql/connections.py”, line 1156, in read
first_packet = self.connection._read_packet()
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/pymysql/connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “/opt/bench/erpnext/env/lib/python3.8/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, “Table ‘_af08058d6f4e147f.tabSingles’ doesn’t exist”)
bench --version
5.8.1
It looks like error is some table -1146, “Table ‘_af08058d6f4e147f.tabSingles’ doesn’t exist”
Can you please suggest how to resolve this issue.
I get the same error for Frappe framework tutorial project - Library management system
