as soon as I start typing in the search bar of a customer list page, it result with error on top of the website. Error attached below, and the image shows the searchbar I tried to search for a name.
can anyone help me what is happening for this error?
Error:
Fatal error: Uncaught mysqli_sql_exception: 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 ') like upper('%ja%') ) ) ) ) ) a limit 0, 10' at line 3 in D:\WebServer\htdocs\newtriratna\output\connections\MySQLiConnection.php:157 Stack trace: #0 D:\WebServer\htdocs\newtriratna\output\connections\MySQLiConnection.php(157): mysqli_query(Object(mysqli), 'SELECT DISTINCT...') #1 D:\WebServer\htdocs\newtriratna\output\connections\dbfunctions\MySQLFunctions.php(130): MySQLiConnection->query('SELECT DISTINCT...') #2 D:\WebServer\htdocs\newtriratna\output\connections\Connection.php(608): MySQLFunctions->limitedQuery(Object(MySQLiConnection), 'SELECT DISTINCT...', 0, 10, true) #3 D:\WebServer\htdocs\newtriratna\output\classes\datasource\table.php(847): Connection->limitedQuery('SELECT DISTINCT...', 0, 10, true) #4 D:\WebServer\htdocs\newtriratna\output\include\commonfunctions.php(4055): DataSourceTable->getTotals(Object(DsCommand)) #5 D:\WebServer\htdocs\newtriratna\output\searchsuggest.php(180): getListOfSuggests(Array, 'customers', 10, 'Contains', 'ja', '', Array, Array) #6 {main} thrown in D:\WebServer\htdocs\newtriratna\output\connections\MySQLiConnection.php on line 157
