General Balance Bug

Hello,

When I try to access general balance, I simply get this bug, with nothing in the screen :

Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 55, in application
    response = frappe.handler.handle()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 20, in handle
    data = execute_cmd(cmd)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 55, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1007, in call
    return fn(*args, **newargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 489, in wrapper_fn
    retval = fn(*args, **get_newargs(fn, kwargs))
  File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py", line 174, in run
    result = generate_report_result(report, filters, user)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py", line 65, in generate_report_result
    res = frappe.get_attr(method_name)(frappe._dict(filters))
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/trial_balance/trial_balance.py", line 15, in execute
    data = get_data(filters)
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/trial_balance/trial_balance.py", line 71, in get_data
    filters.to_date, min_lft, max_rgt, filters, gl_entries_by_account, ignore_closing_entries=not flt(filters.with_period_closing_entry))
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py", line 359, in set_gl_entries_by_account
    as_dict=True)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 117, in sql
    query = re.sub(r'ifnull\(', 'coalesce(', query, flags=re.IGNORECASE)
  File "/home/frappe/frappe-bench/env/lib/python2.7/re.py", line 155, in sub
    return _compile(pattern, flags).sub(repl, string, count)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 74: ordinal not in range(128)

Hi,

It has been corrected in the latest v11 beta version. Just update and you should be fine.

Have a nice evening!

Hi thank you,

How Can I update without loosing data ?

Thanks

Hi @Chaibi_Alaa,

This is just a report (a data display) so there should be no data loss linked to the report update itself.

If you do a simple bench update it should do the job.

Have a nice day,