Try ERPNext Buy Support Partners Foundation

Bug in general ledger report

We are started getting new errors in general ledger report after Installing latest version.
ERPNext: v12.6.0 (version-12)
Frappe Framework: v12.4.1 (version-12)

Server Error

Close Report

error Msg as under
pymysql.err.ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘‘AURANGABAD’\n\t\torder by posting_date, account, creation’ at line 9”)

however older version in test server runs properly no such error and report coming properly. Installed Apps

ERPNext: v12.5.0 (version-12)

Frappe Framework: v12.3.0 (version-12)

1 Like

If using a Debian or Ubuntu host can you post the output , from a terminal: apt-cache policy mariadb-server ?

1 Like

Try updating mariadb-server to the candidate and see if it helps:

sudo apt install mariadb-server , then bench restart

1 Like

Hi thank you for solution
but it gives me the same error

pymysql.err.ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘‘AURANGABAD’\n\t\torder by posting_date, account, creation’ at line 8”)

When you installed the latest version did you update an existing ERPNext or restore a backup from the older server to a fresh instance?

Has bench migrate or bench update --reset been tried?

bench update --reset tried