Hi all.
After upgrade Open-Audit 1.8.2 to 1.12.6 some report error in some queries.
In system group device list when select Alert the report error are showed;
A Database Error Occurred
Error Number: 1146
Table 'openaudit.oa_alert_log' doesn't exist
/* M_oa_report::get_report */ SELECT oa_alert_log.alert_id, oa_alert_log.system_id, oa_alert_log.timestamp, system.man_ip_address, system.hostname, system.man_description, oa_alert_log.alert_details FROM system, oa_alert_log, oa_group_sys WHERE oa_alert_log.user_id is NULL AND oa_alert_log.system_id = system.system_id AND oa_alert_log.system_id = oa_group_sys.system_id AND oa_group_sys.group_id = @group GROUP BY oa_alert_log.alert_id ORDER BY oa_alert_log.timestamp DESC
Filename: models/m_oa_report.php
Line Number: 223
In system group device list when select Alerts-Software the report error are showed;
A Database Error Occurred
Error Number: 1146
Table 'openaudit.oa_alert_log' doesn't exist
/* M_oa_report::get_report */ SELECT oa_alert_log.alert_id, oa_alert_log.system_id, oa_alert_log.timestamp, system.man_ip_address, system.hostname, system.man_description, oa_alert_log.alert_details FROM system, oa_alert_log, oa_group_sys WHERE oa_alert_log.user_id is NULL AND oa_alert_log.system_id = system.system_id AND oa_alert_log.timestamp > DATE_SUB(NOW(),INTERVAL 100 DAY) AND oa_alert_log.system_id = oa_group_sys.system_id AND oa_alert_log.alert_details LIKE 'software%' AND oa_group_sys.group_id = @group GROUP BY oa_alert_log.alert_id ASC
Filename: models/m_oa_report.php
Line Number: 223
In system group device list Device Detais are duplicated, one option works, the other no, I drop in mysql the incorrect option.
When I choose Instaled - Software the error below are showed:
Error Number: 1146
Table 'openaudit.sys_sw_windows' doesn't exist
/* M_oa_report::get_report */ SELECT system.system_id, system.hostname, system.man_status, sys_sw_software.software_name, sys_sw_software.software_installed_by, date(sys_sw_software.software_installed_on) as software_installed_on, sys_sw_software.software_version, sys_sw_windows.windows_user_name, date(sys_sw_software.first_timestamp) as first_timestamp FROM system LEFT JOIN sys_sw_windows ON (system.system_id = sys_sw_windows.system_id AND system.timestamp = sys_sw_windows.timestamp) LEFT JOIN sys_sw_software ON (system.system_id = sys_sw_software.system_id and system.first_timestamp < sys_sw_software.first_timestamp) WHERE sys_sw_software.software_name = (SELECT software_name FROM sys_sw_software WHERE software_id = '157646' LIMIT 1) AND date(sys_sw_software.first_timestamp) = date('0') GROUP BY system.system_id
Filename: models/m_oa_report.php
Line Number: 223
Any idea how can I fix the errors?
Thanks.