Good morning,
I am creating a custom app for ERPNext. On my development computer I created a query report and saved it to my module. I have not modified the generated json. I committed my changes. Then, on my live server, I pulled my changes and ran “bench migrate”. The report appears, but gives the following error when I try to load it (error is in the console):
Uncaught SyntaxError: Unexpected identifier
at Object._eval [as eval] (desk.min.js?ver=1521545506.0:518)
at Object.callback (report.min.js?ver=1521545506.0:1020)
at Object.callback [as success_callback] (desk.min.js?ver=1521545506.0:1437)
at _ (desk.min.js?ver=1521545506.0:1461)
at Object. (desk.min.js?ver=1521545506.0:1562)
at i (jquery.min.js:2)
at Object.fireWith [as resolveWith] (jquery.min.js:2)
at z (jquery.min.js:4)
at XMLHttpRequest. (jquery.min.js:4)report.min.js?ver=1521545506.0:1025 Uncaught TypeError: Cannot set property ‘html_format’ of undefined
at report.min.js?ver=1521545506.0:1025
at desk.min.js?ver=1521545506.0:1692
at Function. (desk.min.js?ver=1521545506.0:1760)
at Function.each (jquery.min.js:2)
at HTMLDocument. (desk.min.js?ver=1521545506.0:1759)
at HTMLDocument.dispatch (jquery.min.js:3)
at HTMLDocument.$event.dispatch (report.min.js?ver=1521545506.0:3020)
at HTMLDocument.r.handle (jquery.min.js:3)
at Object.trigger (jquery.min.js:4)
at z (jquery.min.js:4)
Here is my report json:
{
“add_total_row”: 0,
“apply_user_permissions”: 1,
“creation”: “2018-03-20 15:49:56.539757”,
“disabled”: 0,
“docstatus”: 0,
“doctype”: “Report”,
“idx”: 0,
“is_standard”: “Yes”,
“modified”: “2018-03-20 16:08:12.831588”,
“modified_by”: “Administrator”,
“module”: “Healthcare CheckIn”,
“name”: “Today’s Appointments”,
“owner”: “Administrator”,
“query”: “Select a.appointment_time,a.physician,p.patient_name,a.status,a.arrived from tabPatient Appointment as a, tabPatient as p where a.patient = p.name AND DATE(a.appointment_date) = CURDATE() AND a.status != ‘Cancelled’ ORDER BY a.appointment_date ASC, a.appointment_time ASC”,
“ref_doctype”: “Patient Appointment”,
“report_name”: “Today’s Appointments”,
“report_type”: “Query Report”,
“roles”: [
{
“role”: “Healthcare Administrator”
},
{
“role”: “Physician”
}
]
}
The report works fine on my development computer where I created it. On the live server, it fails to load data and prints the above error to console. If I click “Refresh” I get data, but it prints out the error again.
Any tips would be great.
Thanks!
Daniel