Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error after update to 9.3.1 #4636

Closed
GeneralVini opened this issue Sep 13, 2018 · 2 comments
Closed

Error after update to 9.3.1 #4636

GeneralVini opened this issue Sep 13, 2018 · 2 comments
Labels
Milestone

Comments

@GeneralVini
Copy link

  • Steps to reproduce (which actions have you made) :
    Administration->Entities->Any of them ->Rules(tab)

  • Expected result :
    List of entity rules

  • Actual result :

Error: 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` = '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')
  • URL of the page :
    /front/entity.form.php?id=0

  • Screenshot of the problem (if pertinent) :

  • Your GLPI setup (you can find it in Setup > General menu, System tab) :

GLPI 9.3.1 ( => /var/www/html/glpi)
Installation mode: TARBALL
@trasher
Copy link
Contributor

trasher commented Sep 13, 2018

Please provide the full error stack trace

@GeneralVini
Copy link
Author

GeneralVini commented Sep 13, 2018

No stack trace ... "Display only tab for debug" and I went to ajax debugging and saw the error
"Error: Unknown column 'glpi_ruleactions.SELECT' in 'where clause'"

in the query

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')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants