Error if we try to search on the search bar in Home Page - Table 'xxx.help' doesn't exist

Frappe Framework Bug
1

Hi,

Whenever we are trying to search anything on the Search bar, it is always giving an error.

Error is pasted below:

Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 62, in application
    response = frappe.handler.handle()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 22, in handle
    data = execute_cmd(cmd)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 53, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 939, in call
    return fn(*args, **newargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/help.py", line 32, in get_help
    return HelpDatabase().search(text)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/help.py", line 106, in search
    select title, intro, path from help where match(content) against (%s) limit 10''', ('%'+words+'%', words))
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 166, in sql
    self._cursor.execute(query, values)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
    result = self._query(query)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
    conn.query(q)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
    result.read()
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
    first_packet = self.connection._read_packet()
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
    packet.check_error()
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
    err.raise_mysql_exception(self._data)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
    raise errorclass(errno, errval)
ProgrammingError: (1146, u"Table '1bd3e0294da19198.help' doesn't exist")

Request help to resolve this.

2

hi @Ravi_Kumar_Tenneti Use bench setup help in your bench

3

Not able to understand which argument should be selected to clear off this error:

add-domain Add custom domain to site
auto-update Add cronjob for bench auto update
backups Add cronjob for bench backups
config overwrite or make config.json
env Setup virtualenv for bench
fail2ban
firewall Setup firewall
fonts Add frappe fonts to system
lets-encrypt Setup lets-encrypt for site
manager Setup bench-manager.local site with the…
nginx generate config for nginx
procfile Setup Procfile for bench start
production setup bench for production
redis generate config for redis cache
reload-nginx
remove-domain Remove custom domain from a site
requirements Update Python and Node packages
role Install dependancies via roles
socketio Setup node deps for socketio server
ssh-port Set SSH Port
sudoers Add commands to sudoers list for execution…
supervisor generate config for supervisor with an…
sync-domains

4

Indeed yes the command ‘bench setup help’ no longer exists!

frappe@ubuntu:~/frappe-bench$ bench --help | grep help
–help Show this message and exit.
rebuild-global-search Setup help table in the current site (called…
setup-global-help setup help table in a separate database that…
setup-help Setup help table in the current site (called…

Instead try ‘bench setup-help’

That worked for me

frappe@ubuntu:~/frappe-bench$ bench setup-help
Syncing help database…
frappe@ubuntu:~/frappe-bench$

Table '****.help' doesn't exist - #3 by lasalesi

5

if we use this command, it is throwing an error

su frappe bench setup-help
/usr/local/bin/bench: line 3: requires: command not found
/usr/local/bin/bench: line 4: import: command not found
/usr/local/bin/bench: line 5: import: command not found
from: can’t read /var/mail/pkg_resources
/usr/local/bin/bench: bench: line 9: syntax error near unexpected token (' /usr/local/bin/bench: bench: line 9: sys.argv[0] = re.sub(r’(-script.pyw?|.exe)?$‘, ‘’, sys.argv[0])’

6

How to check if ERPNext is implemented properly as some or other error is what I am getting while typing anything on the Search bar in Home Page

7

bench commands are run from /home/frappe/frappe-bench directory.

Possibly that is the problem here?