Hello, I am from India, trying to setup and use GLPI for my IT support team. This is my first post to GLPI users list.
I am using GLPI 0.78.5. Plugin Accounts 1.7.0 is showing following error when accessed at Home <http://10.205.189.162/glpi/front/central.php> > Plugins <http://10.205.189.162/glpi/plugins/environment/front/environment.php> > Environment <http://10.205.189.162/glpi/plugins/environment/front/environment.php> > Accounts <http://10.205.189.162/glpi/plugins/accounts/front/account.php> Unknown column 'glpi_plugin_accounts_accounts.' in 'on clause' at the same time, glpi/files/_log/sql-errors.log give following error, *** MySQL query error : *** SQL: SELECT `glpi_plugin_accounts_accounts`.`entities_id`, `glpi_plugin_accounts_accounts`.`is_recursive`, `glpi_plugin_accounts_accounts`.`name` AS ITEM_0, `glpi_plugin_accounts_accounts`.`id` AS ITEM_0_2, `glpi_users`.`name` AS ITEM_1, `glpi_users`.`realname` AS ITEM_1_2, `glpi_users`.`id` AS ITEM_1_3, `glpi_users`.`firstname` AS ITEM_1_4, `glpi_plugin_accounts_accounts`.`login` AS ITEM_2, `glpi_plugin_accounts_accounttypes`.`name` AS ITEM_3, `glpi_plugin_accounts_accounts`.`date_creation` AS ITEM_4, `glpi_plugin_accounts_accounts`.`date_expiration` AS ITEM_5, `glpi_plugin_accounts_accounts`.`comment` AS ITEM_6, `glpi_plugin_accounts_accounts`.`id` AS id FROM `glpi_plugin_accounts_accounts` LEFT JOIN `glpi_users` ON (`*glpi_plugin_accounts_accounts`.`` *= `glpi_users`.`id`) LEFT JOIN `glpi_plugin_accounts_accounttypes` ON (`glpi_plugin_accounts_accounttypes`.`id` = `glpi_plugin_accounts_accounts`.`plugin_accounts_accounttypes_id`) WHERE `glpi_plugin_accounts_accounts`.`is_deleted` = \'0\' ORDER BY ITEM_0 ASC LIMIT 0, 20 Error: Unknown column 'glpi_plugin_accounts_accounts.' in 'on clause' Backtrace : /home/web/glpi/inc/search.class.php :670 DBmysql->query() /home/web/glpi/inc/search.class.php :48 Search::showList() /home/web/glpi/plugins/accounts/front/account.php :83 Search::show() /home/web/glpi/plugins/accounts/front/account.php Field name is missing in ON clause. Where to look for a fix? How can I post a bug/error report? Do we have any document for porting a plugin from 0.72 to 0.78 and higher? I was looking at Backups and Shutdown plugins Thank you Ajith Jorhat
_______________________________________________ Glpi-user mailing list [email protected] https://mail.gna.org/listinfo/glpi-user
