Chart of Account Show Error

Install / Update Setup
1

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’")

2

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

3

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

4

bench version
then
bench update

5

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

6

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

7

We Experience the exact same issue

8

tried but still same problem

9

i done manual way with this
https://github.com/gamaraan/erpnext/commit/3eeb1cacb0aef9716e0b32848c2b775b81e32f8b

then i remove company and create new company, fixed

10

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

11

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

Kind regards,

12

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

13

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
14

Hi @edward_lee

Thank you so much!

Kind regards,