Looks like since the last update I get an error now -
A Database Error Occurred
Error Number: 1146
Table 'openaudit.sys_sw_windows' doesn't exist
SELECT system.system_id, system.hostname, system.man_owner, floor(system.pc_memory / 1024) AS pc_memory, sys_hw_processor.processor_description, system.man_manufacturer, system.man_model, system.man_serial, system.man_icon, date(system.last_seen) AS last_seen, system.last_seen_by, system.man_owner, system.man_os_family, sys_sw_windows.windows_client_site_name, sys_sw_windows.windows_user_name, oa_location.location_name, sys_hw_monitor.monitor_id, sys_hw_monitor.manufacturer, sys_hw_monitor.serial, sys_hw_monitor.model FROM system LEFT JOIN oa_group_sys ON system.system_id = oa_group_sys.system_id LEFT JOIN sys_sw_windows ON (system.system_id = sys_sw_windows.system_id AND system.timestamp = sys_sw_windows.timestamp) LEFT JOIN sys_hw_processor ON (sys_hw_processor.system_id = system.system_id AND sys_hw_processor.timestamp = system.timestamp) LEFT JOIN sys_hw_monitor ON (sys_hw_monitor.system_id = system.system_id AND sys_hw_monitor.timestamp = system.timestamp) LEFT JOIN oa_location ON (system.man_location_id = oa_location.location_id) WHERE oa_group_sys.group_id = @group AND man_type = 'computer' AND man_class != 'server' ORDER BY system.hostname
Filename: models/m_oa_report.php
Line Number: 219
What needs to be fixed on this?
Thanks
|