Forum GLPI-Project

moisesdasilvadeoliveira

Member

Registered: 2018-08-17

Posts: 7

Error linking Knowledge Base to a task

Hello!!

To be linked in the knowledge of the knowledge of the GLPI system, the same does not run your user interface with user super-admin. Give a list of the knowledge base is displayed and possible linked to a task.

Has anyone had this problem and can I help with a solution?

Version: GLPI 9.3.0

Last edited by moisesdasilvadeoliveira (2018-08-20 20:38:09)

moisesdasilvadeoliveira

Member

Registered: 2018-08-17

Posts: 7

Re: Error linking Knowledge Base to a task

Error Log DB:

glpisqllog.ERROR: DBmysql::query() in /var/www/glpi/glpi-9.3.0/inc/dbmysql.class.php line 180
  *** MySQL query error:
  SQL: SELECT `glpi_knowbaseitems`.*
                        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_projectteams`
                     ON (`glpi_projectteams`.`projects_id` = `glpi_projects`.`id`)
                        WHERE 1  AND (`glpi_knowbaseitems`.`users_id` = '323'  OR `glpi_knowbaseitems_users`.`users_id` = '323'  OR (`glpi_groups_knowbaseitems`.`groups_id`                                     IN ('581','635','638')                                AND (`glpi_groups_knowbaseitems`.`entities_id` < 0                                     OR (  1 ) ))  OR (`glpi_knowbaseitems_profiles`.`profiles_id`                                     = '6'                                AND (`glpi_knowbaseitems_profiles`.`entities_id` < 0                                     OR (  1 ) )) OR ( `glpi_entities_knowbaseitems`.`entities_id` IN ('0', '15', '13', '12', '11', '2', '6', '14')  ) )  AND (`glpi_projects`.users_id = '323'
                               OR (`glpi_projectteams`.`itemtype` = 'User'
                                   AND `glpi_projectteams`.`items_id` = '323') OR (`glpi_projects`.`groups_id`
                                       IN (581,635,638)) OR (`glpi_projectteams`.`itemtype` = 'Group'
                                      AND `glpi_projectteams`.`items_id`
                                          IN (581,635,638)))  ORDER BY `glpi_knowbaseitems`.`name`
                     LIMIT 0,100
  Error: Unknown column 'glpi_projects.users_id' in 'where clause'
  Backtrace :
  inc/dropdown.class.php:2724                       
  ajax/getDropdownValue.php:47                       Dropdown::getDropdownValue()
  {"user":"323@php01","mem_usage":"0.009\", 1.37Mio)"}