Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.11.1 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

Error 500 sending inventory from agent


I have OCS Server under Linux (docker) with 2.3.1 version. Agent on Windows computers is Inventory has left of working in all computers, error 500 sending inventory.

It shows the next in activity.log:

Wed Sep  4 07:05:42 2019;44;103;PCXXXXX-2019-09-04-08-03-50;;OCS-NG_WINDOWS_AGENT_v2.3.1.1;prolog;new_deviceid

Wed Sep  4 07:05:42 2019;44;100;PCXXXXX-2019-09-04-08-03-50;;OCS-NG_WINDOWS_AGENT_v2.3.1.1;prolog;accepted

Wed Sep  4 07:05:42 2019;44;311;PCXXXXX-2019-09-04-08-03-50;;OCS-NG_WINDOWS_AGENT_v2.3.1.1;session;started

Wed Sep  4 07:05:50 2019;67;515;PCXXXXX-2019-09-04-08-03-50;;OCS-NG_WINDOWS_AGENT_v2.3.1.1;end;error

I've activated loglevel and it shows now in the error_log of Apache the next:

DBD::mysql::db do failed: Unknown column 'O' in 'field list' at /usr/local/share/perl/5.20.2/Apache/Ocsinventory/Server/Communication.pm line 100.

DBD::mysql::db do failed: Unknown column 'O' in 'field list' at /usr/local/share/perl/5.20.2/Apache/Ocsinventory/Server/Inventory.pm line 70.

Someone can help me please? I don't know why it is happening this now. No changes in server. I don't know if a colleague has added some field in the ocs gui, is it possible?

Not sure, but line 70 is an insert in hardware table and line 100 is an update from same table.

Thanks beforehand.
in OCS Inventory NG server for Unix by (270 points)

Please log in or register to answer this question.

Powered by Question2Answer