Accounts dashboard broken after an upgrade

cephas_kamuchira · January 2, 2021, 4:37am

Hi there

Please assist,

After updating my site, I am seeing that the accounts dashboard is now broken.
Please see the attached screenshot?
---------------------------------------------------

Here is my current version:

Installed Apps

Booking Service App: v0.0.1 (master)

ERPNext: v12.16.2 (version-12)

Frappe Framework: v12.13.0 (version-12)

smino · January 1, 2021, 10:50pm

Hi,

Is this the first time that an update has been tried or has it been updated successfully before this??

Were there any messages in the console where the update command was issued?

cephas_kamuchira · January 2, 2021, 3:23am

Hi there

Yes, this is the 1st time i update.

The update went through successfully and no errors at all.

Any suggestions?

smino · January 2, 2021, 3:16pm

Is ERPNext being run in Develop or Production mode?

I might try bench update --reset

cephas_kamuchira · January 2, 2021, 4:59pm

Hi

Thanks for getting back to me.

It’s running in production mode.

Muzzy · January 2, 2021, 5:20pm

Seems the issue is here on line 52. Some residual code I think.

github.com

frappe/frappe/blob/version-12/frappe/core/page/dashboard/dashboard.py#L52


			frappe.throw(_('Please check the filter values set for Dashboard Chart: {}').format(
				get_link_to_form(chart.doctype, chart.name)), title=_('Invalid Filter Value'))
			return
		else:
			raise


	frappe.cache().set_value(cache_key, json.dumps(results, default=str))
	frappe.db.set_value("Dashboard Chart", chart_name, "last_synced_on", frappe.utils.now(), update_modified = False)
	return results


def get_from_date_from_timespan(to_date, timespan):
	days = months = years = 0
	if "Last Week" == timespan:
		days = -7
	if "Last Month" == timespan:
		months = -1
	elif "Last Quarter" == timespan:
		months = -3
	elif "Last Year" == timespan:
		years = -1
	return add_to_date(to_date, years=years, months=months, days=days,

cephas_kamuchira · January 3, 2021, 7:47am

Hi there,

Thank you for the feedback on this @Muzzy, I do appreciate it.
Anyone know which codes within "Line52 "need to be removed or how do we fix this problem?

cephas_kamuchira · January 3, 2021, 3:18pm

Hi all,

Just to update everyone here,
The issue is really a pain, its sad that I have just done a fresh install as shown on the below image, trying to see if the issue can go away and here we go again… as shown on the image…and on a fresh install and on a fresh Debian10 system.
This simply means anyone who will install or recently installed ERPNEXT will have this issue whereby the dashboard accounting charts are broken such as Bank Balance, Expenses and Income.

Errors: “The resource you are looking for is not available”