ERROR *** AGENT => Failed to send Inventory <HTTP Status Code #500>

PluginsOCSInventory-NG / officepack

Retrieve microsoft office keys

GNU General Public License v2.0

15 stars 27 forks source link

ERROR *** AGENT => Failed to send Inventory <HTTP Status Code #500> #55

Closed ebenjbar closed 4 years ago

ebenjbar commented 5 years ago

My configuration is OCS Server v2.6 and OfficePack v3. When I install officepack my clients can't send their inventories. Looking for the problem I have found the issue.

The offipack installation package doesn't create 2 filelds in 'officepack' table. The fields are:

INSTALL
GUID

I have created them and plugin works correctly.

I hope I can help some other people with my find.

ajavor commented 5 years ago

You're right. Missing entry at the end of the file (in the old version of the plugin is present): /usr/share/ocsinventory-reports/ocsreports/extensions/officepack/sql/officepack.php

// Alter data table $ object -> sql_query (" ALTER TABLE officepack ADD COLUMNGUID varchar (255) DEFAULT NULL AFTER OFFICEKEY; ALTER TABLE officepack ADD COLUMNINSTALL int (11) DEFAULT NULL AFTER GUID; ");

fbomj commented 4 years ago

Problem fixed. New release has been published.