In the global search box, Users can search for existing doctypes and select them from the dropdown without issue. However, if they just type a string (e.g. ‘test’) and hit enter, the following error is thrown…
pymysql.err.ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank\n\t\t\t\tFROM
doctype IN (‘Customer’,‘Supplier’,‘I’ at line 1”)
I’ve tried the ‘Reset’ button in Global Search Settings but that didn’t help. I seem to recall seeing somewhere that Global Search depends upon a mysql/mariadb feature being enabled but I can’t find reference to that now. This issue is happening consistently across multiple sites in a helm deployment.
Thanks in advance for any insight.