Forum GLPI-Project

generalvini

Member

Registered: 2018-03-09

Posts: 21

Error after update from 9.1.6 to 9.3.1

My rule_actions on entities are blank in front/entity.form.php. In debug mode there is an error in the query

Unknown column 'glpi_ruleactions.SELECT' in 'where clause'

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')	0.001	Unknown column 'glpi_ruleactions.SELECT' in 'where clause'

anyone can help me ?

Last edited by generalvini (2018-09-13 14:14:44)

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,287

Re: Error after update from 9.1.6 to 9.3.1

I have the same error
(glpi9.3.1 upgraded from 9.3)

edit :

i don't understand : i can't see this message anymore !

---

Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9

orthagh

Administrator

From: TECLIB - CAEN

Registered: 2010-11-30

Posts: 662

Website

Re: Error after update from 9.1.6 to 9.3.1

Voir https://github.com/glpi-project/glpi/pull/4637 pour la correction