kietmak
February 6, 2018, 11:37am
1
Hi,
I am testing the Healthcare module in ERPNext. In Healthcare >> Patient Appointment form I got the below error while booking & view Appointment record.
ERPNext: v9.x.x-develop (9893a2d) (develop)
Frappe Framework: v9.x.x-develop (ae6fa0b) (develop)
OperationalError: (1054, “Unknown column ‘tabSales Invoice.appointment’ in ‘where clause’”)
Thanks
– Ashfaq
Hi,
Your database is missing the appointment column in the table tabSales Invoice. You can add it by using custom field and add the field.
shelteradmin:
tabSales
Thanks for you feedback.
Please let me know, should I add ‘appointment’ filed and tabSales table directly in mariaDB or It can be add thru DocType?
If using DocType, kindly mention the name.
Regards,
–Ashfaq
Try executing this command from your frappe-bench folder
bench --site sitename migrate
Not working after this command:
bench --site sitename migrate
Regards,
–Ashfaq
kietmak
February 7, 2018, 11:47am
6
How can I determine the data type of tabSales Invoice.appointment, if I add it by Customize Form?
regards,
–Ashfaq
Add by custom field like this