Chart of Account Show Error

Hi, this error popup when i click chart of account after clean setup.

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 61, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 21, in handle
data = execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 56, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1026, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/client.py”, line 96, in get_value
return frappe.db.get_value(doctype, filters, fieldname, as_dict=as_dict, debug=debug)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 491, in get_value
order_by, cache=cache)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 535, in get_values
out = self._get_values_from_table(fields, filters, doctype, as_dict, debug, order_by, update)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 677, in _get_values_from_table
as_dict=as_dict, debug=debug, update=update)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 199, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 170, in execute
result = self._query(query)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 328, in _query
conn.query(q)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 517, 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 732, in _read_query_result
result.read()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1075, in read
first_packet = self.connection._read_packet()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 684, in _read_packet
packet.check_error()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/protocol.py”, line 220, 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 109, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (1054, u"Unknown column ‘allow_account_creation_against_child_company’ in ‘field list’")

If you’re self hosted try bench —site <site-name> migrate

frappe@erp:~/frappe-bench$ bench --site site1.local migrate
Migrating site1.local
Updating DocTypes for frappe : [========================================]
Updating DocTypes for erpnext : [========================================]
frappe@erp:~/frappe-bench$

problem still same when click Chart of Account

bench version
then
bench update

tried updated and refresh the chart of account page, same error.

I expected you to also share the output of

and perhaps bench update

Reinstall or add a new site
bench drop-site site1.local
bench new-site site1.local
bench —site site1.local install-app erpnext

We Experience the exact same issue

tried but still same problem

i done manual way with this

then i remove company and create new company, fixed

by manually add this column into company table will fixed this issue.

Just encountered same issue after upgrading to latest version! Is there any proper fix for this please?

Kind regards,

Also, this is a live setup so dropping the site or removing the Company is not an option…

ERPNext: v11.1.28 (master)
Frappe Framework: v11.1.27 (master)

Thanks

Not necessarily drop company.

Just add new column “allow_account_creation_against_child_company” as check datatype into company table in setup - customize form.

1 Like

Hi @edward_lee

Thank you so much!

Kind regards,