Custom HTML block

ERPNext
, ,
#1

Hi, I faced this error when add custom HTML block on the workspace

AttributeError: type object ‘MariaDB’ has no attribute ‘get_query’

@frappe.whitelist()
def get_custom_blocks_for_user(doctype, txt, searchfield, start, page_len, filters):
	# return logged in users private blocks and all public blocks
	customHTMLBlock = DocType("Custom HTML Block")

	condition_query = frappe.qb.get_query(customHTMLBlock)

	return (
		condition_query.select(customHTMLBlock.name).where(
			(customHTMLBlock.private == 0)
			| ((customHTMLBlock.owner == frappe.session.user) & (customHTMLBlock.private == 1))
		)
	).run()

the error in above code in path apps/frappe/frappe/desk/doctype/custom_html_block/custom_html_block.py

#2

I found the solution,

Changing line 18 in custom_html_block.py fixed the issue for me. Change get_query to from_

* condition_query = frappe.qb.get_query(customHTMLBlock)

* condition_query = frappe.qb.from_(customHTMLBlock)