Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Fri Mar 29, 2024 2:25 am

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
PostPosted: Tue Jun 07, 2016 9:40 pm 
Offline
Newbie

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.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


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

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1964
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 [url=https://opmantek.com]Opmantek[/url].
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 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