Updated to 7.2.29 from 7.2.21, Delivery Note list error

Install / Update
1

Hello Team,
I went for update today (development branch), the update is going smooth. but when I try to open Delivery Note list, something went wrong:

Traceback (most recent call last): File "/home/argatech/Erpnext/frappe-bench/apps/frappe/frappe/app.py", line 56, in application response = frappe.handler.handle() File "/home/argatech/Erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 19, in handle execute_cmd(cmd) File "/home/argatech/Erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 42, in execute_cmd ret = frappe.call(method, **frappe.form_dict) File "/home/argatech/Erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 904, in call return fn(*args, **newargs) File "/home/argatech/Erpnext/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 203, in get_sidebar_stats return {"defined_cat":cat_tags, "stats":get_stats(stats, doctype, filters)} File "/home/argatech/Erpnext/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 219, in get_stats filters = filters + ["ifnull(`%s`,'')!=''" % tag], group_by = tag, as_list = True) File "/home/argatech/Erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 1109, in get_list return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs) File "/home/argatech/Erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py", line 83, in execute result = self.build_and_run() File "/home/argatech/Erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py", line 107, in build_and_run return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update) File "/home/argatech/Erpnext/frappe-bench/apps/frappe/frappe/database.py", line 149, in sql self._cursor.execute(query) File "/home/argatech/Erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/home/argatech/Erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, 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 '*) from `tabDelivery Note` left join `tabDelivery Note Item` on (`tabDelivery No' at line 1")

thanks in advance

2

I get something very similar, but on the lookup of a payment entry from sales or purchase invoice.

Traceback (most recent call last):
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/app.py", line 56, in application
    response = frappe.handler.handle()
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/handler.py", line 19, in handle
    execute_cmd(cmd)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/handler.py", line 42, in execute_cmd
    ret = frappe.call(method, **frappe.form_dict)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/__init__.py", line 904, in call
    return fn(*args, **newargs)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/desk/reportview.py", line 203, in get_sidebar_stats
    return {"defined_cat":cat_tags, "stats":get_stats(stats, doctype, filters)}
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/desk/reportview.py", line 219, in get_stats
    filters = filters + ["ifnull(`%s`,'')!=''" % tag], group_by = tag, as_list = True)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/__init__.py", line 1109, in get_list
    return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/model/db_query.py", line 83, in execute
    result = self.build_and_run()
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/model/db_query.py", line 107, in build_and_run
    return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/database.py", line 149, in sql
    self._cursor.execute(query)
  File "/home/erpnext/erpnext-dev/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/erpnext/erpnext-dev/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, 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 '*) from `tabPayment Entry` left join `tabPayment Entry Reference` on (`tabPaymen' at line 1")
3

Here is another one when I try and lookup open purchase orders

Traceback (most recent call last):
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/app.py", line 56, in application
    response = frappe.handler.handle()
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/handler.py", line 19, in handle
    execute_cmd(cmd)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/handler.py", line 42, in execute_cmd
    ret = frappe.call(method, **frappe.form_dict)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/__init__.py", line 904, in call
    return fn(*args, **newargs)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/desk/reportview.py", line 203, in get_sidebar_stats
    return {"defined_cat":cat_tags, "stats":get_stats(stats, doctype, filters)}
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/desk/reportview.py", line 219, in get_stats
    filters = filters + ["ifnull(`%s`,'')!=''" % tag], group_by = tag, as_list = True)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/__init__.py", line 1109, in get_list
    return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/model/db_query.py", line 83, in execute
    result = self.build_and_run()
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/model/db_query.py", line 107, in build_and_run
    return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
  File "/home/erpnext/erpnext-dev/apps/frappe/frappe/database.py", line 149, in sql
    self._cursor.execute(query)
  File "/home/erpnext/erpnext-dev/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/erpnext/erpnext-dev/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, 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 '*) from `tabPurchase Order` left join `tabPurchase Order Item` on (`tabPurchase ' at line 1")
4

Sorted it out, today I’m updating using

bench update.
then manually do: > bench --site mysite.local migrate

puff, all error above is gone