Hi,
This is a bug for sure
Traceback (most recent call last):
File “/home/helio/frappe-bench/apps/frappe/frappe/app.py”, line 56, in application
response = frappe.handler.handle()
File “/home/helio/frappe-bench/apps/frappe/frappe/handler.py”, line 21, in handle
data = execute_cmd(cmd)
File “/home/helio/frappe-bench/apps/frappe/frappe/handler.py”, line 52, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/helio/frappe-bench/apps/frappe/frappe/init.py”, line 922, in call
return fn(*args, **newargs)
File “/home/helio/frappe-bench/apps/erpnext/erpnext/schools/api.py”, line 190, in get_course_schedule_events
}, as_dict=True, update={“allDay”: 0})
File “/home/helio/frappe-bench/apps/frappe/frappe/database.py”, line 142, in sql
self._cursor.execute(query, values)
File “/home/helio/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 250, in execute
self.errorhandler(self, exc, value)
File “/home/helio/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 50, in defaulterrorhandler
raise errorvalue
ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘’ at line 7”)
Same applies when you click on Gantt
Traceback (most recent call last):
File “/home/helio/frappe-bench/apps/frappe/frappe/app.py”, line 56, in application
response = frappe.handler.handle()
File “/home/helio/frappe-bench/apps/frappe/frappe/handler.py”, line 21, in handle
data = execute_cmd(cmd)
File “/home/helio/frappe-bench/apps/frappe/frappe/handler.py”, line 52, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/helio/frappe-bench/apps/frappe/frappe/init.py”, line 922, in call
return fn(*args, **newargs)
File “/home/helio/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 18, in get
data = compress(execute(**args), args = args)
File “/home/helio/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 23, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File “/home/helio/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 88, in execute
result = self.build_and_run()
File “/home/helio/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 112, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File “/home/helio/frappe-bench/apps/frappe/frappe/database.py”, line 153, in sql
self._cursor.execute(query)
File “/home/helio/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 250, in execute
self.errorhandler(self, exc, value)
File “/home/helio/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 50, in defaulterrorhandler
raise errorvalue
OperationalError: (1054, “Unknown column ‘tabCourse Schedule.from_datetime’ in ‘order clause’”)
Hi @Helio_Jesus
We have fixed this issue in hotfix branch and soon we’ll release it into the master branch
https://github.com/frappe/frappe/pull/3737
Thanks for reporting an error, I’ve created github issue for the same and soon we’ll fix the issue
https://github.com/frappe/erpnext/issues/9977