Open-AudIT
http://www.open-audit.org/phpBB3/

[help] [solved] Database Error Occured
http://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6029
Page 1 of 1

Author:  lurknyou [ Tue Feb 19, 2013 8:57 am ]
Post subject:  [help] [solved] Database Error Occured

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"

Author:  jpa [ Wed Feb 20, 2013 2:42 am ]
Post subject:  Re: Database Error Occured

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

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.

Author:  lurknyou [ Wed Feb 20, 2013 3:30 am ]
Post subject:  Re: Database Error Occured

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

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/