Course Schedule Calendar Error

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”)

1 Like

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’”)

1 Like

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

1 Like

Thanks for reporting an error, I’ve created github issue for the same and soon we’ll fix the issue

1 Like