Hi All,
I am very new to ERPNext. Can you please help me?
I have created a trial license for the hosted version and am operating there.
I have created a production plan, an associated work order, an associated job card but when I go to start the job I am prompted to select an employee and when I do I get this server error:
pymysql.err.OperationalError: (1054, “Unknown column ‘jc.employee’ in ‘where clause’”)
What am I doing wrong? How do I fix this?
Thanks,
Jared
Here is some additional info:
{
“erpnext”: “13.6.0”,
“erpnext_support”: “0.0.3”,
“frappe”: “13.6.0”
}
Route
Form/Job Card/PO-JOB00009
Error Report
Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 68, in application
response = frappe.api.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/api.py”, line 55, in handle
return frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 31, in handle
data = execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 67, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1172, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/manufacturing/doctype/job_card/job_card.py”, line 532, in make_time_log
doc.add_time_log(args)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/manufacturing/doctype/job_card/job_card.py”, line 209, in add_time_log
self.save()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 285, in save
return self._save(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 320, in _save
self.run_before_save_methods()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 961, in run_before_save_methods
self.run_method(“validate”)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 859, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 1148, in composer
return composed(self, method, *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 1131, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 853, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/manufacturing/doctype/job_card/job_card.py”, line 25, in validate
self.validate_time_logs()
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/manufacturing/doctype/job_card/job_card.py”, line 50, in validate_time_logs
data = self.get_overlap_for(d)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/manufacturing/doctype/job_card/job_card.py”, line 100, in get_overlap_for
}, as_dict=True)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 146, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/cursors.py”, line 148, in execute
result = self._query(query)
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/cursors.py”, line 310, in _query
conn.query(q)
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 775, in _read_query_result
result.read()
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 1156, in read
first_packet = self.connection._read_packet()
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘jc.employee’ in ‘where clause’”)
Request Data
{
“type”: “POST”,
“args”: {
“args”: "{"job_card_id":"PO-JOB00009","start_time":"2021-07-15 16:37:11","employees
Can you raise a support ticket for it?
From your instance search for ERPNext Support Ticket and send a submission.
Just issued a bug report at github. I received this issue both on a frappe hosted site and my self hosted site. Thanks for the reply!
I am using latest version
erpnext 13.10.2
frappe 13.10.0
I also faced same issue,