Hi, I’m a newbie and trying to figure out if erpnext is something useful for few cases.
I’ve just installed erpnext into a fresch copy of ubuntu 22.04 by following frappe’s guide successfully.
Now i’m trying to figure out how all works so creating items, customers, etc. with some data to see how all shapes up.
However when i try to create a new sales order no matter what I do I’m getting this error:
pymysql.err.OperationalError: (1054, “Unknown column ‘c.is_billing_contact’ in ‘field list’”)
Error log is also below. Any one can help me ?
App Versions
{
"ecommerce_integrations": "1.17.1",
"erpnext": "14.27.0",
"frappe": "14.38.0",
"hrms": "15.0.0-dev"
}
Route
Form/Sales Order/new-sales-order-2
Traceback
Traceback (most recent call last):
File "apps/frappe/frappe/app.py", line 66, in application
response = frappe.api.handle()
File "apps/frappe/frappe/api.py", line 54, in handle
return frappe.handler.handle()
File "apps/frappe/frappe/handler.py", line 45, in handle
data = execute_cmd(cmd)
File "apps/frappe/frappe/handler.py", line 83, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File "apps/frappe/frappe/__init__.py", line 1608, in call
return fn(*args, **newargs)
File "apps/erpnext/erpnext/accounts/party.py", line 73, in get_party_details
return _get_party_details(
File "apps/erpnext/erpnext/accounts/party.py", line 133, in _get_party_details
set_contact_details(party_details, party, party_type)
File "apps/erpnext/erpnext/accounts/party.py", line 275, in set_contact_details
party_details.contact_person = get_default_contact(party_type, party.name)
File "apps/erpnext/erpnext/accounts/party.py", line 918, in get_default_contact
out = frappe.db.sql(
File "apps/frappe/frappe/database/database.py", line 221, in sql
self._cursor.execute(query, values)
File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read
first_packet = self.connection._read_packet()
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "env/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "env/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'c.is_billing_contact' in 'field list'")
Request Data
{
"type": "POST",
"args": {
"party": "Ayşe Sayın",
"party_type": "Customer",
"price_list": "Standard Selling",
"posting_date": "2023-06-13",
"fetch_payment_terms_template": 1,
"currency": "TRY",
"company": "C Printing",
"doctype": "Sales Order"
},
"headers": {},
"error_handlers": {},
"url": "/api/method/erpnext.accounts.party.get_party_details"
}
Response Data
{
"exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'c.is_billing_contact' in 'field list'\")"
}