Forum GLPI-Project

Shesoff

Member

Registered: 2017-08-24

Posts: 4

Rulses in entity

Hi everyone.
In entity in left (structure) side I see that rulse have something, but in right side I see "No item found". How do it fix?
GLPI 9.3.1.

Shesoff

Member

Registered: 2017-08-24

Posts: 4

Re: Rulses in entity

Screenshot https://yadi.sk/i/Rq_fUbnYWf0-Jg

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Rulses in entity

I can't reproduce.
Have you some error in Debug mode? in GLPI or Apache logs?

---

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)

Shesoff

Member

Registered: 2017-08-24

Posts: 4

Re: Rulses in entity

Apache doesn't have any errors when I open this entity.
Access log:

10.1.0.13 - - [22/Oct/2018:17:14:06 +0300] "GET /front/entity.form.php?id=2 HTTP/1.1" 200 507042 "http://help.invest.ru/front/entity.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36"
10.1.0.13 - - [22/Oct/2018:17:14:07 +0300] "GET /ajax/updatecurrenttab.php?itemtype=Entity&id=2&tab=8 HTTP/1.1" 200 - "http://help.invest.ru/front/entity.form.php?id=2" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36"
10.1.0.13 - - [22/Oct/2018:17:14:07 +0300] "GET /ajax/common.tabs.php?_target=/front/entity.form.php&_itemtype=Entity&_glpi_tab=Rule$1&id=2& HTTP/1.1" 200 20228 "http://help.invest.ru/front/entity.form.php?id=2" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36"
10.1.0.13 - - [22/Oct/2018:17:14:07 +0300] "GET /pics/favicon.ico HTTP/1.1" 200 4286 "http://help.invest.ru/front/entity.form.php?id=2" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36"

tail -f files/_log/*.log shows me this errors:

==> files/_log/php-errors.log <==
[2018-10-22 17:15:05] glpiphplog.DEBUG: Config::getCache() in /var/www/html/glpi/inc/config.class.php line 2930
CACHE cache_db Zend\Cache\Storage\Adapter\Apc  {"user":"6@cnt7-006.invest.ru"} 
[2018-10-22 17:15:05] glpiphplog.DEBUG: Config::getCache() in /var/www/html/glpi/inc/config.class.php line 2930
CACHE cache_trans Zend\Cache\Storage\Adapter\Apc  {"user":"6@cnt7-006.invest.ru","mem_usage":"0.003\", 2.03Mio)"} 
[2018-10-22 17:15:06] glpiphplog.DEBUG: Config::getCache() in /var/www/html/glpi/inc/config.class.php line 2930
CACHE cache_db Zend\Cache\Storage\Adapter\Apc  {"user":"6@cnt7-006.invest.ru"} 
[2018-10-22 17:15:06] glpiphplog.DEBUG: Config::getCache() in /var/www/html/glpi/inc/config.class.php line 2930
CACHE cache_trans Zend\Cache\Storage\Adapter\Apc  {"user":"6@cnt7-006.invest.ru","mem_usage":"0.003\", 2.02Mio)"} 
[2018-10-22 17:15:06] glpiphplog.DEBUG: Config::getCache() in /var/www/html/glpi/inc/config.class.php line 2930
CACHE cache_db Zend\Cache\Storage\Adapter\Apc  {"user":"6@cnt7-006.invest.ru"} 
[2018-10-22 17:15:06] glpiphplog.DEBUG: Config::getCache() in /var/www/html/glpi/inc/config.class.php line 2930
CACHE cache_trans Zend\Cache\Storage\Adapter\Apc  {"user":"6@cnt7-006.invest.ru","mem_usage":"0.003\", 2.02Mio)"} 

==> files/_log/sql-errors.log <==
[2018-10-22 17:15:06] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/inc/dbmysql.class.php line 177
  *** MySQL query error:
  SQL: SELECT  `glpi_rules`.`id` FROM `glpi_ruleactions`, `glpi_rules` WHERE `glpi_ruleactions`.`rules_id` = `glpi_rules`.`id` AND `glpi_rules`.`sub_type` = 'RuleRight' AND `glpi_ruleactions`.`SELECT` = 'glpi_rules.id' AND `glpi_ruleactions`.`FROM` IN ('glpi_ruleactions', 'glpi_rules') AND `glpi_ruleactions`.`WHERE` IN (`glpi_rules`.`id`, 'RuleRight')
  Error: Unknown column 'glpi_ruleactions.SELECT' in 'where clause'
  Backtrace :
  inc/dbmysqliterator.class.php:95                   
  inc/dbmysql.class.php:580                          DBmysqlIterator->execute()
  inc/rule.class.php:2718                            DBmysql->request()
  inc/rule.class.php:2775                            Rule->getRulesForCriteria()
  inc/rule.class.php:3072                            Rule->showAndAddRuleForm()
  inc/commonglpi.class.php:488                       Rule::displayTabContentForItem()
  ajax/common.tabs.php:92                            CommonGLPI::displayStandardTab()
  {"user":"6@cnt7-006.invest.ru","mem_usage":"0.014\", 4.15Mio)"} 
[2018-10-22 17:15:06] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/inc/dbmysql.class.php line 177
  *** MySQL query error:
  SQL: SELECT  `glpi_rules`.`id` FROM `glpi_ruleactions`, `glpi_rules` WHERE `glpi_ruleactions`.`rules_id` = `glpi_rules`.`id` AND `glpi_rules`.`sub_type` = 'RuleMailCollector' AND `glpi_ruleactions`.`SELECT` = 'glpi_rules.id' AND `glpi_ruleactions`.`FROM` IN ('glpi_ruleactions', 'glpi_rules') AND `glpi_ruleactions`.`WHERE` IN (`glpi_rules`.`id`, 'RuleMailCollector')
  Error: Unknown column 'glpi_ruleactions.SELECT' in 'where clause'
  Backtrace :
  inc/dbmysqliterator.class.php:95                   
  inc/dbmysql.class.php:580                          DBmysqlIterator->execute()
  inc/rule.class.php:2718                            DBmysql->request()
  inc/rule.class.php:2775                            Rule->getRulesForCriteria()
  inc/rule.class.php:3084                            Rule->showAndAddRuleForm()
  inc/commonglpi.class.php:488                       Rule::displayTabContentForItem()
  ajax/common.tabs.php:92                            CommonGLPI::displayStandardTab()
  {"user":"6@cnt7-006.invest.ru","mem_usage":"0.004\", 4.58Mio)"}