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
|