Open-AudIT https://www.open-audit.org/phpBB3/ |
|
[HELP] Error message when searching attributes https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6531 |
Page 1 of 1 |
Author: | bignick0 [ Tue Jun 07, 2016 9:40 pm ] |
Post subject: | [HELP] Error message when searching attributes |
When I attempt to use the "Search Attributes" function from the "All Devices" view, I receive an error message (see below). Here's my system setup: You are running version 1.12.6 of Open-AudIT. Your Host is: openaudit, and it's OS is Linux. Your database platform is mysql (version 5.7.12). Your web server is Apache/2.4.18 (Fedora) PHP/5.6.22 . Your PHP version is 5.6.22 and it's running in timezone America/New_York. And here's the error. Any help? Thank you. A Database Error Occurred Error Number: 1064 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 'partition WHERE a.system_id = partition.system_id AND a.system_id = oa_group_sys' at line 1 /* M_systems::search */ SELECT DISTINCT(a.system_id), a.icon, a.hostname, a.domain, a.man_ip_address, a.man_type, partition.id , partition.current , partition.first_seen , partition.last_seen , partition.serial , partition.name , partition.description , partition.device , partition.hard_drive_index , partition.partition_disk_index , partition.mount_type , partition.mount_point , partition.size , partition.free , partition.used , partition.format , partition.bootable , partition.type FROM system a, oa_group_sys, partition WHERE a.system_id = partition.system_id AND a.system_id = oa_group_sys.system_id AND oa_group_sys.group_id = '1' AND partition.current = 'y' AND ( partition.id LIKE '%isonas%' OR partition.current LIKE '%isonas%' OR partition.first_seen LIKE '%isonas%' OR partition.last_seen LIKE '%isonas%' OR partition.serial LIKE '%isonas%' OR partition.name LIKE '%isonas%' OR partition.description LIKE '%isonas%' OR partition.device LIKE '%isonas%' OR partition.hard_drive_index LIKE '%isonas%' OR partition.partition_disk_index LIKE '%isonas%' OR partition.mount_type LIKE '%isonas%' OR partition.mount_point LIKE '%isonas%' OR partition.size LIKE '%isonas%' OR partition.free LIKE '%isonas%' OR partition.used LIKE '%isonas%' OR partition.format LIKE '%isonas%' OR partition.bootable LIKE '%isonas%' OR partition.type LIKE '%isonas%' ) Filename: models/m_systems.php Line Number: 93 |
Author: | Mark [ Wed Jun 08, 2016 12:04 am ] |
Post subject: | Re: [HELP] Error message when searching attributes |
Thanks for reporting the bug - and my apologies. This has now been fixed for our next release. |
Page 1 of 1 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |