Error after successful login, tabStudent Batch' doesn't exist"

ERPNext Education
1

Showing this error after reloading the page.

System Detail:

ERPNext: v8.0.24 (develop)
ERPNext Shopify: v2.0.5 (develop)
Frappe Framework: v8.0.42 (develop)

Error Logs:

127.0.0.1 - - [12/May/2017 16:36:23] "GET /assets/frappe/css/octicons/octicons.woff HTTP/1.1" 200 -
16:36:23 web.1            | Traceback (most recent call last):
16:36:23 web.1            |   File "/home/develop/development/apps/frappe/frappe/app.py", line 55, in application
16:36:23 web.1            |     response = frappe.handler.handle()
16:36:23 web.1            |   File "/home/develop/development/apps/frappe/frappe/handler.py", line 21, in handle
16:36:23 web.1            |     data = execute_cmd(cmd)
16:36:23 web.1            |   File "/home/develop/development/apps/frappe/frappe/handler.py", line 52, in execute_cmd
16:36:23 web.1            |     return frappe.call(method, **frappe.form_dict)
16:36:23 web.1            |   File "/home/develop/development/apps/frappe/frappe/__init__.py", line 907, in call
16:36:23 web.1            |     return fn(*args, **newargs)
16:36:23 web.1            |   File "/home/develop/development/apps/frappe/frappe/core/page/desktop/desktop.py", line 21, in get_help_messages
16:36:23 web.1            |     messages += frappe.get_attr(fn)()
16:36:23 web.1            |   File "/home/develop/development/apps/erpnext/erpnext/utilities/activation.py", line 54, in get_help_messages
16:36:23 web.1            |     if get_level() > 6:
16:36:23 web.1            |   File "/home/develop/development/apps/erpnext/erpnext/utilities/activation.py", line 40, in get_level
16:36:23 web.1            |     if frappe.db.count('Student Batch') > 5:
16:36:23 web.1            |   File "/home/develop/development/apps/frappe/frappe/database.py", line 790, in count
16:36:23 web.1            |     from `tab%s`""" % (dt,))[0][0]
16:36:23 web.1            |   File "/home/develop/development/apps/frappe/frappe/database.py", line 149, in sql
16:36:23 web.1            |     self._cursor.execute(query)
16:36:23 web.1            |   File "/home/develop/development/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
16:36:23 web.1            |     self.errorhandler(self, exc, value)
16:36:23 web.1            |   File "/home/develop/development/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
16:36:23 web.1            |     raise errorclass, errorvalue
16:36:23 web.1            | ProgrammingError: (1146, "Table 'b1846533a05c5b4f.tabStudent Batch' doesn't exist")

Regards
Navdeep

2

@navdeepghai,

Please try to run the bench migrate command first then login

3

Hi @makarand_b
Thank you for your reponse

Already done with these steps:
bench update
bench migrate

4

I’m seeing the same issue as @navdeepghai

I’m running:

$ bench version
erpnext 8.0.27
frappe 8.0.44

running bench migrate results in the following error:

Executing erpnext.patches.v8_0.merge_student_batch_and_student_group in ship (ship)
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/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 79, in <module>
    main()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 16, in main
    click.Group(commands=commands)(prog_name='bench')
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 700, in __call__
    return self.main(*args, **kwargs)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 680, in main
    rv = self.invoke(ctx)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1027, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1027, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 873, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 508, in invoke
    return callback(*args, **kwargs)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py", line 16, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 24, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands/site.py", line 214, in migrate
    migrate(context.verbose, rebuild_website=rebuild_website)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/migrate.py", line 31, in migrate
    frappe.modules.patch_handler.run_all()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 29, in run_all
    if not run_single(patchmodule = patch):
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in run_single
    return execute_patch(patchmodule, method, methodargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 83, in execute_patch
    frappe.get_attr(patchmodule.split()[0] + ".execute")()
  File "/home/erpnext/frappe-bench/apps/erpnext/erpnext/patches/v8_0/merge_student_batch_and_student_group.py", line 15, in execute
    program, academic_year, academic_term from `tabStudent Batch`''', as_dict=1)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 149, in sql
    self._cursor.execute(query)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, "Table 'ship.tabStudent Batch' doesn't exist")
5

Hi !!

Just pushed a patch for it, try to update your system using bench update command.

Then run bench migrate to see the changes.

Regards
Navdeep