Dear All,
Im getting a select error as per below error log, please check and adivse.
Traceback with variables (most recent call last):
File "apps/frappe/frappe/app.py", line 115, in application
response = frappe.api.handle(request)
request = <Request 'https://alomda.frappe.cloud/api/method/frappe.desk.search.get_link_title' [POST]>
response = None
rollback = True
e = OperationalError(1054, "Unknown column '' in 'SELECT'")
File "apps/frappe/frappe/api/__init__.py", line 50, in handle
data = endpoint(**arguments)
request = <Request 'https://alomda.frappe.cloud/api/method/frappe.desk.search.get_link_title' [POST]>
endpoint = <function handle_rpc_call at 0x7f2b5d0a5bc0>
arguments = {'method': 'frappe.desk.search.get_link_title'}
File "apps/frappe/frappe/api/v1.py", line 36, in handle_rpc_call
return frappe.handler.handle()
method = 'frappe.desk.search.get_link_title'
frappe = <module 'frappe' from 'apps/frappe/frappe/__init__.py'>
File "apps/frappe/frappe/handler.py", line 52, in handle
data = execute_cmd(cmd)
cmd = 'frappe.desk.search.get_link_title'
data = None
File "apps/frappe/frappe/handler.py", line 85, in execute_cmd
return frappe.call(method, **frappe.form_dict)
cmd = 'frappe.desk.search.get_link_title'
from_async = False
server_script = None
method = <function get_link_title at 0x7f2b58528400>
File "apps/frappe/frappe/__init__.py", line 1754, in call
return fn(*args, **newargs)
fn = <function get_link_title at 0x7f2b58528400>
args = ()
kwargs = {'doctype': 'Project', 'docname': 'JOB-1226', 'cmd': 'frappe.desk.search.get_link_title'}
newargs = {'doctype': 'Project', 'docname': 'JOB-1226'}
File "apps/frappe/frappe/utils/typing_validations.py", line 32, in wrapper
return func(*args, **kwargs)
args = ()
kwargs = {'doctype': 'Project', 'docname': 'JOB-1226'}
apply_condition = <function whitelist.<locals>.innerfn.<locals>.<lambda> at 0x7f2b58528360>
func = <function get_link_title at 0x7f2b585282c0>
File "apps/frappe/frappe/desk/search.py", line 332, in get_link_title
return frappe.db.get_value(doctype, docname, meta.title_field)
doctype = 'Project'
docname = 'JOB-1226'
meta = <Meta: Project>
File "apps/frappe/frappe/database/database.py", line 514, in get_value
result = self.get_values(
self = <frappe.database.mariadb.database.MariaDBDatabase object at 0x7f2b591987d0>
doctype = 'Project'
filters = 'JOB-1226'
fieldname = ''
ignore = None
as_dict = False
debug = False
order_by = 'KEEP_DEFAULT_ORDERING'
cache = False
for_update = False
run = True
pluck = False
distinct = False
skip_locked = False
wait = True
File "apps/frappe/frappe/database/database.py", line 618, in get_values
out = self._get_values_from_table(
self = <frappe.database.mariadb.database.MariaDBDatabase object at 0x7f2b591987d0>
doctype = 'Project'
filters = 'JOB-1226'
fieldname = ''
ignore = None
as_dict = False
debug = False
order_by = 'modified'
update = None
cache = False
for_update = False
run = True
pluck = False
distinct = False
limit = 1
skip_locked = False
wait = True
out = None
fields = ['']
File "apps/frappe/frappe/database/database.py", line 891, in _get_values_from_table
return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck)
self = <frappe.database.mariadb.database.MariaDBDatabase object at 0x7f2b591987d0>
fields = ['']
filters = 'JOB-1226'
doctype = 'Project'
as_dict = False
debug = False
order_by = 'modified'
update = None
for_update = False
skip_locked = False
wait = True
run = True
pluck = False
distinct = False
limit = 1
query = SELECT `` FROM `tabProject` WHERE `name`='JOB-1226' ORDER BY `modified` DESC LIMIT 1
File "apps/frappe/frappe/query_builder/utils.py", line 87, in execute_query
result = frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
query = 'SELECT `` FROM `tabProject` WHERE `name`=%(param1)s ORDER BY `modified` DESC LIMIT 1'
args = ()
kwargs = {'as_dict': False, 'debug': False, 'update': None, 'run': True, 'pluck': False}
child_queries = []
params = {'param1': 'JOB-1226'}
execute_child_queries = <function patch_query_execute.<locals>.execute_child_queries at 0x7f2b5a4e1940>
prepare_query = <function patch_query_execute.<locals>.prepare_query at 0x7f2b5a4e19e0>
File "apps/frappe/frappe/database/database.py", line 230, in sql
self._cursor.execute(query, values)
self = <frappe.database.mariadb.database.MariaDBDatabase object at 0x7f2b591987d0>
query = 'SELECT `` FROM `tabProject` WHERE `name`=%(param1)s ORDER BY `modified` DESC LIMIT 1 /* FRAPPE_TRACE_ID: 0bc8809e-fa18-4109-bf63-e46ce019b3cb */'
values = {'param1': 'JOB-1226'}
as_dict = False
as_list = 0
debug = False
ignore_ddl = 0
auto_commit = 0
update = None
explain = False
run = True
pluck = False
as_iterator = False
trace_id = '0bc8809e-fa18-4109-bf63-e46ce019b3cb'
File "env/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in execute
result = self._query(query)
self = <pymysql.cursors.Cursor object at 0x7f2b590e0590>
query = "SELECT `` FROM `tabProject` WHERE `name`='JOB-1226' ORDER BY `modified` DESC LIMIT 1 /* FRAPPE_TRACE_ID: 0bc8809e-fa18-4109-bf63-e46ce019b3cb */"
args = {'param1': 'JOB-1226'}
File "env/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
self = <pymysql.cursors.Cursor object at 0x7f2b590e0590>
q = "SELECT `` FROM `tabProject` WHERE `name`='JOB-1226' ORDER BY `modified` DESC LIMIT 1 /* FRAPPE_TRACE_ID: 0bc8809e-fa18-4109-bf63-e46ce019b3cb */"
conn = <pymysql.connections.Connection object at 0x7f2b5839a3d0>
File "env/lib/python3.11/site-packages/pymysql/connections.py", line 563, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
self = <pymysql.connections.Connection object at 0x7f2b5839a3d0>
sql = b"SELECT `` FROM `tabProject` WHERE `name`='JOB-1226' ORDER BY `modified` DESC LIMIT 1 /* FRAPPE_TRACE_ID: 0bc8809e-fa18-4109-bf63-e46ce019b3cb */"
unbuffered = False
File "env/lib/python3.11/site-packages/pymysql/connections.py", line 825, in _read_query_result
result.read()
self = <pymysql.connections.Connection object at 0x7f2b5839a3d0>
unbuffered = False
result = <pymysql.connections.MySQLResult object at 0x7f2b590e1450>
File "env/lib/python3.11/site-packages/pymysql/connections.py", line 1199, in read
first_packet = self.connection._read_packet()
self = <pymysql.connections.MySQLResult object at 0x7f2b590e1450>
File "env/lib/python3.11/site-packages/pymysql/connections.py", line 775, in _read_packet
packet.raise_for_error()
self = <pymysql.connections.Connection object at 0x7f2b5839a3d0>
packet_type = <class 'pymysql.protocol.MysqlPacket'>
buff = bytearray(b"\xff\x1e\x04#42S22Unknown column \'\' in \'SELECT\'")
packet_header = b'&\x00\x00\x01'
btrl = 38
btrh = 0
packet_number = 1
bytes_to_read = 38
recv_data = b"\xff\x1e\x04#42S22Unknown column '' in 'SELECT'"
packet = <pymysql.protocol.MysqlPacket object at 0x7f2b5930f940>
File "env/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
self = <pymysql.protocol.MysqlPacket object at 0x7f2b5930f940>
errno = 1054
File "env/lib/python3.11/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
raise errorclass(errno, errval)
data = b"\xff\x1e\x04#42S22Unknown column '' in 'SELECT'"
errno = 1054
errval = "Unknown column '' in 'SELECT'"
errorclass = <class 'pymysql.err.OperationalError'>
pymysql.err.OperationalError: (1054, "Unknown column '' in 'SELECT'")