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 ') ORDER BY FIELD(lInventoryID,)' at line 1 in C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Database\Database.php:95
Stack trace:
#0 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Database\Database.php(95): mysqli->query('SELECT tblInven...')
#1 C:\common\isaac\isaaclive\isaac_php\isaac.php(200): QWSI\Isaac\Database\Database->query('SELECT tblInven...', false, false)
#2 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Query.php(330): db_query('SELECT tblInven...')
#3 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Store\Search.php(569): QWSI\Isaac\Query->execute('SELECT tblInven...')
#4 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Store\Search.php(509): QWSI\Isaac\Store\Search->processSphinxResults(Object(Foolz\SphinxQL\Drivers\ResultSet))
#5 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Store\Search.php(175): QWSI\Isaac\Store\Search->p_executeSphinx()
#6 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Store\Browse.php(187): QWSI\Isaac\Store\Search->execute()
#7 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Store\Browse.php(1057): QWSI\Isaac\Store\Browse->p_executeSearch('toner')
#8 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Store\Browse.php(965): QWSI\Isaac\Store\Browse->generateSearchPage()
#9 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Store\Browse.php(193): QWSI\Isaac\Store\Browse->p_showSearch()
#10 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Store\Item.php(849): QWSI\Isaac\Store\Browse->execute()
#11 C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Store\Item.php(665): QWSI\Isaac\Store\Item->displaySearch()
#12 C:\common\isaac\isaaclive\isaacstore\item.php(7): QWSI\Isaac\Store\Item->execute()
#13 {main}
thrown in C:\common\isaac\isaaclive\isaac_php\class\QWSI\Isaac\Database\Database.php on line 95