Unfortunately there was a single stray space character in Open-AudIT 1.8.4 that prevents the processing of an audit result.

We have repackaged 1.8.4 with the fix. It is available as 1.8.4-1.

To manually fix, edit the following file:

Linux

/usr/local/open-audit/code_igniter/application/models/m_hard_drive.php

Windows

c:\xampplite\open-audit\code_igniter\application\models\m_hard_drive.php

 

Edit line 100 and remove the space from between the second $timestamp variable and the backtick `.

Go from this

$sql = "SELECT hard_drive_id FROM sys_hw_hard_drive WHERE system_id = ? AND hard_drive_model = ? AND hard_drive_serial = ? AND hard_drive_index = ? AND hard_drive_size = ? AND (`timestamp` = ? OR `timestamp `= ? ) LIMIT 1";

to this

$sql = "SELECT hard_drive_id FROM sys_hw_hard_drive WHERE system_id = ? AND hard_drive_model = ? AND hard_drive_serial = ? AND hard_drive_index = ? AND hard_drive_size = ? AND (`timestamp` = ? OR `timestamp`= ? ) LIMIT 1";
  • No labels