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 Thu Mar 28, 2024 9:26 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
PostPosted: Tue Feb 19, 2013 8:57 am 
Offline
Newbie

Joined: Mon Feb 18, 2013 12:02 am
Posts: 5
I have successfully ran the audit_windows.vbs file on multiple computers. However I am now unable to add any systems to Open-Audit. Even if I copy and paste the XML file I get at the end this is the error I get. Any suggestions would be AWESOME!! Trying to get this fully functional to deploy at multiple client locations.

"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 ' system WHERE .system_id = system.system_id AND = '' AND system.man_status = 'p' at line 1

SELECT system.system_id, system.type FROM system WHERE system_id = '4' AND system_id in ( SELECT distinct(system.system_id) FROM , system WHERE .system_id = system.system_id AND = '' AND system.man_status = 'production' AND .timestamp = system.timestamp )

Filename: C:\xampp\OAv2\code_igniter\system\database\DB_driver.php

Line Number: 330"


Top
 Profile  
Reply with quote  
PostPosted: Wed Feb 20, 2013 2:42 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
The problem is caused by a bad Group "Select SQL" statement. Go to Admin - Groups - List Groups. Then start with the first group and click the edit button. Look at the "Select SQL" field. The bad one will start with something like this:
[code]SELECT
distinct(system.system_id)
FROM

WHERE... [/code]
Where there is nothing between the FROM and WHERE clause. When you find the bad one go back to the List Groups and delete the group and then try to import your data file again. No guarantees this will work.


Top
 Profile  
Reply with quote  
PostPosted: Wed Feb 20, 2013 3:30 am 
Offline
Newbie

Joined: Mon Feb 18, 2013 12:02 am
Posts: 5
NICE! Thank you very much. That was pretty much what was wrong. I ended up finding the problematic group and deleted it. Once I did that I could add them again. Thanks AGAIN!!


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