[HELP] Error message when searching attributes
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.current , partition.first_seen , partition.last_seen , partition.serial , , partition.description , partition.device , partition.hard_drive_index , partition.partition_disk_index , partition.mount_type , partition.mount_point , partition.size , , 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 ( 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 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 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