[solved] I got error message alot Table ‘efc88b4f1234143c.help’ doesn’t exist

Server Error: Please check your server logs or contact tech support.
this message shows to me alot
when i search for any thing when i click on help

this is console log
localStorage cleared
jquery.min.js:4 POST mysiteurl here/ 500 (INTERNAL SERVER ERROR)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
frappe.request.call @ desk.min.js?ver=1504266188.0:1456
frappe.call @ desk.min.js?ver=1504266188.0:1350
(anonymous) @ desk.min.js?ver=1504266188.0:11934
get_help_results @ desk.min.js?ver=1504266188.0:11933
(anonymous) @ desk.min.js?ver=1504266188.0:11500
Promise resolved (async)
get_results @ desk.min.js?ver=1504266188.0:11498
get_results @ desk.min.js?ver=1504266188.0:11325
init_search @ desk.min.js?ver=1504266188.0:11309
onclick @ desk.min.js?ver=1504266188.0:11106
(anonymous) @ desk.min.js?ver=1504266188.0:11007
dispatch @ jquery.min.js:3
$event.dispatch @ report.min.js?ver=1504266188.0:3007
r.handle @ jquery.min.js:3
i.fire @ libs.min.js?ver=1504266188.0:2
select @ libs.min.js?ver=1504266188.0:2
keydown @ libs.min.js?ver=1504266188.0:2
desk.min.js?ver=1504266188.0:1557 Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 57, 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 922, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/help.py”, line 30, in get_help
return HelpDatabase().search(text)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/help.py”, line 87, 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 154, in sql
self._cursor.execute(query, values)
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 ‘efc88b4f1234143c.help’ doesn’t exist”)

just run sudo bench migrate and it should solve the problem and create the missing table because it looks like that u made changes on md files

1 Like

this solved the problem
thank you very very much

you are welcome :slight_smile:
please mark my reply as solution to help others and to show the topic as solved

@fatheyabdelslam it looks like you new member at the forum :slight_smile:
anyway you marked your reply as solution when you should mark my one as the solution to appear right to the users as this topic is solved :slight_smile:
anyway its not a big deal but its the right way to mark the solutions to the communitiy.

welcome to erpnext

1 Like

yes i’m new :smiley:
done marked your replay as a solution

you are welcome to erpnext :slight_smile:
but u marked your reply not mine :slight_smile:
you should go to my answer it self and mark it because you went to your reply on my post and marked it ,just mark my reply which is after your question directly , and as i said it does not matter but its the right way :smiley: