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/app.py", line 51, in application
    response = frappe.handler.handle()
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/handler.py", line 69, in handle
    execute_cmd(cmd)
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/handler.py", line 92, in execute_cmd
    ret = frappe.call(method, **frappe.form_dict)
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/__init__.py", line 751, in call
    return fn(*args, **newargs)
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 14, in get
    return compress(execute(**get_form_params()))
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 17, in execute
    return DatabaseQuery(doctype).execute(*args, **kwargs)
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/model/db_query.py", line 50, in execute
    return self.build_and_run()
  File "/home/akarsh/frappe-bench/apps/frappe/frappe/model/db_query.py", 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/database.py", line 146, in sql
    self._cursor.execute(query)
  File "/home/akarsh/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/akarsh/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 OperationalError: (1054, "Unknown column 'tabLoan Management.company' in 'field list'")

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

Thanks

This is your error, check your fields.

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

1 Like

Got it. Thanks