Forum GLPI-Project

Jaajog

Member

Registered: 2011-06-27

Posts: 2

Software inventory not displayed

Hi,

After upgrading to 0.80, software inventory is showed as empty. I can see the software under computers and it exists in the database (glpi_softwares). What could be causing this? I was using OCS dictionary, now I have switched it off.

Possibly related question - I now want to import all software from OCS (not use OCS dictionary). How can I force GLPI to import all software, since it doesn't do that automatically? (edit: Force Sync button, doesn't that make sense

Thanks,
Jaajog

edit: discovered the log to file possibility. This appears in sql log when opening Software:

27-06-2011 20:30 [changed]
*** MySQL query error : 
***
SQL: SELECT \'admin\' AS currentuser, `glpi_softwares`.`entities_id`, `glpi_softwares`.`is_recursive`,  `glpi_softwares`.`name` AS ITEM_0,
                        `glpi_softwares`.`id` AS ITEM_0_2,  `glpi_entities`.`completename` AS ITEM_1,
                     `glpi_entities`.`id` AS ITEM_1_2, `glpi_softwarecategories`.`name` AS ITEM_2,  COUNT(DISTINCT `glpi_computers_softwareversions_23af9de72785ae510f81f99055099b74`.`id`)
                        AS ITEM_3, `glpi_manufacturers`.`name` AS ITEM_4,  GROUP_CONCAT(DISTINCT `glpi_softwarelicenses`.`name` SEPARATOR \'$$$$\') AS ITEM_5, `glpi_softwares`.`id` AS id  FROM `glpi_softwares`LEFT JOIN `glpi_entities` 
                                          ON (`glpi_softwares`.`entities_id` = `glpi_entities`.`id`
                                              )LEFT JOIN `glpi_softwarecategories` 
                                          ON (`glpi_softwares`.`softwarecategories_id` = `glpi_softwarecategories`.`id`
                                              )LEFT JOIN `glpi_softwareversions` 
                                          ON (`glpi_softwares`.`softwareversions_id` = `glpi_softwareversions`.`id`
                                              ) LEFT JOIN `glpi_computers_softwareversions`  AS glpi_computers_softwareversions_23af9de72785ae510f81f99055099b74
                                             ON (`glpi_softwareversions`.`id`
                                                      = `glpi_computers_softwareversions_23af9de72785ae510f81f99055099b74`.`softwareversions_id`
                                                         AND `glpi_computers_softwareversions_23af9de72785ae510f81f99055099b74`.`is_deleted` = \'0\'
                                                         AND `glpi_computers_softwareversions_23af9de72785ae510f81f99055099b74`.`is_template` = \'0\' )LEFT JOIN `glpi_manufacturers` 
                                          ON (`glpi_softwares`.`manufacturers_id` = `glpi_manufacturers`.`id`
                                              ) LEFT JOIN `glpi_softwarelicenses` 
                                             ON (`glpi_softwares`.`id`
                                                      = `glpi_softwarelicenses`.`softwares_id`
                                                         ) WHERE  `glpi_softwares`.`is_deleted` = \'0\'  AND `glpi_softwares`.`is_template` = \'0\'  GROUP BY `glpi_softwares`.`id` ORDER BY ITEM_0 ASC  LIMIT 0, 50
Error: Unknown column 'glpi_softwares.softwareversions_id' in 'on clause'
Backtrace :
/var/www/html/glpi/inc/search.class.php :740        DBmysql->query()
/var/www/html/glpi/inc/search.class.php :49        Search::showList()
/var/www/html/glpi/front/software.php :44        Search::show()
/var/www/html/glpi/front/software.php

Last edited by Jaajog (2011-06-27 20:07:56)

voss

Member

Registered: 2007-08-27

Posts: 21

Re: Software inventory not displayed

I also have this problem (I discovered this problem today).  Nothing has changed on my side though except I upgraded GLPI to 0.80.

voss

Member

Registered: 2007-08-27

Posts: 21

Re: Software inventory not displayed

There's also newer glpi: ver 0.80.1, but it does not have that bug fixed: https://forge.indepnet.net/projects/glpi/versions/575
I am using OCSNG server ver 4100 (Old, I Know).

Jaajog

Member

Registered: 2011-06-27

Posts: 2

Re: Software inventory not displayed

I have OCS Server 1.4, I had to roll back (to GLPI 0.78.5) because I really needed the software info.

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Software inventory not displayed

This problem is solved in 0.80.1 (LEFT JOIN `glpi_softwareversions` ON (`glpi_softwares`.`id` = `glpi_softwareversions`.`softwares_id` ))

---

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)