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

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

Software filter problem with "doesn't" condition

When I do a search to show computers that do not have a certain software, I do not receive any response, regardless of the search software. Via debug I see that the error is:

Unknown column 'HARDWARE_ID' in 'field list'

Unknown column 'software_name.HARDWARE_ID' in 'where clause'

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3

When I do a search to show computers that do not have a certain software, I do not receive any response, regardless of the search software. Via debug I see that the error is:

Select:

SELECT DISTINCT hardware.ID FROM hardware INNER JOIN software on hardware.id = software.hardware_id LEFT JOIN software_name on software_name.id = software.name_id LEFT JOIN software_publisher on software_publisher.id = software.publisher_id LEFT JOIN software_version on software_version.id = software.version_id WHERE software_name.HARDWARE_ID NOT IN (0) GROUP BY hardware.id

Servidor CentOS 8.1.1911

MariaDB 10.3
OCS Server 2.7-nightly-2020-09-07

PHP 7.3.22

How can I solve this problem?
in OCS Inventory NG server for Unix by (160 points)

1 Answer

0 votes
please report this on github

like another user here with a similar issue

https://github.com/OCSInventory-NG/OCSInventory-ocsreports/issues/718

Kind regards

Sokatra
by (13.4k points)
 
Powered by Question2Answer
...