Forum GLPI-Project

bonpie

Member

From: Italy

Registered: 2015-04-13

Posts: 17

Search items on Knowledge Base doesn't work

Hi All,
I use GLPI 0.90.1 on Operating system: Linux debian 3.16.0.
We've recorded many Knoledge base items, but the search functions doesn't work, particulary doesn't return anything !

I've checked sql-errors.log and I've look at an error (this) :
Error: Unknown column 'glpi_knowbaseitemtranslations.name' in 'where clause'

The complete Query is this :

2016-02-23 10:26:56 [7@debian]
  *** MySQL query error:
  SQL: SELECT COUNT(`glpi_knowbaseitems`.`id`)
                             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`)
                             WHERE (`glpi_knowbaseitems_users`.`users_id` = \'7\'  OR `glpi_knowbaseitems_users`.`users_id` = \'7\'  OR (`glpi_groups_knowbaseitems`.`groups_id`
                                    IN (\'1\')
                               AND (`glpi_groups_knowbaseitems`.`entities_id` < 0
                                    OR (  1 ) ))  OR (`glpi_knowbaseitems_profiles`.`profiles_id`
                                    = \'4\'
                               AND (`glpi_knowbaseitems_profiles`.`entities_id` < 0
                                    OR (  1 ) )) OR ( `glpi_entities_knowbaseitems`.`entities_id` IN (\'0\')  ) )  AND MATCH(`glpi_knowbaseitems`.`name`,
                                             `glpi_knowbaseitems`.`answer` ,`glpi_knowbaseitemtranslations`.`name`,
                                 `glpi_knowbaseitemtranslations`.`answer`)
                          AGAINST(\'ateco\' 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())
  Error: Unknown column 'glpi_knowbaseitemtranslations.name' in 'where clause'
  Backtrace :
  inc/knowbaseitem.class.php:1120
  inc/knowbaseitem.class.php:1228                    KnowbaseItem::getListRequest()
  inc/knowbase.class.php:138                         KnowbaseItem::showList()
  inc/knowbase.class.php:87                          Knowbase::showSearchView()
  inc/commonglpi.class.php:469                       Knowbase::displayTabContentForItem()
  ajax/common.tabs.php:91                            CommonGLPI::displayStandardTab() 

Could you help me to understand ?
As is the KB Managemente is unusable !

Thanks in advance
Pietro

Last edited by bonpie (2016-02-25 09:59:39)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Search items on Knowledge Base doesn't work

Double with http://forum.glpi-project.org/viewtopic … 75#p310975
I close

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)