Local fresh installation and Error 1054

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"


Form/Sales Order/new-sales-order-2


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
  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
  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
  File "env/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
  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'\")"

Hi @fl0,

PR is merged in Develop and Version-14 hotfix.

So upcoming update will solve your issue.

Thank You!

Thank you very much for the feedback. Will wait for the update.

Is there a target date please ? Thanks.

Hi @fl0,

A new update was released 19 min ago.

So please upgrade or update it and check it.

All updates are released weekly.

Thank You!

Thank you so much for prompt reply and support.

I’m a newbie and has just started to explore ERPNext and got the error while I tried to create some dummy data to better understand how the platform works and workflow in general.

Waiting for the update to resume to explore.