Query error searching on KB
Closed this issue · 0 comments
trasher commented
Trying to search '*' or '%' in KB results on a query error:
[2025-09-19 05:42:39] glpi.CRITICAL: *** Uncaught PHP Exception RuntimeException: "MySQL query error: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*' (1064) in SQL query "SELECT COUNT(*) AS cpt FROM `glpi_knowbaseitems` LEFT JOIN `glpi_knowbaseitems_users` ON (`glpi_knowbaseitems_users`.`knowbaseitems_id` = `glpi_knowbaseitems`.`id`) LEFT JOIN `glpi_groups_knowbaseitems` ON (`glpi_groups_knowbaseitems`.`knowbaseitems_id` = `glpi_knowbaseitems`.`id`) LEFT JOIN `glpi_knowbaseitems_profiles` ON (`glpi_knowbaseitems_profiles`.`knowbaseitems_id` = `glpi_knowbaseitems`.`id`) LEFT JOIN `glpi_entities_knowbaseitems` ON (`glpi_entities_knowbaseitems`.`knowbaseitems_id` = `glpi_knowbaseitems`.`id`) LEFT JOIN `glpi_knowbaseitems_knowbaseitemcategories` ON (`glpi_knowbaseitems_knowbaseitemcategories`.`knowbaseitems_id` = `glpi_knowbaseitems`.`id`) WHERE 1 AND ((MATCH(`glpi_knowbaseitems`.`name`,
`glpi_knowbaseitems`.`answer`)
AGAINST('*' IN BOOLEAN MODE))) AND ((((`glpi_knowbaseitems`.`begin_date` IS NULL) OR (`glpi_knowbaseitems`.`begin_date` < NOW()))) AND (((`glpi_knowbaseitems`.`end_date` IS NULL) OR (`glpi_knowbaseitems`.`end_date` > NOW()))))"." at DBmysql.php line 381
Backtrace :
./src/DBmysql.php:381
./src/DBmysqlIterator.php:123 DBmysql->doQuery()
./src/DBmysql.php:1050 DBmysqlIterator->execute()
./src/KnowbaseItem.php:1217 DBmysql->request()
./src/KnowbaseItem.php:1389 KnowbaseItem::getListRequest()
./src/Knowbase.php:116 KnowbaseItem::showList()
./src/Knowbase.php:74 Knowbase::showSearchView()
./src/CommonGLPI.php:694 Knowbase::displayTabContentForItem()
./ajax/common.tabs.php:108 CommonGLPI::displayStandardTab()
...Glpi/Controller/LegacyFileLoadController.php:63 require()
./vendor/symfony/http-kernel/HttpKernel.php:181 Glpi\Controller\LegacyFileLoadController->__invoke()
./vendor/symfony/http-kernel/HttpKernel.php:76 Symfony\Component\HttpKernel\HttpKernel->handleRaw()
./vendor/symfony/http-kernel/Kernel.php:197 Symfony\Component\HttpKernel\HttpKernel->handle()
./public/index.php:70 Symfony\Component\HttpKernel\Kernel->handle()