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

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

Problem with Perl or SQL after instalation

I was install Inventory server (2.3) on Debian 8 and try to connect using Windows Agent. In web application is only record with ID. Server and client connect without problems. In apache log i was found this:

[Tue Nov 20 12:48:04.803998 2018] [mpm_prefork:notice] [pid 5388] AH00163: Apache/2.4.10 (Debian) mod_perl/2.0.9dev P
erl/v5.20.2 configured -- resuming normal operations
[Tue Nov 20 12:48:04.804010 2018] [core:notice] [pid 5388] AH00094: Command line: '/usr/sbin/apache2'
DBD::mysql::st execute failed: Table 'ocsweb.software_categories' doesn't exist at /usr/local/share/perl/5.20.2/Apach
e/Ocsinventory/Interface/SoftwareCategory.pm line 48.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/share/perl/5.20.2/Apache/Ocsinventory
/Interface/SoftwareCategory.pm line 50.
DBD::mysql::st execute failed: Table 'ocsweb.assets_categories' doesn't exist at /usr/local/share/perl/5.20.2/Apache/
Ocsinventory/Interface/AssetCategory.pm line 78.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/share/perl/5.20.2/Apache/Ocsinventory
/Interface/AssetCategory.pm line 80.
DBD::mysql::db do failed: Unknown column 'CATEGORY_ID' in 'field list' at /usr/local/share/perl/5.20.2/Apache/Ocsinve
ntory/Server/Inventory/Update/Hardware.pm line 49.
DBD::mysql::st execute failed: Table 'ocsweb.software_categories' doesn't exist at /usr/local/share/perl/5.20.2/Apach
e/Ocsinventory/Interface/SoftwareCategory.pm line 48.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/share/perl/5.20.2/Apache/Ocsinventory
/Interface/SoftwareCategory.pm line 50.
DBD::mysql::st execute failed: Table 'ocsweb.assets_categories' doesn't exist at /usr/local/share/perl/5.20.2/Apache/
Ocsinventory/Interface/AssetCategory.pm line 78.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/share/perl/5.20.2/Apache/Ocsinventory
/Interface/AssetCategory.pm line 80.
DBD::mysql::db do failed: Unknown column 'CATEGORY_ID' in 'field list' at /usr/local/share/perl/5.20.2/Apache/Ocsinve
ntory/Server/Inventory/Update/Hardware.pm line 49.
DBD::mysql::st execute failed: Table 'ocsweb.software_categories' doesn't exist at /usr/local/share/perl/5.20.2/Apach
e/Ocsinventory/Interface/SoftwareCategory.pm line 48.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/share/perl/5.20.2/Apache/Ocsinventory
/Interface/SoftwareCategory.pm line 50.
DBD::mysql::st execute failed: Table 'ocsweb.assets_categories' doesn't exist at /usr/local/share/perl/5.20.2/Apache/
Ocsinventory/Interface/AssetCategory.pm line 78.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/share/perl/5.20.2/Apache/Ocsinventory
/Interface/AssetCategory.pm line 80.
DBD::mysql::db do failed: Unknown column 'CATEGORY_ID' in 'field list' at /usr/local/share/perl/5.20.2/Apache/Ocsinve
ntory/Server/Inventory/Update/Hardware.pm line 49.


Version mysql = 5.5.62, perl = 5.20.2,

I was try older version newer version but it was problems too. How to resolve this problem?

in OCS Inventory NG server for Unix by (120 points)
edited by

Please log in or register to answer this question.

 
Powered by Question2Answer
...