Open-AudIT

Been using OpenAudIT for a while now with no problems. I recently upgraded to Version 08.07.23. I started seeing weird things, error about missing memory tables, and such. I did a fresh, new install of 08.07.23 and am seeing some strange errors still.

When I try to get IE or Firefox version stats I see:

[code]
Fatal Error:

SELECT DISTINCT software_name, software_version, COUNT( * ) AS count_item, round( 100 / ( SELECT count(software_uuid) FROM software, system WHERE software_name = 'Internet Explorer' AND software_timestamp=system_timestamp AND software_uuid=system_uuid ) * COUNT( * ) ,2) AS percentage FROM software, system WHERE software_name='Internet Explorer' AND software_timestamp=system_timestamp AND software_uuid=system_uuid GROUP BY software_version ORDER BY count_item DESC

Table 'openaudit.software' doesn't exist
[/code]

Trying to get memory stats yields the following:
[code]Fatal Error:

SELECT full_system_memory.system_memory, COUNT(*) count_item, round( 100 / ( SELECT count(*) FROM (select *, sum(memory_capacity) AS system_memory FROM memory GROUP BY memory_uuid ) as per_mem ) * COUNT( * ), 2 ) AS percentage FROM (select *, sum(memory_capacity) AS system_memory FROM memory GROUP BY memory_uuid, memory_timestamp) AS full_system_memory, system WHERE memory_timestamp = system_timestamp and system_uuid = memory_uuid GROUP BY full_system_memory.system_memory ORDER BY count_item DESC

Table 'openaudit.memory' doesn't exist[/code]

All this is after a clean install, new DB and everything. Seems like i messed up somewhere, but this is the third time I did a clean install. Any thoughts?
Thanks very much

_________________
Server Info:
OS : Windows 2003, Apache 2.0.59, PHP 5.2.5
Auditing: 250 machines, 7 servers
LDAP: Active Directory

I just did a TOTAL new install once again, new folder, new config files, new DB using 08.07.23. Same issues with missing tables. What am i doing wrong here?

_________________
Server Info:
OS : Windows 2003, Apache 2.0.59, PHP 5.2.5
Auditing: 250 machines, 7 servers
LDAP: Active Directory

I fixed the issue.

I restored to an older database structure with no data. I ran the upgrade script, which gave me an error

[code]Upgrading to 08.07.23. Query failed: ALTER TABLE `memory` ADD COLUMN `memory_tag` varchar(256) NOT NULL default " AFTER 'memory_speed' Column length too big for column 'memory_tag' (max=255); use BLOB instead[/code]

I edited the upgrade.php file around line 386 to read "ALTER TABLE `memory` ADD COLUMN `memory_tag` varchar(255)". The upgrade finally worked, the tables are all there, and I'm happy again. Not sure if the 256 is a mistake, I'm not very MYSQL savy.

Cheers

_________________
Server Info:
OS : Windows 2003, Apache 2.0.59, PHP 5.2.5
Auditing: 250 machines, 7 servers
LDAP: Active Directory