When i open the doctype at that i am facing the error as shown below even after my table in database don’t have the common name file
Which version are you using? it shoud be tabSupplier only.
can you send a console error traceback so anyone can help?
@Suresh_Thakor Below is the error log showing when it appear
App Versions
{
"frappe": "14.33.1",
"samarthjewellery": "1.0.2",
"samcore": "0.0.1"
}
Route
List/Parcel Issue/List
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 1607, in call
return fn(*args, **newargs)
File "apps/frappe/frappe/__init__.py", line 789, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File "apps/frappe/frappe/desk/reportview.py", line 29, in get
data = compress(execute(**args), args=args)
File "apps/frappe/frappe/desk/reportview.py", line 65, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File "apps/frappe/frappe/model/db_query.py", line 202, in execute
result = self.build_and_run()
File "apps/frappe/frappe/model/db_query.py", line 242, in build_and_run
return frappe.db.sql(
File "apps/frappe/frappe/database/database.py", line 219, 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: (1066, "Not unique table/alias: 'tabSupplier Master'")
Request Data
{
"type": "POST",
"args": {
"doctype": "Parcel Issue",
"fields": "[\"`tabParcel Issue`.`name`\",\"`tabParcel Issue`.`owner`\",\"`tabParcel Issue`.`creation`\",\"`tabParcel Issue`.`modified`\",\"`tabParcel Issue`.`modified_by`\",\"`tabParcel Issue`.`_user_tags`\",\"`tabParcel Issue`.`_comments`\",\"`tabParcel Issue`.`_assign`\",\"`tabParcel Issue`.`_liked_by`\",\"`tabParcel Issue`.`docstatus`\",\"`tabParcel Issue`.`idx`\",\"`tabParcel Issue`.`issue_date`\",\"`tabParcel Issue`.`sendercode`\",\"`tabParcel Issue`.`from`\",\"`tabParcel Issue`.`to`\",\"from.supplier_name as from_supplier_name\",\"to.supplier_name as to_supplier_name\"]",
"filters": "[[\"Parcel Issue\",\"sendercode\",\"=\",19523]]",
"order_by": "`tabParcel Issue`.`modified` desc",
"start": 0,
"page_length": 20,
"view": "List",
"group_by": "`tabParcel Issue`.`name`",
"with_comment_count": true
},
"freeze": false,
"freeze_message": "Loading...",
"headers": {},
"error_handlers": {},
"url": "/api/method/frappe.desk.reportview.get"
}
Response Data
{
"exception": "pymysql.err.OperationalError: (1066, \"Not unique table/alias: 'tabSupplier Master'\")"
}
is your SupplierMaster table properly joined with the tabIssue table?
Check SupplierMaster Doctype Link field in Parcel Issue Doctype.
Here is the solution.