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

SQL Error "1054": Unknown column 'glpi_sockets.entities_id' in 'on clause' in query #71

Open
jcervantes-sipecom opened this issue Jul 10, 2024 · 0 comments

Comments

@jcervantes-sipecom
Copy link

  • Version of the plugin : 6.0.3

  • Version of your GLPI : 10.0.16

  • Steps to reproduce (which actions have you made) : Don't know exactly.

  • Expected result : No error

  • Actual result :

SQL Error "1054": Unknown column 'glpi_sockets.entities_id' in 'on clause' in query "SELECT `glpi_sockets`.*, `glpi_plugin_positions_positions`.`id` AS items_id, `glpi_entities`.`id` AS entity FROM `glpi_plugin_positions_positions`, `glpi_sockets` LEFT JOIN `glpi_entities` ON (`glpi_entities`.`id` = `glpi_sockets`.`entities_id`) WHERE `glpi_sockets`.`id` = `glpi_plugin_positions_positions`.`items_id` AND `glpi_plugin_positions_positions`.`itemtype` = 'Glpi\Socket' AND `glpi_plugin_positions_positions`.`id` = '250' ORDER BY `glpi_entities`.`completename`, `glpi_sockets`.`name`"
  • URL of the page :
    /positions/front/position.php

  • Screenshot of the problem (if pertinent) :

image

@jcervantes-sipecom jcervantes-sipecom changed the title SQL Error "1054": Unknown column 'glpi_sockets.entities_id' in 'on clause' in query "SELECT glpi_sockets.*, glpi_plugin_positions_positions.id AS items_id, glpi_entities.id AS entity FROM glpi_plugin_positions_positions, glpi_sockets LEFT JOIN glpi_entities ON (glpi_entities.id = glpi_sockets.entities_id) WHERE glpi_sockets.id = glpi_plugin_positions_positions.items_id AND glpi_plugin_positions_positions.itemtype = 'Glpi\Socket' AND glpi_plugin_positions_positions.id = '250' ORDER BY glpi_entities.completename, glpi_sockets.name" SQL Error "1054": Unknown column 'glpi_sockets.entities_id' in 'on clause' in query Jul 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant