What's on your network?
It is currently Wed Mar 21, 2018 3:02 pm

All times are UTC + 10 hours

Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: Tue Jun 07, 2016 9:40 pm 

Joined: Sat Jun 04, 2016 3:26 am
Posts: 9
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

Reply with quote  
PostPosted: Wed Jun 08, 2016 12:04 am 
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
Thanks for reporting the bug - and my apologies.
This has now been fixed for our next release.

Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.

Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 10 hours

Who is online

Users browsing this forum: No registered users and 5 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group