Error in custom doc

I have made a new doc ‘Loan Management’ in the HR Module. This is the error i am getting when i open the doc :

   Traceback (innermost last):
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/", line 51, in application
    response = frappe.handler.handle()
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/", line 69, in handle
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/", line 92, in execute_cmd
    ret =, **frappe.form_dict)
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/", line 751, in call
    return fn(*args, **newargs)
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/desk/", line 14, in get
    return compress(execute(**get_form_params()))
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/desk/", line 17, in execute
    return DatabaseQuery(doctype).execute(*args, **kwargs)
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/model/", line 50, in execute
    return self.build_and_run()
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/model/", line 62, in build_and_run
    return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug)
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/", line 146, in sql
  File "/home/akarsh/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/akarsh/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 OperationalError: (1054, "Unknown column 'tabLoan' in 'field list'")

What has caused this error ? How do i rectify it ?


This is your error, check your fields.

OperationalError: (1054, “Unknown column ‘tabLoan’ in ‘field list’”)

1 Like

Got it. Thanks