First, it won't run from the command line full stop. It relies on the CodeIgniter framework and (I think) unless I specifically code to enable command line stuff, no go. Your errors seem weird though, for example: [code]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 = 'pr' at line 1[/code] This should be WHERE system.system_id - note the lack in the error message of the table being referenced (the "system" before the .).
[code]SELECT system.system_id, system.type FROM system WHERE system_id = '8' 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 )[/code] In the SQL is "FROM ," - WTH? This is also very odd. There should (again) be a table name in there.
Maybe check the defined Groups in the web interface and make sure there is an "All Devices" Group. Failing that, I'm not sure what would cause that - maybe try re-downloading and upload the PHP again. The database should be fine. If anyone else has an idea, please do chime in.
_________________ Support and Development hours available from [url=https://opmantek.com]Opmantek[/url]. Please consider a purchase to help make Open-AudIT better for everyone.
|