Forum GLPI-Project

ec2311

Member

Registered: 2016-04-07

Posts: 309

Plugin DatabaseInventory : Unknown field plugin_databaseinventory_cred

Hello

SQL: SELECT `glpi_plugin_databaseinventory_credentialtypes`.`id`, `glpi_plugin_databaseinventory_credentialtypes`.`name` FROM `glpi_plugin_databaseinventory_credentialtypes` LEFT JOIN `glpi_plugin_databaseinventory_credentials` ON (`glpi_plugin_databaseinventory_credentials`.`plugin_databaseinventory_credentials_types_id` = `glpi_plugin_databaseinventory_credentialtypes`.`id`) LEFT JOIN `glpi_plugin_databaseinventory_databaseparams_credentials` ON (`glpi_plugin_databaseinventory_databaseparams_credentials`.`plugin_databaseinventory_credentials_id` = `glpi_plugin_databaseinventory_credentials`.`id`) WHERE `glpi_plugin_databaseinventory_databaseparams_credentials`.`plugin_databaseinventory_databaseparams_id` = '1'
  Error: Champ 'glpi_plugin_databaseinventory_credentials.plugin_databaseinventory_credentials_types_id' inconnu dans on clause
  Backtrace :
  src\DBmysqlIterator.php:112                       
  src\DBmysql.php:1078                               DBmysqlIterator->execute()
  ...tabaseinventory\inc\databaseparam.class.php:167 DBmysql->request()
  plugins\databaseinventory\inc\task.class.php:284   PluginDatabaseinventoryDatabaseParam->getCredentialTypeLinked()

in table:
plugin_databaseinventory_credentialtypes_id and not plugin_databaseinventory_credentials_types_id

-> correction to do at either :
\glpi\plugins\databaseinventory\inc\databaseparam.class.php, line 150
or in the table itself (name of field)

---

GLPI 10.0.10
GLPIinventory 1.3.4

Agents : FI (2.6, 2.5) et Glpiagents (1.7)

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,430

Website

Re: Plugin DatabaseInventory : Unknown field plugin_databaseinventory_cred

I think there is a bug in the code. The field was renamed just before the initial plugin release and it looks like it wasn't fixed in this query. I made a pull request on GitHub for this.
https://github.com/pluginsGLPI/database … ry/pull/10

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.