Local fresh installation and Error 1054

ERPNext
,
1

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'\")"
}
2

Hi @fl0,

PR is merged in Develop and Version-14 hotfix.

So upcoming update will solve your issue.

Thank You!

3

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

4

Is there a target date please ? Thanks.

5

Hi @fl0,

A new update was released 19 min ago.

image
image1818×905 146 KB

So please upgrade or update it and check it.

All updates are released weekly.

Thank You!

6

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.

7

Hey.
I am getting lot of this errors.
I dont know why.
I had installed an app erpnext_mxt and it kept on giving me errors on majorly custom fields dont know why?
I have proper custom_field.json with 34000 lines as much in github also i had migrated but the only solution working for me is that keep on making new fields based on those error in that doctype.

What i thought that the person with github repo shared me his app but the fields he made like custom_room and all in a standard doctype(erpnext) wont show in the custom app(erpnext_mxt) and that he will also need to share the erpnext app right ?
Or when i migrate the local app the custom_field.json automatically makes the changes in the doctype?

Errors:
Opportunity

Server Error
pymysql.err.OperationalError: (1054, “Unknown column ‘tabSales Partner.custom_name’ in ‘SELECT’”)

Server Error
AttributeError: ‘Customer’ object has no attribute ‘custom_sales_person’
Possible source of error: erpnext_mxt (app)

Quotation:
Message
Field custom_room not found.

Server Error
pymysql.err.OperationalError: (1054, “Unknown column ‘custom_default_discount_percentage’ in ‘SELECT’”)
Possible source of error: erpnext_mxt (app)

Sales order:

Message
Field custom_total_no_of_boxes not found.

Purchase Order:

Message
Field custom_total_no_of_boxes not found.