You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2014-05-03 12:51:52

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 sad

*** 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)

Offline

#2 2014-05-03 13:42:18

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

Offline

#3 2014-05-04 19:46:06

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)

Offline

#4 2014-05-06 08:29:24

Megachip
Member
Registered: 2014-05-02
Posts: 109

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

yllen wrote:

What is the version of Archires used?

The latest available: 2.1.0

Offline

Board footer

Powered by FluxBB