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

[9.2] SQL Error: Unknown column 'glpi_operatingsystems.entities_id' #3038

Closed
flegastelois opened this issue Oct 24, 2017 · 0 comments
Closed
Assignees
Labels
Milestone

Comments

@flegastelois
Copy link
Member

*** MySQL query error:
SQL: SELECT COUNT(*) AS cpt FROM glpi_items_operatingsystems, glpi_operatingsystems WHERE glpi_items_operatingsystems.operatingsystems_id = glpi_operatingsystems.id
AND glpi_items_operatingsystems.items_id = '9014'
AND glpi_items_operatingsystems.itemtype = 'Computer' AND ( glpi_operatingsystems.entities_id IN ('114') OR (glpi_operatingsystems.is_recursive='1' AND glpi_operatingsystems.entities_id IN ('0','325')) )
Error: Unknown column 'glpi_operatingsystems.entities_id' in 'where clause'
Backtrace :
inc/dbmysqliterator.class.php:274
inc/dbmysql.class.php:540 DBmysqlIterator->__construct()
inc/dbutils.class.php:325 DBmysql->request()
inc/db.function.php:202 DbUtils->countElementsInTable()
inc/item_operatingsystem.class.php:65 countElementsInTable()

@trasher trasher self-assigned this Oct 24, 2017
@trasher trasher added this to the 9.2.1 milestone Oct 24, 2017
trasher added a commit to trasher/glpi that referenced this issue Oct 24, 2017
trasher added a commit that referenced this issue Oct 24, 2017
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

2 participants