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

[bug] error for options under "queries"
https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6583
Page 1 of 1

Author:  shanimal [ Thu Feb 02, 2017 5:55 am ]
Post subject:  [bug] error for options under "queries"

here is my enviro:

You are running version 1.12.10 of Open-AudIT.
Your Host is: VENGOA1, and it's OS is Microsoft Windows Server 2008 R2 Standard.
Your database platform is mysql (version 5.1.41).
Your web server is Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 .
Your PHP version is 5.3.1 and it's running in timezone America/New_York.


here is the error I recently ran into. Guess I haven't tries any queries in some time or I would have noticed quicker

A Database Error Occurred

Error Number: 1054

Unknown column 'system.man_type' in 'field list'

/* M_oa_report::get_report */ SELECT system.man_type, system.system_id, system.hostname, date(system.first_timestamp) as first_seen, date(system.last_seen) as last_seen, system.last_seen_by, system.man_model, system.man_manufacturer, system.man_serial, system.man_owner, oa_location.location_name, system.os_family, oa_org.org_name FROM system LEFT JOIN oa_location ON system.man_location_id = oa_location.location_id LEFT JOIN oa_group_sys ON system.system_id = oa_group_sys.system_id LEFT JOIN oa_org ON system.man_org_id = oa_org.org_id WHERE oa_group_sys.group_id = @group AND man_type = '0' GROUP BY system.system_id ORDER BY system.hostname, first_seen, man_manufacturer, man_model, man_serial

Filename: C:\xampplite\open-audit\code_igniter\system\database\DB_driver.php

Line Number: 330


update: just noticed multiple errors, depending on what I select in QUERIES menu

Error Number: 1054

Unknown column 'system.system_id' in 'field list'

/* M_oa_report::get_report */ SELECT system.system_id, system.hostname, system.man_owner, system.man_ip_address, floor(system.pc_memory / 1024) AS pc_memory, processor.description, system.man_model, system.icon, date(system.last_seen) AS last_seen, system.last_seen_by, system.man_owner, system.man_os_family, windows.client_site_name, windows.user_name, oa_location.name FROM system LEFT JOIN oa_group_sys ON (system.system_id = oa_group_sys.system_id) LEFT JOIN windows ON (system.system_id = windows.system_id AND windows.current = 'y') LEFT JOIN processor ON (processor.system_id = system.system_id AND processor.current = 'y') LEFT JOIN oa_location ON (system.man_location_id = oa_location.id) WHERE oa_group_sys.group_id = @group AND man_type = 'computer' AND man_class != 'server'

Filename: C:\xampplite\open-audit\code_igniter\system\database\DB_driver.php

Line Number: 330

Author:  jpa [ Thu Feb 02, 2017 7:05 am ]
Post subject:  Re: [bug] error for options under "queries"

Are these custom queries? The database has gone through a bunch of table and field renames lately. Man_* fields are gone, system_id is id, etc. If they're built in queries you could disable the query and enable again to get updated query definitions. Otherwise you'll need to manually fix stuff.

Author:  Mark [ Tue Feb 07, 2017 7:34 am ]
Post subject:  Re: [bug] error for options under "queries"

Release Notes are your friend :-)
[url]https://community.opmantek.com/display/OA/Release+Notes[/url]

This specific issue is covered in 1.12.8.
[url]https://community.opmantek.com/display/OA/Release+Notes+for+Open-AudIT+v1.12.8[/url]

Author:  shanimal [ Wed Feb 08, 2017 12:29 am ]
Post subject:  Re: [bug] error for options under "queries"

I've never used a custom report or query, the issue was just some old out of the box queries, which I've deleted. Thank you!

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