On Thu, 5 May 2011 14:54:41 +0530, Ajith Chacko wrote:
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 [1] > Plugins [2] > Environment [3] >Accounts [4] 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 Plugin Accounts 1.7.0 is for 0.80 version of GLPI - it was not released..... Links: ------ [1] http://10.205.189.162/glpi/front/central.php [2] http://10.205.189.162/glpi/plugins/environment/front/environment.php [3] http://10.205.189.162/glpi/plugins/environment/front/environment.php [4] http://10.205.189.162/glpi/plugins/accounts/front/account.php
_______________________________________________ Glpi-user mailing list [email protected] https://mail.gna.org/listinfo/glpi-user
