First of all how do I disable automatic updates in Frappe Cloud?
Second, after an automatic update, If I attempt to open Tasks I get the following:
App Versions
{ "erpnext": "14.39.0", "frappe": "14.49.0" }
Route
List/Task/List
Traceback
Traceback (most recent call last): File "apps/frappe/frappe/app.py", line 95, 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 47, in handle data = execute_cmd(cmd) File "apps/frappe/frappe/handler.py", line 85, in execute_cmd return frappe.call(method, **frappe.form_dict) File "apps/frappe/frappe/__init__.py", line 1622, in call return fn(*args, **newargs) File "apps/frappe/frappe/__init__.py", line 802, 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 196, in execute result = self.build_and_run() File "apps/frappe/frappe/model/db_query.py", line 236, in build_and_run return frappe.db.sql( File "apps/frappe/frappe/database/database.py", line 220, 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: 'tabTask'")
Request Data
{ "type": "POST", "args": { "doctype": "Task", "fields": "[\"`tabTask`.`name`\",\"`tabTask`.`owner`\",\"`tabTask`.`creation`\",\"`tabTask`.`modified`\",\"`tabTask`.`modified_by`\",\"`tabTask`.`_user_tags`\",\"`tabTask`.`_comments`\",\"`tabTask`.`_assign`\",\"`tabTask`.`_liked_by`\",\"`tabTask`.`docstatus`\",\"`tabTask`.`idx`\",\"`tabTask`.`task_completed_by`\",\"`tabTask`.`subject`\",\"`tabTask`.`status`\",\"`tabTask`.`priority`\",\"`tabTask`.`parent_task`\",\"`tabTask`.`type`\",\"`tabTask`.`project`\",\"`tabTask`.`exp_start_date`\",\"`tabTask`.`exp_end_date`\",\"`tabTask`.`progress`\",\"`tabTask`.`depends_on_tasks`\",\"`tabTask`.`_seen`\",\"`tabTask`.`color`\",\"parent_task.type as parent_task_type\"]", "filters": "[]", "order_by": "`tabTask`.`modified` desc", "start": 0, "page_length": 20, "view": "List", "group_by": "`tabTask`.`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: 'tabTask'\")" }
Unfortunately, the latest backup is after the automatic update.
I believe this has happened after they introduced this:
* `Parent Task` link with `Project Task` (backport [#37025](#37025)) ([#37033](#37033)) ([6602787](6602787))
Any help is appreciated.