V12 pymysql.err.InternalError: (1054, "Unknown column 'gst_category' in 'field list'")

Mine is fresh set up(ErpnextVersion 12).In sales order while selecting customer it shows this error message (pymysql.err.InternalError: (1054, “Unknown column ‘gst_category’ in ‘field list’”)

i had set country in price list as per this solution(pymysql.err.InternalError: (1054, "Unknown column 'gst_category' in 'field list'")).

still i am facing the same issue

Few things to help you debug this issue

  1. Check if there is a field called “gst_category” on Sales Order Doctype or Customer Doctype
  2. Check if there is any custom field that is named as “gst_category”
  3. Go to Settings>Company> Your Company and Change Country to any country other than India temporarily and then change back to India. This will apply changes required for GST if it has been missed during the installation
  4. If nothing works, post a full traceback from Browser Console so that someone from the Community can help
3 Likes

Thanks @Manan_Shah. It worked for me.

1 Like

Not working for me. Can someone suggest any other solution?