Still running OA 2.3.3 waiting on 3.3.0 to upgrade.

I just discovered an issue where a Windows audit is sent by the script, and the system in OA seems to update (audit log is updated with timestamp) but audit is partially captured.  My biggest gripe is that I'm blind about audits failing, so I don't know how pervasive this is, if its inherent to v2.3.3 and whether this has been addressed in recent updates. 

When I try to submit the same audit manually, it seems that one particular software line fails to update the system and the whole audit fails. Even if I comment out this line on the xml file, it fails in another line. I'm not able to put my finger on what it is but it always returns the same error.

Here is what's submitted

<name>FreeSWITCH 64 bit</name>
<uninstall>MsiExec.exe /I{B004A325-1272-47E5-A415-A74E9FC99865}</uninstall>
<installed_on>2019-12-19 13:12:44</installed_on>

A Database Error Occurred

Error Number: 1109

Unknown table 'software' in field list

/* M_devices_components::process_component */ INSERT INTO `software` ( `name`, `version`, `install_date`, `uninstall`, `publisher`, `install_source`, `installed_by`, `installed_on`, `version_padded`, `system_id`, `current`, `first_seen`, `last_seen` ) VALUES ( 'FreeSWITCH (64 bit)', '1.9.0', '20191219', 'MsiExec.exe /I{B004A325-1272-47E5-A415-A74E9FC99865}', 'FreeSWITCH', 'E:\\SoftwareBundle\\Prerequisites\\FreeSWITCH\\', 'domain\user', '2019-12-19 13:12:44', '000000000100000000090000000000', '69', 'y', '2020-01-27 16:51:04', '2020-01-27 16:51:04' )

Filename: E:\WAMP\www\code_igniter\system\database\DB_driver.php

Line Number: 328

SystemID (updated): 

    CommentAdd your comment...

    2 answers


      there was something in the software table preventing me from adding software from a new device, even after I upgraded to 3.2.2.  I truncated the table and everything started working again. Will have to review the data to see how it could have thrown off the logic into thinking there was no 'software' table

      1. Mark Unwin

        Maybe check the number of rows in the database with -

        SELECT COUNT(id) AS `count` FROM software;

        The ID is defined as below.

        `id` int(10) unsigned NOT NULL AUTO_INCREMENT

        If you have (somehow) exceeded that, that would certainly prevent rows being added.

      CommentAdd your comment...

      Unknown table 'software' in field list

      Looks like there is no software table in the database.

      I'd go to http://YOUR_SERVER/open-audit/index.php/test/db_compare 

      That will show you the diff between the schema file and the actual database.

        CommentAdd your comment...