Comments (25)
Problem is there are some PluginFusioninventoryIPRange
stored in your database, you should replace them with PluginGlpiinventoryIPRange
with an SQL query as a workaround.
Some types that can be stored in the database has not been handled; but original plugin does not provide any kind of list of types that can be stored. I'll have to check manually each removed one and handle it since it may eventually be used in a itemtype
column.
from glpi-inventory-plugin.
Please try #69
from glpi-inventory-plugin.
The migration of the plugin (RC6) is not done because there are this error
log_migration_plug.zip
from glpi-inventory-plugin.
You have to:
1- drop all tables in glpi database,
2- restore original backup
3- proceed migration
from glpi-inventory-plugin.
Yes
- Drop database glpi10beta (RC2)
- Restore 9.5.7
- Migration 9.5.7 ===> 10.0 RC2 (Version 12/03/2022)
- Install plugin glpiinventory + FIX
from glpi-inventory-plugin.
-
After migration 9.5.7==> 10.0 RC2 I delete fusion inventory
I click to clean Fusion inventory
-
after install
migration_to_1.0.0-rc6.log+migration_to_9.5+3.0.log+sql-errors.log
migration_to_1.0.0-rc6.zip -
Activation plugin
bug display but after I refresh with the F5 key and i must to I have to activate a second time
I still have the same issues
from glpi-inventory-plugin.
Please give the content of php-errors-log
related to plugin installation.
from glpi-inventory-plugin.
[2022-03-14 15:20:01] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to a member function getFromDB() on bool in /var/www/html/glpi10beta/marketplace/glpiinventory/inc/task.class.php at line 742
Backtrace :
marketplace/glpiinventory/inc/task.class.php:587 PluginGlpiinventoryTask->getAgentsFromActors()
marketplace/glpiinventory/inc/task.class.php:824 PluginGlpiinventoryTask->prepareTaskjobs()
src/CronTask.php:1016 PluginGlpiinventoryTask::cronTaskscheduler()
front/cron.php:82 CronTask::launch()
I apply fix #69 (file update.native.php )
from glpi-inventory-plugin.
Can you apply following patch and give us the new trace of the error ?
diff --git a/inc/task.class.php b/inc/task.class.php
index 92abb96e3..ccc147277 100644
--- a/inc/task.class.php
+++ b/inc/task.class.php
@@ -739,10 +739,22 @@ class PluginGlpiinventoryTask extends PluginGlpiinventoryTaskView
$itemtype = key($actor);
$itemid = $actor[$itemtype];
$item = getItemForItemtype($itemtype);
+
+ // If this item doesn't exists, we continue to the next actor item.
+ // TODO: remove this faulty actor from the list of job actor.
+ if ($item === false) {
+ trigger_error(
+ sprintf('Invalid itemtype "%s".', $itemtype),
+ E_USER_WARNING
+ );
+ continue;
+ }
$dbresult = $item->getFromDB($itemid);
- // If this item doesn't exists, we continue to the next actor item.
- // TODO: remove this faulty actor from the list of job actor.
if ($dbresult === false) {
+ trigger_error(
+ sprintf('Invalid item "%s" (%s).', $itemtype, $itemid),
+ E_USER_WARNING
+ );
continue;
}
from glpi-inventory-plugin.
For information, This migration must replace PluginFusioninventoryUnmanaged with Unmanaged #glpi-project/glpi#10817
from glpi-inventory-plugin.
Is it possible to have the patch file please ?
I don't really know PHP , sorry :)
from glpi-inventory-plugin.
You just have to save the code snippet I give in a .patch file.
from glpi-inventory-plugin.
the log has changed
[2022-03-15 09:30:02] glpiphplog.WARNING: *** PHP User Warning (512): Invalid itemtype "PluginFusioninventoryAgent". in /var/www/html/glpi10beta/marketplace/glpiinventory/inc/task.class.php at line 748
Backtrace :
marketplace/glpiinventory/inc/task.class.php:748 trigger_error()
marketplace/glpiinventory/inc/task.class.php:587 PluginGlpiinventoryTask->getAgentsFromActors()
marketplace/glpiinventory/inc/task.class.php:836 PluginGlpiinventoryTask->prepareTaskjobs()
src/CronTask.php:1016 PluginGlpiinventoryTask::cronTaskscheduler()
front/cron.php:82 CronTask::launch()
[2022-03-15 09:31:01] glpiphplog.WARNING: *** PHP User Warning (512): Invalid itemtype "PluginFusioninventoryAgent". in /var/www/html/glpi10beta/marketplace/glpiinventory/inc/task.class.php at line 748
Backtrace :
marketplace/glpiinventory/inc/task.class.php:748 trigger_error()
marketplace/glpiinventory/inc/task.class.php:587 PluginGlpiinventoryTask->getAgentsFromActors()
marketplace/glpiinventory/inc/task.class.php:836 PluginGlpiinventoryTask->prepareTaskjobs()
src/CronTask.php:1016 PluginGlpiinventoryTask::cronTaskscheduler()
front/cron.php:82 CronTask::launch()
``
from glpi-inventory-plugin.
For information
Update, view ok i change the name target and actor it was ok. No error log
from glpi-inventory-plugin.
In which tables did you changed entries ?
from glpi-inventory-plugin.
In which tables did you changed entries ?
glpi_plugin_glpiinventory_taskjobs
from glpi-inventory-plugin.
#71 should fix the migration.
I have no plugin data to validate it. Is it possible for you to test the whole migration process again ?
from glpi-inventory-plugin.
glpi10beta/marketplace/glpiinventory/front/menu.php ( blank page)
[2022-03-15 12:50:36] glpiphplog.WARNING: *** PHP Warning (2): Undefined array key 0 in /var/www/html/glpi10beta/marketplace/glpiinventory/install/update.native.php at line 186
Backtrace :
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
[2022-03-15 12:50:36] glpiphplog.WARNING: *** PHP Warning (2): Undefined array key 0 in /var/www/html/glpi10beta/marketplace/glpiinventory/install/update.native.php at line 186
Backtrace :
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
[2022-03-15 12:51:39] glpiphplog.CRITICAL: *** Uncaught Exception Error: Class "PluginGlpiinventoryMenu" not found in /var/www/html/glpi10beta/marketplace/glpiinventory/front/menu.php at line 36
[2022-03-15 12:51:43] glpiphplog.CRITICAL: *** Uncaught Exception Error: Class "PluginGlpiinventoryMenu" not found in /var/www/html/glpi10beta/marketplace/glpiinventory/front/menu.php at line 36
[2022-03-15 12:51:46] glpiphplog.CRITICAL: *** Uncaught Exception Error: Class "PluginGlpiinventoryMenu" not found in /var/www/html/glpi10beta/marketplace/glpiinventory/front/menu.php at line 36
[2022-03-15 12:53:30] glpiphplog.CRITICAL: *** Uncaught Exception Error: Class "PluginGlpiinventoryMenu" not found in /var/www/html/glpi10beta/marketplace/glpiinventory/front/menu.php at line 36
from glpi-inventory-plugin.
My bad, I added a commit (2c17ede)
from glpi-inventory-plugin.
it's ok the migration except the esx task and it will be all good :)
from glpi-inventory-plugin.
I pushed another commit to handle removal of stale data. Seems that your ESX task is linked to an agent that does not exists anymore.
from glpi-inventory-plugin.
Wait, I made a mistake.
from glpi-inventory-plugin.
Wait, I made a mistake.
Now it should be OK. Could you test again ?
from glpi-inventory-plugin.
Wait, I made a mistake.
Now it should be OK. Could you test again ?
it's good, everything is fixed :)
With each migration of the plugin, I have an error message sql.error.og. I create a new issue ?
I got this error all the time since plugin rcx
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('NetworkEquipment', '22', 'otherserial', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'NetworkEquipment-22-otherserial' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Printer', '57', 'locations_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Printer-57-locations_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.069\", 6.06Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Printer', '77', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Printer-77-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.030\", 6.07Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '214', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-214-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.090\", 6.07Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Printer', '21', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Printer-21-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.073\", 6.07Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '235', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-235-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.169\", 6.08Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '236', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-236-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.004\", 6.08Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '257', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-257-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.167\", 6.09Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '258', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-258-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.002\", 6.09Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '261', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-261-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.013\", 6.09Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '259', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-259-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.002\", 6.09Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '262', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-262-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.002\", 6.09Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '263', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-263-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.003\", 6.09Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '264', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-264-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.004\", 6.09Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '265', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-265-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.003\", 6.09Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '268', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-268-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.116\", 6.10Mio)"}
[2022-03-15 13:28:01] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '269', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-269-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.003\", 6.10Mio)"}
[2022-03-15 13:28:02] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '296', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-296-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.181\", 6.10Mio)"}
[2022-03-15 13:28:02] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '297', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-297-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.002\", 6.10Mio)"}
[2022-03-15 13:28:02] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Computer', '298', 'states_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Computer-298-states_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.003\", 6.10Mio)"}
[2022-03-15 13:28:03] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Printer', '264', 'locations_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Printer-264-locations_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.868\", 6.15Mio)"}
[2022-03-15 13:28:03] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Printer', '266', 'locations_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Printer-266-locations_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.005\", 6.15Mio)"}
[2022-03-15 13:28:03] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi10beta/src/DBmysql.php line 367
*** MySQL query error:
SQL: INSERT INTO `glpi_lockedfields` (`itemtype`, `items_id`, `field`, `date_creation`, `date_mod`) VALUES ('Printer', '270', 'locations_id', '2022-03-15 13:27:55', '2022-03-15 13:27:55')
Error: Duplicate entry 'Printer-270-locations_id' for key 'unicity'
Backtrace :
src/DBmysql.php:1295
src/CommonDBTM.php:657 DBmysql->insert()
src/CommonDBTM.php:1249 CommonDBTM->addToDB()
...ace/glpiinventory/install/update.native.php:552 CommonDBTM->add()
marketplace/glpiinventory/hook.php:327 pluginGlpiinventoryUpdateNative()
src/Plugin.php:773 plugin_glpiinventory_install()
: Plugin->install()
src/Marketplace/Controller.php:486 call_user_func()
src/Marketplace/Controller.php:405 Glpi\Marketplace\Controller->setPluginState()
ajax/marketplace.php:80 Glpi\Marketplace\Controller->installPlugin()
{"user":"7@srv-glpi","mem_usage":"0.019\", 6.15Mio)"}
from glpi-inventory-plugin.
With each migration of the plugin, I have an error message sql.error.og. I create a new issue ?
Yes, please create a new issue.
from glpi-inventory-plugin.
Related Issues (20)
- Running task Deploy - [error] [http client] Can't decode JSON content, starting with HOT 7
- Repository has some strange version tags HOT 1
- Update 1.3.5 HOT 1
- Self-deploy : Add target for deploy on demand
- SNMP inventory problem with disconnecting devices from the switch HOT 10
- Change agent name according to pc name change HOT 2
- GLPI Inventory not linking with Computers ITEM 0 HOT 1
- PHP Warning (2): Trying to access array offset on null in statediscovery.class.php at line 168 HOT 9
- taskscheduler error when using a dynamic group with a criteria on the fields plugins HOT 3
- Deployment Task Message is Garbled on Client HOT 8
- Collect : access denied on POST when using a proxy HOT 5
- No access to Inventory Agents HOT 4
- Accents isn't being rendered on NetInventory task HOT 3
- Tag isn't added to NetInventory tasks HOT 4
- Cisco/Comware switches returns VLAN-interface Base MAC Address as Mgmt Port HOT 1
- eth0 port (Aruba AP) isn't being imported through GLPI Agent, only when injecting manually
- About the server URL to use as server parameter, it will depends on your server and plugins installation
- Strange behaviour of inventory and error in Apache2 HOT 8
- Import children locations HOT 1
- Computers inventoried by agent dissappear after a while HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from glpi-inventory-plugin.