Getting this error pymysql.err.OperationalError: (1728, 'Cannot load from mysql.proc. The table is probably corrupted')

test = frappe.db.sql(“”“SELECT JSON_ARRAYAGG(customer_gstin),JSON_ARRAYAGG(name)
FROM tabSales Invoice “””, as_dict=1)

Hi,

Perhaps see if the table is corrupted:

https://mariadb.com/kb/en/repairing-mariadb-tables-for-sql-server-users/

1 Like