Forum GLPI-Project

Megachip

Member

Registered: 2014-05-02

Posts: 109

[Appliances 1.9.0][GLPI 0.84.5] Error: Unknown column 'appliances_id'

Appliances do not load the appliances anymore

*** MySQL query error:
***
SQL: SELECT COUNT(*) AS cpt
             FROM `glpi_plugin_archires_appliancequeries` WHERE `appliances_id`=\'1\'
                                                AND entities_id NOT IN (\'0\')
Error: Unknown column 'appliances_id' in 'where clause'
Backtrace :
/usr/share/glpi/inc/db.function.php :328           DBmysql->query()
/usr/share/glpi/inc/commondbtm.class.php :1697             countElementsInTable()
/usr/share/glpi/inc/commondbtm.class.php :2098             CommonDBTM->canUnrecurs()
/usr/share/glpi/plugins/appliances/inc/appliance.class.php :242            CommonDBTM->showFormHeader()
/usr/share/glpi/plugins/appliances/front/appliance.form.php :154           PluginAppliancesAppliance->showForm()
/usr/share/glpi/plugins/appliances/front/appliance.form.php

possible this is in connection with this topic.

Bug occurs when Childentries of appliances is yes and archires is installed.

Disabling archires solves the problem.

Last edited by Megachip (2014-05-03 13:40:16)

Megachip

Member

Registered: 2014-05-02

Posts: 109

Re: [Appliances 1.9.0][GLPI 0.84.5] Error: Unknown column 'appliances_id'

Possible a naming problem?

plugin_appliances_appliances_id -> appliances_id

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: [Appliances 1.9.0][GLPI 0.84.5] Error: Unknown column 'appliances_id'

It's not a problem of the plugin Appliances but of the plugin Archires.
What is the version of Archires used?

---

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)

Megachip

Member

Registered: 2014-05-02

Posts: 109

Re: [Appliances 1.9.0][GLPI 0.84.5] Error: Unknown column 'appliances_id'

What is the version of Archires used?

The latest available: 2.1.0