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.9.1 available

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

Error 500 Table ocsweb.softwares doesn't exist

After install the latest build, I have this on client (Agent 2.7.0.1):

COM SERVER => HTTP Post response received <HTTP Status Code #500>

and this on server (MariaDB Server version 5.5.65-MariaDB / 2.7-nightly-2020-08-10):

Mon Aug 10 10:56:26 2020;14784;108;31-GSEMPRINI-2020-08-10-10-49-09;10.31.5.129;OCS-NG_WINDOWS_AGENT_v2.7.0.1;inventory_cache;cache(softwares.NAME)
Mon Aug 10 10:56:26 2020;14784;522;31-GSEMPRINI-2020-08-10-10-49-09;10.31.5.129;OCS-NG_WINDOWS_AGENT_v2.7.0.1;inventory_cache;fault:softwares.NAME

DBD::mysql::db do failed: Table 'ocsweb.softwares' doesn't exist at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Cache.pm line 77.
DBD::mysql::db do failed: Table 'ocsweb.softwares' doesn't exist at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Cache.pm line 79.
DBD::mysql::db do failed: Table 'ocsweb.softwares' doesn't exist at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Update.pm line 96.
DBD::mysql::db do failed: Table 'ocsweb.softwares' doesn't exist at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Cache.pm line 77.
DBD::mysql::db do failed: Table 'ocsweb.softwares' doesn't exist at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Cache.pm line 79.
DBD::mysql::db do failed: Table 'ocsweb.softwares' doesn't exist at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Update.pm line 96.
in OCS Inventory NG server for Unix by (410 points) 1 flag

2 Answers

–2 votes
The table ocsweb.softwares was dropped in the last version of ocs server. I'm using the last nightly version but I didn't have that issue.
by (3.7k points)
0 votes

upgrade from 2.6 to 2.9 same error.

The software table exists and contains the data, but from the GUI I have a blank page.

Error 500 only for new PCs, on these I temporarily set/NoSoftware=1

How can I solve the problem ?

Wanting to go back where I find unix-server ver 2.6?

by (440 points)
 
Powered by Question2Answer
...