Forum GLPI-Project

hidenname

Member

Registered: 2014-06-30

Posts: 22

GLPI 0.90.3 - Problem to view computer Items - screen blank

I think since GLPI 0.90.3 i have trouble to view Computer Items Details in GLPI 0.90.3

If i click on one Comuter Item under Assetts / Comuter - the screen ist empty (only with profile super-admin)

If i turn on Deubug Mode - the following error occurs
Fatal error: Call to a member function fetch_assoc() on a non-object in /var/www/html/glpi/inc/dbmysql.class.php on line 280

If i turn off the Plugin

OCS Inventory NG    1.2.1

and click on a computer item i receive the follwing error
Fatal error: Class 'PluginOcsinventoryngItem_DeviceBiosdata' not found in /var/www/html/glpi/inc/item_devices.class.php on line 300

Uninstallation of plugins are also not possible -

For example if i try to uninstall the cartographie plugin( Version  4.2.1) - i receive the error

Fatal error: Class 'PluginPositionsProfile' not found in /var/www/html/glpi/plugins/positions/hook.php on line 167

--

If try to uninstall the plugin reports (Version     1.9.1)  - nothing happens - the screen just flickers

Uninstallation of these plugins does also not work on a completely new installation

Can anyone help ?

Last edited by hidenname (2016-05-06 17:05:45)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: GLPI 0.90.3 - Problem to view computer Items - screen blank

have you errors in glpi logs?
Have you some DB table crashed?

---

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)

hidenname

Member

Registered: 2014-06-30

Posts: 22

Re: GLPI 0.90.3 - Problem to view computer Items - screen blank

But uniinstallation of  was not possible as described before
(Fatal error: Class 'PluginPositionsProfile' not found in /var/www/html/glpi/plugins/positions/hook.php on line 167 )

It's a bug of the plugin Positions. You must contact the leader of this plugin

CiroM

Member

Registered: 2016-06-28

Posts: 2

Re: GLPI 0.90.3 - Problem to view computer Items - screen blank

have you errors in glpi logs?
Have you some DB table crashed?

I identified the error, it requires a plugin that adds fields and changing the default search. The error is related to mysql 5.7 changing how GROUP BY works. Error: http://craftcms.stackexchange.com/quest … p-by/12106

In glpi this shows up in the error log:
tail sql-errors.log
                                              AND `glpi_items_deviceprocessors`.`itemtype` = \'Computer\'
                                              ) LEFT JOIN `glpi_deviceprocessors`  AS `glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`
                                          ON (`glpi_items_deviceprocessors`.`deviceprocessors_id` = `glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id`
                                              ) WHERE  `glpi_computers`.`is_deleted` = \'0\'  AND `glpi_computers`.`is_template` = \'0\'  GROUP BY `glpi_computers`.`id` ORDER BY ITEM_0 ASC  LIMIT 0, 15
  Error: Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'glpi.glpi_plugin_fusioninventory_inventorycomputercomputers_id.last_fusioninventory_update' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  Backtrace :
  inc/search.class.php:903                           
  inc/search.class.php:98                            Search::constructDatas()
  inc/search.class.php:81                            Search::showList()
  front/computer.php:44                              Search::show()

To cause this error, add the 'FusInv - Last inventory' field to any default list and the page will go blank due to this change.

CiroM

Member

Registered: 2016-06-28

Posts: 2

Re: GLPI 0.90.3 - Problem to view computer Items - screen blank

Bumping for mysql error