Forum GLPI-Project

eremond

Member

Registered: 2015-03-26

Posts: 4

display bug

hi,
i had my glpi vm stucked. did reboot it.
i got a display problem: lists are well diplayes, and create input forms are well, but when i click an element to see it details, it displays nothing.

I found the memory and disks were quite limited. i doubled the ram, and then i added a vdisk in the vm, to add it in the lvm. everything fine.
then i downloaded the latest glpi version et decompressed it in the /var/www folder. fine.
then started the web page, alls points were green except for php5-gd -> done an apt-get and i get it green.
so, all green, but sayed the db must be upgraded. i launched the db update but there was a fatal error in the process.
nevertheless, i could enter in the web app.

pc list, or ticket list are ok. but when i click a pc, or a ticket, to see it in details, it does diplay nothing.
i tried to create a test ticket: the diplay is ok and i can input some datas and then add it (i also get the mail for the new ticket)
it does well appear in the list, and when i click it, it displays nothing.

any idea of how to solve this ?

thank you in advance
b.r.

(using firefox as end point browser)

eremond

Member

Registered: 2015-03-26

Posts: 4

Re: display bug

i tried under internet explorer 8. it does also diplay nothing. but shows 2 javascript errors:
- in d3-3.4.3 / d3.min.js line 3
code 0 char 25909
the object does not handle this method or property
- in nvd3 / nv.d3.min.js line 1
code 0 char 267
d3 is not defined

if it can help the debug

---- in french -----------------------------------------------------------

Message : Cet objet ne gère pas cette propriété ou cette méthode
Ligne : 3
Caractère : 25909
Code : 0
URI : : .../ plugins / fusioninventory / lib / d3-3.4.3 / d3.min.js

Message : 'd3' est indéfini.
Ligne : 1
Caractère : 267
Code : 0
URI : : ...... / nvd3 / nv.d3.min.js

-----------------------------------------------------------------------------

eremond

Member

Registered: 2015-03-26

Posts: 4

Re: display bug

hi again.
i found these errors in the mysql log file under glpi,
telling my glpi_logs and glpi_computers_items tables are crashed.

2015-03-26 16:58:44 [21@glpi]
  *** MySQL query error:
  SQL: INSERT INTO `glpi_logs`
                       (`items_id`, `itemtype`, `itemtype_link`, `linked_action`, `user_name`,
                        `date_mod`, `id_search_option`, `old_value`, `new_value`)
                VALUES (\'15\', \'PluginFusioninventoryAgent\', \'0\', \'20\',
                        \'Plugin_FusionInventory (21)\', \'2015-03-26 16:58:44\', \'0\',
                        \'\', \'\')
  Error: Table './glpi/glpi_logs' is marked as crashed and last (automatic?) repair failed
  Backtrace :
  inc/log.class.php:236
  inc/commondbtm.class.php:831                       Log::history()
  plugins/fusioninventory/inc/agent.class.php:548    CommonDBTM->add()
  ...fusioninventory/inc/communication.class.php:449 PluginFusioninventoryAgent->importToken()
  plugins/fusioninventory/front/communication.php:88 PluginFusioninventoryCommunication->handleOCSCommunication()
  plugins/fusioninventory/index.php:51               include_once()

and also

2015-03-26 16:59:27 [21@glpi]
  *** MySQL query error:
  SQL: SELECT `glpi_monitors`.`id`,
                       `glpi_computers_items`.`id` as link_id
            FROM `glpi_computers_items`
         LEFT JOIN `glpi_monitors` ON `items_id`=`glpi_monitors`.`id`
         WHERE `itemtype`=\'Monitor\'
            AND `computers_id`=\'38\'
            AND `entities_id`=\'0\'
            AND `glpi_computers_items`.`is_dynamic`=\'1\'
            AND `glpi_monitors`.`is_global`=\'0\'
  Error: Table './glpi/glpi_computers_items' is marked as crashed and last (automatic?) repair failed
  Backtrace :
  ...ventory/inc/inventorycomputerlib.class.php:1261
  ...ry/inc/inventorycomputerinventory.class.php:539 PluginFusioninventoryInventoryComputerLib->updateComputer()
  ...inventory/inc/inventoryruleimport.class.php:695 PluginFusioninventoryInventoryComputerInventory->rulepassed()
  inc/rule.class.php:1402                            PluginFusioninventoryInventoryRuleImport->executeActions()
  inc/rulecollection.class.php:1452                  Rule->process()
  ...ry/inc/inventorycomputerinventory.class.php:355 RuleCollection->processAllRules()
  ...ry/inc/inventorycomputerinventory.class.php:104 PluginFusioninventoryInventoryComputerInventory->sendCriteria()
  ...fusioninventory/inc/communication.class.php:222 PluginFusioninventoryInventoryComputerInventory->import()
  ...fusioninventory/inc/communication.class.php:452 PluginFusioninventoryCommunication->import()
  plugins/fusioninventory/front/communication.php:88 PluginFusioninventoryCommunication->handleOCSCommunication()
  plugins/fusioninventory/index.php:51               include_once()

eremond

Member

Registered: 2015-03-26

Posts: 4

Re: display bug

solution found at https://www.skyminds.net/mysql-resoudre … ir-failed/

/etc/init.d/mysql stop

myisamchk -r -v -f --sort_buffer_size=128M --key_buffer_size=128M /var/lib/mysql/glpi/glpi_tablename.MYI

/etc/init.d/mysql start

the display is now ok.

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: display bug

Thanks for explanations for other users.

---

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)