Closed NicolasPHP closed 2 years ago
g-bougard
commented
2 years ago Hi @NicolasPHP
please configure your agent with debug=2 in registry and restart the service. Then check the agent log for a more accurate error. Also do you have PHP stack trace with the PHP error and did you search for that error on GLPI project issue tracker, even in closed issues ?
NicolasPHP
commented
2 years ago Hi @g-bougard
I found nothing about this error in other sections of the glpi github. Agent is already configure with debug level 2
In the agent log, before is the complete inventory, and the lines after are :
[Wed Oct 12 19:11:09 2022][debug] new thread 8 to handle task RemoteInventory
[Wed Oct 12 19:11:09 2022][debug] Remote inventory task execution disabled: no remote to inventory
[Wed Oct 12 19:11:09 2022][debug] new thread 9 to handle task Collect
[Wed Oct 12 19:11:09 2022][info] running task CollectHere the full stack on server side error log
[2022-10-12 19:11:08] glpiphplog.ERROR: *** PHP User Error (256): Column 'manufacturers_id' cannot be null in /var/www/glpi/src/DBmysql.php at line 1961
Backtrace :
src/DBmysql.php:1961 trigger_error()
src/Inventory/Asset/Software.php:681 DBmysql->executeStatement()
src/Inventory/Asset/Software.php:421 Glpi\Inventory\Asset\Software->storeSoftware()
src/Inventory/Asset/MainAsset.php:834 Glpi\Inventory\Asset\Software->handle()
src/Inventory/Asset/MainAsset.php:754 Glpi\Inventory\Asset\MainAsset->handleAssets()
src/RuleImportAsset.php:965 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1510 RuleImportAsset->executeActions()
src/RuleCollection.php:1591 Rule->process()
src/Inventory/Asset/MainAsset.php:554 RuleCollection->processAllRules()
src/Inventory/Inventory.php:701 Glpi\Inventory\Asset\MainAsset->handle()
src/Inventory/Inventory.php:336 Glpi\Inventory\Inventory->handleItem()
src/Inventory/Request.php:360 Glpi\Inventory\Inventory->doInventory()
src/Inventory/Request.php:90 Glpi\Inventory\Request->inventory()
src/Agent/Communication/AbstractRequest.php:332 Glpi\Inventory\Request->handleAction()
src/Agent/Communication/AbstractRequest.php:244 Glpi\Agent\Communication\AbstractRequest->handleJSONRequest()
front/inventory.php:86 Glpi\Agent\Communication\AbstractRequest->handleRequest()
plugins/glpiinventory/front/communication.php:72 include_once()
plugins/glpiinventory/index.php:45 include_once()It seems related to software import. Can you share the full output of the following command ?
glpi-inventory --partial softwareYou should anonymize personal datas under "content" -> "operatingsystem" node.
NicolasPHP
commented
2 years ago [info] New partial inventory from DESKTOP-PKHK2B7-2022-10-12-19-32-32 for local0
{
"action": "inventory",
"content": {
"bios": {
"assettag": "",
"bdate": "2020-01-27",
"biosserial": "YM4M002447",
"bmanufacturer": "FUJITSU // American Megatrends Inc.",
"bversion": "V5.0.0.11 R1.29.0 for D3431-A1x",
"enclosureserial": "YM4M002447",
"mmodel": "D3431-A1",
"msn": "49253809",
"smanufacturer": "FUJITSU",
"smodel": "ESPRIMO_D756",
"ssn": "YM4M002447"
},
"hardware": {
"chassis_type": "Desktop",
"memory": 7966,
"name": "DESKTOP-PKHK2B7",
"uuid": "6D46B4AA-231B-5049-89F8-78EB4672263A",
"vmsystem": "Physical",
"winlang": "1036",
"winowner": "Utilisateur Windows",
"winprodid": "00330-80000-00000-AA860",
"winprodkey": "XXXXX-XXXXX-XXXXX-XXXXX",
"workgroup": "WORKGROUP"
},
"softwares": [
{
"arch": "x86_64",
"from": "registry",
"guid": "45BED3BBD4732BEB270707C3769191B9C55708E6",
"install_date": "2021-11-26",
"name": "Package de pilotes Windows - Zebra Technologies Inc. (WinUSB) WinUSB devices (03/31/2018 1.0.0.6)",
"publisher": "Zebra Technologies Inc.",
"system_category": "application",
"uninstall_string": "rundll32.exe C:\\PROGRA~1\\DIFX\\4CBAA680AB78144E\\DIFxAppA.dll, DIFxARPUninstallDriverPackage C:\\WINDOWS\\System32\\DriverStore\\FileRepository\\snapi_imaging_interface.inf_amd64_a2346bfb26da7a57\\snapi_imaging_interface.inf",
"version": "03/31/2018 1.0.0.6"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "7-Zip",
"install_date": "2021-02-18",
"name": "7-Zip 19.00 (x64)",
"publisher": "Igor Pavlov",
"system_category": "application",
"uninstall_string": "C:\\Program Files\\7-Zip\\Uninstall.exe",
"version": "19.00"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "BarTender 11.2",
"install_date": "2021-02-23",
"name": "BarTender 2021 R3",
"publisher": "Seagull Scientific",
"system_category": "application",
"uninstall_string": "msiexec.exe /I{8A27C756-BAA0-4F31-8FFF-CF50D4CCBC00}",
"version": "11.2.3.163367"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "KB4022619",
"helplink": "http://support.microsoft.com/?kbid=4022619",
"install_date": "2021-02-23",
"name": "Service Pack 3 for SQL Server 2014 (KB4022619) (64-bit)",
"publisher": "Microsoft Corporation",
"release_type": "ServicePack",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files\\Microsoft SQL Server\\120\\Setup Bootstrap\\Update Cache\\KB4022619\\ServicePack\\setup.exe\" /Action=RemovePatch /AllInstances ",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "Microsoft SQL Server 12",
"install_date": "2021-02-23",
"name": "Microsoft SQL Server 2014 (64-bit)",
"system_category": "system_component"
},
{
"arch": "x86_64",
"comments": "Mozilla Firefox 105.0.3 (x64 fr)",
"from": "registry",
"guid": "Mozilla Firefox 105.0.3 (x64 fr)",
"helplink": "https://support.mozilla.org",
"install_date": "2022-10-11",
"name": "Mozilla Firefox (x64 fr)",
"publisher": "Mozilla",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files\\Mozilla Firefox\\uninstall\\helper.exe\"",
"url_info_about": "https://www.mozilla.org",
"version": "105.0.3"
},
{
"arch": "x86_64",
"comments": "Mozilla Maintenance Service",
"from": "registry",
"guid": "MozillaMaintenanceService",
"install_date": "2021-02-18",
"name": "Mozilla Maintenance Service",
"publisher": "Mozilla",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files (x86)\\Mozilla Maintenance Service\\uninstall.exe\"",
"version": "85.0.2"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "Notepad++",
"install_date": "2022-10-12",
"name": "Notepad++ (64-bit x64)",
"publisher": "Notepad++ Team",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files\\Notepad++\\uninstall.exe\"",
"url_info_about": "https://notepad-plus-plus.org/",
"version": "8.4.6",
"version_major": "8",
"version_minor": "46"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "O365ProPlusRetail - fr-fr",
"install_date": "2022-10-01",
"name": "Microsoft 365 Apps for enterprise - fr-fr",
"no_remove": false,
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files\\Common Files\\Microsoft Shared\\ClickToRun\\OfficeClickToRun.exe\" scenario=install scenariosubtype=ARP sourcetype=None productstoremove=O365ProPlusRetail.16_fr-fr_x-none culture=fr-fr version.16=16.0",
"version": "16.0.15629.20156"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "OneDriveSetup.exe",
"helplink": "https://go.microsoft.com/fwlink/?LinkID=215117",
"install_date": "2022-10-08",
"name": "Microsoft OneDrive",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "C:\\Program Files\\Microsoft OneDrive\\22.202.0925.0001\\OneDriveSetup.exe /uninstall /allusers ",
"version": "22.202.0925.0001"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{0E35DC28-FAD2-493F-A997-1DE274A010FB}",
"helplink": "http://www.veeam.com/support.html",
"install_date": "2021-12-06",
"name": "Veeam Service Provider Console Management Agent",
"publisher": "Veeam Software Group GmbH",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{0E35DC28-FAD2-493F-A997-1DE274A010FB}",
"url_info_about": "www.veeam.com",
"version": "6.0.0.7739"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{17531BCD-C627-46A2-9F1E-7CC920E0E94A}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=154582",
"install_date": "2021-02-23",
"name": "SQL Server 2014 Express Edition Database Engine Services",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /I{17531BCD-C627-46A2-9F1E-7CC920E0E94A}",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"comments": "Caution. Removing this product might prevent some applications from running.",
"from": "registry",
"guid": "{1D8E6291-B0D5-35EC-8441-6616F567A0F7}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=146008",
"install_date": "2021-02-23",
"name": "Microsoft Visual C++ 2010 x64 Redistributable - 10.0.40219",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{1D8E6291-B0D5-35EC-8441-6616F567A0F7}",
"version": "10.0.40219"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{366CD715-2FF4-40B4-A8B4-A05E5D21A945}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=90958",
"install_date": "2021-02-23",
"name": "Microsoft VSS Writer for SQL Server 2014",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{366CD715-2FF4-40B4-A8B4-A05E5D21A945}",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{3E1C73AF-C195-436E-8065-00A0CFC0C196}",
"install_date": "2021-11-26",
"name": "Zebra 123Scan (64bit)",
"publisher": "Zebra Technologies",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /X{3E1C73AF-C195-436E-8065-00A0CFC0C196}",
"url_info_about": "www.zebra.com/123scan",
"version": "5.03.0014"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{50D6B005-B0D6-425F-953B-01331E2C7FCB}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=191752",
"install_date": "2021-02-23",
"name": "Microsoft ODBC Driver 11 for SQL Server",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{50D6B005-B0D6-425F-953B-01331E2C7FCB}",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{6292D514-17A4-403F-98F9-E150F10C043D}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=101173",
"install_date": "2021-02-23",
"name": "Microsoft SQL Server 2008 Setup Support Files ",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{6292D514-17A4-403F-98F9-E150F10C043D}",
"version": "10.3.5500.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{6476DB81-F263-4C04-8574-AAD31136C304}",
"helplink": "http://go.microsoft.com/fwlink/?LinkID=156591",
"install_date": "2021-02-23",
"name": "Sql Server Customer Experience Improvement Program",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /I{6476DB81-F263-4C04-8574-AAD31136C304}",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{664FF6D5-07C0-405D-9D3B-5697A9B62E1C}",
"install_date": "2021-11-26",
"name": "Zebra CoreScanner Driver (64bit)",
"publisher": "Zebra Technologies",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /X{664FF6D5-07C0-405D-9D3B-5697A9B62E1C}",
"url_info_about": "www.zebra.com/scannersdkforwindows",
"version": "3.07.0004"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{6CB12CDD-CA89-40EC-9FCA-D1A7FC8C9872}",
"helplink": "http://www.veeam.com/support.html",
"install_date": "2021-12-06",
"name": "Veeam Agent for Microsoft Windows",
"publisher": "Veeam Software Group GmbH",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{6CB12CDD-CA89-40EC-9FCA-D1A7FC8C9872}",
"url_info_about": "http://www.veeam.com",
"version": "5.0.1.4584"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{6CC673B9-F743-47AD-8962-C00CA5300016}",
"helplink": "http://search.microsoft.com",
"install_date": "2021-02-23",
"name": "Microsoft SQL Server 2014 Transact-SQL ScriptDom ",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{6CC673B9-F743-47AD-8962-C00CA5300016}",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{7B1FCD52-8F6B-4F12-A143-361EA39F5E7C}",
"install_date": "2022-04-05",
"name": "Microsoft Update Health Tools",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{7B1FCD52-8F6B-4F12-A143-361EA39F5E7C}",
"version": "3.67.0.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{7DC387B8-E6A2-480C-8EF9-A6E51AE81C19}",
"install_date": "2021-11-26",
"name": "Microsoft Visual C++ 2019 X64 Minimum Runtime - 14.24.28127",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /I{7DC387B8-E6A2-480C-8EF9-A6E51AE81C19}",
"version": "14.24.28127"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{7ED2561C-FBC2-421E-A2B5-C7BEFD623145}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=149838",
"install_date": "2021-12-06",
"name": "Microsoft SQL Server 2012 Management Objects (x64)",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{7ED2561C-FBC2-421E-A2B5-C7BEFD623145}",
"version": "11.4.7001.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{8424B163-D1E0-48B7-88A2-C7A61767B3D7}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=81488",
"install_date": "2021-02-23",
"name": "Microsoft SQL Server Compact 4.0 x64 ENU",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{8424B163-D1E0-48B7-88A2-C7A61767B3D7}",
"version": "4.0.8482.1"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{8678BA04-D161-45BE-ACA4-CC5D13073F35}",
"install_date": "2021-11-26",
"name": "Microsoft Visual C++ 2019 X64 Additional Runtime - 14.24.28127",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /I{8678BA04-D161-45BE-ACA4-CC5D13073F35}",
"version": "14.24.28127"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{8A27C756-BAA0-4F31-8FFF-CF50D4CCBC00}",
"install_date": "2021-02-23",
"name": "BarTender",
"publisher": "Seagull Scientific",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /I{8A27C756-BAA0-4F31-8FFF-CF50D4CCBC00}",
"version": "11.2.3"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{8BE875AE-2A3C-46C1-AD46-5548B86127FA}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=101173",
"install_date": "2021-02-23",
"name": "Microsoft SQL Server 2014 RsFx Driver",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /I{8BE875AE-2A3C-46C1-AD46-5548B86127FA}",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{90160000-007E-0000-1000-0000000FF1CE}",
"install_date": "2022-10-01",
"name": "Office 16 Click-to-Run Licensing Component",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /I{90160000-007E-0000-1000-0000000FF1CE}",
"version": "16.0.15629.20156"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{90160000-008C-0000-1000-0000000FF1CE}",
"install_date": "2022-10-01",
"name": "Office 16 Click-to-Run Extensibility Component",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /X{90160000-008C-0000-1000-0000000FF1CE}",
"version": "16.0.15629.20118"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{90160000-008C-040C-1000-0000000FF1CE}",
"install_date": "2022-10-01",
"name": "Office 16 Click-to-Run Localization Component",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /X{90160000-008C-040C-1000-0000000FF1CE}",
"version": "16.0.15629.20118"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{90C6971F-ABF1-4FBF-BD98-24F14C5F5AB4}",
"install_date": "2022-04-26",
"name": "Contr├┤le dÔÇÖint├®grit├® du PC Windows",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{90C6971F-ABF1-4FBF-BD98-24F14C5F5AB4}",
"version": "3.6.2204.08001"
},
{
"arch": "x86_64",
"comments": "Caution. Removing this product might prevent some applications from running.",
"from": "registry",
"guid": "{929FBD26-9020-399B-9A7A-751D61F0B942}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=133405",
"install_date": "2021-02-23",
"name": "Microsoft Visual C++ 2013 x64 Additional Runtime - 12.0.21005",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /X{929FBD26-9020-399B-9A7A-751D61F0B942}",
"version": "12.0.21005"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{9D93D367-A2CC-4378-BD63-79EF3FE76C78}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=191752",
"install_date": "2021-02-23",
"name": "Microsoft SQL Server 2012 Native Client ",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{9D93D367-A2CC-4378-BD63-79EF3FE76C78}",
"version": "11.4.7462.6"
},
{
"arch": "x86_64",
"comments": "Caution. Removing this product might prevent some applications from running.",
"from": "registry",
"guid": "{A749D8E6-B613-3BE3-8F5F-045C84EBA29B}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=133405",
"install_date": "2021-02-23",
"name": "Microsoft Visual C++ 2013 x64 Minimum Runtime - 12.0.21005",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /X{A749D8E6-B613-3BE3-8F5F-045C84EBA29B}",
"version": "12.0.21005"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{ACC530B8-B6B4-40D6-B59B-152468CF47D0}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=154582",
"install_date": "2021-02-23",
"name": "SQL Server 2014 Database Engine Shared",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /I{ACC530B8-B6B4-40D6-B59B-152468CF47D0}",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{BAF67399-85CD-4555-9B49-1F80EB921C35}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=230480",
"install_date": "2021-02-23",
"name": "Microsoft SQL Server 2014 Express LocalDB ",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{BAF67399-85CD-4555-9B49-1F80EB921C35}",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{BD1CD96B-FE4B-4EAE-83D4-6EF55AB5779C}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=154582",
"install_date": "2021-02-23",
"name": "SQL Server 2014 Common Files",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /I{BD1CD96B-FE4B-4EAE-83D4-6EF55AB5779C}",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{C18B132E-4032-4425-826A-24B1CA9DFF0C}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=230480",
"install_date": "2021-12-06",
"name": "Microsoft SQL Server 2012 Express LocalDB ",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{C18B132E-4032-4425-826A-24B1CA9DFF0C}",
"version": "11.4.7001.0"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{CECCBAE9-1880-411E-9D28-8E562F6DAAE2}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=TestMSI",
"install_date": "2021-12-06",
"name": "Microsoft System CLR Types for SQL Server 2012 (x64)",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{CECCBAE9-1880-411E-9D28-8E562F6DAAE2}",
"version": "11.4.7001.0"
},
{
"arch": "x86_64",
"comments": "Client Management",
"from": "registry",
"guid": "{E0BA6242-E142-44E6-930F-B62CCD4A8F92}",
"install_date": "2021-02-23",
"name": "Workplace Power Settings",
"publisher": "Fujitsu Technology Solutions",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{E0BA6242-E142-44E6-930F-B62CCD4A8F92}",
"url_info_about": "http://ts.fujitsu.com/manageability",
"version": "2.21.0031"
},
{
"arch": "x86_64",
"comments": "GLPI Agent 1.4",
"from": "registry",
"guid": "{E1BE6C18-6BF4-1014-844A-F1F114E3EA24}",
"helplink": "https://glpi-project.org/discussions/",
"install_date": "2022-10-12",
"name": "GLPI Agent 1.4",
"publisher": "Teclib'",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{E1BE6C18-6BF4-1014-844A-F1F114E3EA24}",
"url_info_about": "https://glpi-project.org/",
"version": "1.4"
},
{
"arch": "x86_64",
"from": "registry",
"guid": "{EBB05812-AB75-4928-8903-E0EC1570BFCB}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=101173",
"install_date": "2021-02-23",
"name": "Microsoft SQL Server 2014 Setup (English)",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{EBB05812-AB75-4928-8903-E0EC1570BFCB}",
"version": "12.3.6024.0"
},
{
"arch": "x86_64",
"from": "registry",
"install_date": "2022-01-07",
"name": "Internet Explorer (64bit)",
"publisher": "Microsoft Corporation",
"version": "11.789.19041.0"
},
{
"arch": "i586",
"comments": "Driver Management",
"from": "registry",
"guid": "DeskUpdate_is1",
"helplink": "https://ts.fujitsu.com/manageability",
"install_date": "2021-06-11",
"name": "DeskUpdate",
"publisher": "Fujitsu Client Computing Limited",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files (x86)\\Fujitsu\\DeskUpdate\\unins000.exe\"",
"version": "5.2.27.0",
"version_major": "5",
"version_minor": "2"
},
{
"arch": "i586",
"from": "registry",
"guid": "Google Chrome",
"install_date": "2022-10-12",
"name": "Google Chrome",
"publisher": "Google LLC",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files\\Google\\Chrome\\Application\\106.0.5249.103\\Installer\\setup.exe\" --uninstall --channel=stable --system-level --verbose-logging",
"version": "106.0.5249.103"
},
{
"arch": "i586",
"from": "registry",
"guid": "InstallShield_{3E1C73AF-C195-436E-8065-00A0CFC0C196}",
"install_date": "2021-11-26",
"name": "Zebra 123Scan (64bit)",
"publisher": "Zebra Technologies",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files (x86)\\InstallShield Installation Information\\{3E1C73AF-C195-436E-8065-00A0CFC0C196}\\setup.exe\" -runfromtemp -l0x0409 -removeonly",
"url_info_about": "www.zebra.com/123scan",
"version": "5.03.0014"
},
{
"arch": "i586",
"from": "registry",
"guid": "InstallShield_{664FF6D5-07C0-405D-9D3B-5697A9B62E1C}",
"install_date": "2021-11-26",
"name": "Zebra CoreScanner Driver (64bit)",
"publisher": "Zebra Technologies",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files (x86)\\InstallShield Installation Information\\{664FF6D5-07C0-405D-9D3B-5697A9B62E1C}\\setup.exe\" -runfromtemp -l0x0409 -removeonly",
"url_info_about": "www.zebra.com/scannersdkforwindows",
"version": "3.07.0004"
},
{
"arch": "i586",
"from": "registry",
"guid": "Microsoft Edge",
"install_date": "2022-10-12",
"name": "Microsoft Edge",
"no_remove": true,
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files (x86)\\Microsoft\\Edge\\Application\\106.0.1370.42\\Installer\\setup.exe\" --uninstall --msedge --channel=stable --system-level --verbose-logging",
"version": "106.0.1370.42"
},
{
"arch": "i586",
"from": "registry",
"guid": "Microsoft Edge Update",
"install_date": "2022-09-05",
"name": "Microsoft Edge Update",
"system_category": "application",
"version": "1.3.167.21"
},
{
"arch": "i586",
"from": "registry",
"guid": "Microsoft EdgeWebView",
"install_date": "2022-10-09",
"name": "Microsoft Edge WebView2 Runtime",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files (x86)\\Microsoft\\EdgeWebView\\Application\\106.0.1370.37\\Installer\\setup.exe\" --uninstall --msedgewebview --system-level --verbose-logging",
"version": "106.0.1370.37"
},
{
"arch": "i586",
"from": "registry",
"guid": "TeamViewer",
"helplink": "https://www.teamviewer.com",
"install_date": "2022-09-27",
"name": "TeamViewer Host",
"publisher": "TeamViewer",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files (x86)\\TeamViewer\\uninstall.exe\"",
"version": "15.34.4"
},
{
"arch": "i586",
"comments": "Copyright 2017 ZIH Corp. All rights reserved.",
"from": "registry",
"guid": "Zebra Setup Utilities",
"helplink": "http://www.zebra.com/",
"install_date": "2021-02-23",
"name": "Zebra Setup Utilities",
"publisher": "Zebra Technologies",
"system_category": "application",
"uninstall_string": "\"C:\\ProgramData\\{AEE1B40D-5AB2-4A2C-97C4-2F8879269232}\\zsu-1-1-9-1289.exe\" REMOVE=TRUE MODIFY=FALSE",
"version": "1.1.9.1289"
},
{
"arch": "i586",
"from": "registry",
"guid": "{050d4fc8-5d48-4b8f-8972-47c82c46020f}",
"install_date": "2021-02-23",
"name": "Microsoft Visual C++ 2013 Redistributable (x64) - 12.0.30501",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "\"C:\\ProgramData\\Package Cache\\{050d4fc8-5d48-4b8f-8972-47c82c46020f}\\vcredist_x64.exe\" /uninstall",
"version": "12.0.30501.0"
},
{
"arch": "i586",
"comments": "Caution. Removing this product might prevent some applications from running.",
"from": "registry",
"guid": "{13A4EE12-23EA-3371-91EE-EFB36DDFFF3E}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=133405",
"install_date": "2021-03-16",
"name": "Microsoft Visual C++ 2013 x86 Minimum Runtime - 12.0.21005",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /X{13A4EE12-23EA-3371-91EE-EFB36DDFFF3E}",
"version": "12.0.21005"
},
{
"arch": "i586",
"from": "registry",
"guid": "{282975d8-55fe-4991-bbbb-06a72581ce58}",
"install_date": "2021-11-26",
"name": "Microsoft Visual C++ 2015-2019 Redistributable (x64) - 14.24.28127",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "\"C:\\ProgramData\\Package Cache\\{282975d8-55fe-4991-bbbb-06a72581ce58}\\VC_redist.x64.exe\" /uninstall",
"version": "14.24.28127.4"
},
{
"arch": "i586",
"from": "registry",
"guid": "{3204DE95-97D2-4261-A286-98A262E171D4}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=90959",
"install_date": "2021-02-23",
"name": "SQL Server Browser for SQL Server 2014",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{3204DE95-97D2-4261-A286-98A262E171D4}",
"version": "12.3.6024.0"
},
{
"arch": "i586",
"from": "registry",
"guid": "{48E37281-7FBA-41D1-940F-A6FB79D7E320}",
"install_date": "2021-03-16",
"name": "DYMO Connect",
"publisher": "DYMO",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{48E37281-7FBA-41D1-940F-A6FB79D7E320}",
"url_info_about": "http://www.DYMO.com",
"version": "1.3.2.14"
},
{
"arch": "i586",
"from": "registry",
"guid": "{731F6BAA-A986-45A4-8936-7C3AAAAA760B}",
"install_date": "2021-12-23",
"name": "Teams Machine-Wide Installer",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /I{731F6BAA-A986-45A4-8936-7C3AAAAA760B}",
"version": "1.4.0.22976"
},
{
"arch": "i586",
"from": "registry",
"guid": "{AF7E31D6-980C-4788-B80C-47F1837CF44C}",
"install_date": "2021-11-26",
"name": "CodeTwo QR Code Desktop Reader & Generator",
"publisher": "CodeTwo",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{AF7E31D6-980C-4788-B80C-47F1837CF44C}",
"version": "1.1.2.4"
},
{
"arch": "i586",
"from": "registry",
"guid": "{ce085a78-074e-4823-8dc1-8a721b94b76d}",
"install_date": "2021-03-16",
"name": "Microsoft Visual C++ 2013 Redistributable (x86) - 12.0.21005",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "\"C:\\ProgramData\\Package Cache\\{ce085a78-074e-4823-8dc1-8a721b94b76d}\\vcredist_x86.exe\" /uninstall",
"version": "12.0.21005.1"
},
{
"arch": "i586",
"from": "registry",
"guid": "{D5C69738-B486-402E-85AC-2456D98A64E4}",
"install_date": "2021-02-23",
"name": "Assistant Mise à jour de Windows 10",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "\"C:\\Windows10Upgrade\\Windows10UpgraderApp.exe\" /Uninstall",
"version": "1.4.9200.23258"
},
{
"arch": "i586",
"comments": "Caution. Removing this product might prevent some applications from running.",
"from": "registry",
"guid": "{F0C3E5D1-1ADE-321E-8167-68EF0DE699A5}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=146008",
"install_date": "2021-02-23",
"name": "Microsoft Visual C++ 2010 x86 Redistributable - 10.0.40219",
"publisher": "Microsoft Corporation",
"system_category": "application",
"uninstall_string": "MsiExec.exe /X{F0C3E5D1-1ADE-321E-8167-68EF0DE699A5}",
"version": "10.0.40219"
},
{
"arch": "i586",
"from": "registry",
"guid": "{F0E3AD40-2BBD-4360-9C76-B9AC9A5886EA}",
"install_date": "2021-02-18",
"name": "Intel(R) Processor Graphics",
"publisher": "Intel Corporation",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files (x86)\\Intel\\Intel(R) Processor Graphics\\Uninstall\\igxpin.exe\" -uninstall",
"version": "26.20.100.7263"
},
{
"arch": "i586",
"from": "registry",
"guid": "{F132AF7F-7BCA-4EDE-8A7C-958108FE7DBC}",
"install_date": "2021-02-22",
"name": "Realtek High Definition Audio Driver",
"publisher": "Realtek Semiconductor Corp.",
"system_category": "application",
"uninstall_string": "\"C:\\Program Files\\Realtek\\Audio\\HDA\\RtlUpd64.exe\" -r -m -nrg2709",
"version": "6.0.8924.1"
},
{
"arch": "i586",
"comments": "Caution. Removing this product might prevent some applications from running.",
"from": "registry",
"guid": "{F8CFEB22-A2E7-3971-9EDA-4B11EDEFC185}",
"helplink": "http://go.microsoft.com/fwlink/?LinkId=133405",
"install_date": "2021-03-16",
"name": "Microsoft Visual C++ 2013 x86 Additional Runtime - 12.0.21005",
"publisher": "Microsoft Corporation",
"system_category": "system_component",
"uninstall_string": "MsiExec.exe /X{F8CFEB22-A2E7-3971-9EDA-4B11EDEFC185}",
"version": "12.0.21005"
},
{
"arch": "i586",
"from": "registry",
"install_date": "2022-08-09",
"name": "Internet Explorer",
"publisher": "Microsoft Corporation",
"version": "11.789.19041.0"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2022-10-12",
"name": "KB5017262",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2021-03-10",
"name": "KB4562830",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Security Update",
"from": "WMI",
"install_date": "2020-11-18",
"name": "KB4570334",
"release_type": "Security Update",
"system_category": "security_update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2021-02-23",
"name": "KB4577586",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Security Update",
"from": "WMI",
"install_date": "2020-11-19",
"name": "KB4580325",
"release_type": "Security Update",
"system_category": "security_update"
},
{
"arch": "x86_64",
"comments": "Security Update",
"from": "WMI",
"install_date": "2020-11-19",
"name": "KB4586864",
"release_type": "Security Update",
"system_category": "security_update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2021-04-14",
"name": "KB4589212",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Security Update",
"from": "WMI",
"install_date": "2021-02-18",
"name": "KB4598481",
"release_type": "Security Update",
"system_category": "security_update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2021-07-16",
"name": "KB5000736",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2022-02-10",
"name": "KB5003791",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Security Update",
"from": "WMI",
"install_date": "2022-08-09",
"name": "KB5012170",
"release_type": "Security Update",
"system_category": "security_update"
},
{
"arch": "x86_64",
"comments": "Security Update",
"from": "WMI",
"install_date": "2022-10-12",
"name": "KB5018410",
"release_type": "Security Update",
"system_category": "security_update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2021-11-10",
"name": "KB5006753",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2021-12-15",
"name": "KB5007273",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Security Update",
"from": "WMI",
"install_date": "2022-02-09",
"name": "KB5011352",
"release_type": "Security Update",
"system_category": "security_update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2022-04-13",
"name": "KB5011651",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Security Update",
"from": "WMI",
"install_date": "2022-05-11",
"name": "KB5014032",
"release_type": "Security Update",
"system_category": "security_update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2022-06-14",
"name": "KB5014035",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2022-07-13",
"name": "KB5014671",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2022-08-09",
"name": "KB5015895",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Update",
"from": "WMI",
"install_date": "2022-09-14",
"name": "KB5016705",
"release_type": "Update",
"system_category": "update"
},
{
"arch": "x86_64",
"comments": "Security Update",
"from": "WMI",
"install_date": "2021-09-15",
"name": "KB5005699",
"release_type": "Security Update",
"system_category": "security_update"
}
],
"versionclient": "GLPI-Inventory_v1.4"
},
"deviceid": "DESKTOP-PKHK2B7-2022-10-12-19-32-32",
"itemtype": "Computer",
"partial": true
}
trasher
commented
2 years ago I cannot reproduce on latest GLPI nightly build, your issue should already have been fixed. This is not an agent issue, if problem persists, please open a bug report on GLPI repository, with all requested information (including a json file to reproduce).
Bug reporting acknowledgment
Yes, I read it
Professional support
Yes, I know
Describe the bug
Hello, GLPI Agent don't create computer into GLPI.
The GLPI Agent is correctly created in GLPI, but not the computer.
On the computer, glpi-agent.log contains the following error line : [Wed Oct 12 18:10:21 2022][error] [http client] communication error: 500 Internal Server Error
On the server, php-errors.log contains the following error line : [2022-10-12 18:10:21] glpiphplog.ERROR: *** PHP User Error (256): Column 'manufacturers_id' cannot be null in /var/www/glpi/src/DBmysql.php at line 1961
Test on several computers : same problem Delete agent in GLPI change nothing Reseting rules for import change nothing
To reproduce
Install a new agent Force an inventory
Expected behavior
Creation of a new computer linked with the agent
Operating system
Windows
GLPI Agent version
1.4
GLPI version
10.0.3
GLPIInventory plugin or FusionInventory for GLPI plugin version
1.0.4
Additional context
No response