sql queries not working anymore
Bug #781220 reported by
Julien Martel
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OCS Inventory: OCSReports |
Fix Released
|
High
|
Erwan |
Bug Description
The dynamic groups I created with the 1.x version are not working anymore. When I try to recalculate those groups I got an SQL error message. Same happens if I delete the group and recreate it from the multi-criterias search engine.
Changed in ocsinventory-server: | |
status: | New → Confirmed |
assignee: | nobody → Erwan (airoine) |
Changed in ocsinventory-ocsreports: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Here is an example of SQL query as displayed in the administration console :
1) => select distinct id as HARDWARE_ID from hardware where id not in (select distinct HARDWARE_ID from groups_cache where ( ( GROUP_ID = 1847 OR GROUP_ID = 2731)))
2) => select distinct id as HARDWARE_ID from hardware where id not in (select distinct HARDWARE_ID from devices where ( ( NAME like 'DOWNLOAD' AND IVALUE IN IN (select id from download_enable where fileid=1288341377) )))
That query look correct as far as I can tell.
The result is :
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN (select id from download_enable where fileid=1288341377) ))) and id in (20,23' at line 1