Open-AudIT
https://www.open-audit.org/phpBB3/

Multiple flaws.
https://www.open-audit.org/phpBB3/viewtopic.php?f=10&t=2164		 Page 1 of 1
Author:  harner [ Tue Feb 20, 2007 2:12 am ]
Post subject:  Multiple flaws.
Basically, when I click on some of the links in the navigation, I get errors. Unfortunately, they are all different. For example, the first error is under Queries, in All Services. I'm not sure if it's a MySQL issue or permissions. Thanks, guys.


[quote]====
Queries>All Services
====


Fatal Error:

SELECT count(service_id) AS service_count, service_display_name, sd_description FROM service, system, service_details WHERE service_uuid = system_uuid AND service_timestamp = system_timestamp AND sd_display_name = service_display_name GROUP BY service_display_name ORDER BY service_display_name ASC

Table 'service' is marked as crashed and should be repaired



=====


====
Statistics>OS Type
====


Fatal Error:

SELECT system_os_name, system_os_name AS full_system_os_name, COUNT( system_uuid ) AS count_item, round( 100 / (SELECT count(system_uuid) FROM system WHERE system_os_name != '') * COUNT( system_uuid ), ) AS percentage FROM system WHERE (1) GROUP BY system_os_name ORDER BY count_item DESC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS percentage FROM system ' at line 5



=====


====
Statistics>IE Versions
====


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( * ) ,) 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

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS percentage FROM ' at line 12



=====


====
Statistics>Firefox Versions
====


Fatal Error:

SELECT DISTINCT software_name, software_version, COUNT( * ) AS count_item, round( 100 / ( SELECT count(software_uuid) FROM software, system WHERE software_name LIKE 'Mozilla Firefox%' AND software_name NOT LIKE 'Mozilla Firefox Extension%' AND software_timestamp=system_timestamp AND software_uuid=system_uuid ) * COUNT( * ) , ) AS percentage FROM software, system WHERE software_name LIKE 'Mozilla Firefox%' AND software_name NOT LIKE 'Mozilla Firefox Extension%' AND software_timestamp=system_timestamp AND software_uuid=system_uuid GROUP BY software_version ORDER BY count_item DESC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS percentage FROM ' at line 13



=====


====
Statistics>Memory Size
====


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( * ), ) 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

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS percentage FROM (select *, sum(memory_capacity) ' at line 5



=====


====
Statistics>Processor Types
====


Fatal Error:

SELECT processor_name, COUNT(*) count_item, ROUND( 100 / ( SELECT count(*) FROM processor INNER JOIN system ON system_uuid=processor_uuid AND system_timestamp=processor_timestamp ) * COUNT(*) , ) AS percentage FROM processor INNER JOIN system ON system_uuid=processor_uuid AND system_timestamp=processor_timestamp GROUP BY processor_name ORDER BY count_item DESC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS percentage FROM processor INNER JOIN system ON ' at line 10



=====

====
Statistics>Hard Drive
====


Fatal Error:

SELECT hard_drive_size, COUNT(*) AS count_item, ROUND( 100 / ( SELECT count(*) FROM hard_drive, system WHERE system_uuid=hard_drive_uuid AND system_timestamp=hard_drive_timestamp ) * COUNT(*) ,) AS percentage FROM hard_drive, system WHERE system_uuid=hard_drive_uuid AND system_timestamp=hard_drive_timestamp GROUP BY hard_drive_size ORDER BY count_item DESC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS percentage FROM hard_drive, system ' at line 11




=====

====
Statistics>Keys
====


Fatal Error:

SELECT DISTINCT ms_keys_cd_key, COUNT( * ) AS count_item, ROUND( 100 / ( SELECT count(ms_keys_cd_key) FROM ms_keys, system WHERE ms_keys_uuid = system_uuid AND ms_keys_uuid = system_uuid AND ms_keys_timestamp = system_timestamp ) * COUNT( * ) , ) AS percentage,ms_keys_name,ms_keys_release FROM ms_keys, system WHERE ms_keys_uuid = system_uuid AND ms_keys_uuid = system_uuid AND ms_keys_timestamp = system_timestamp AND ms_keys_cd_key != '' GROUP BY ms_keys_cd_key ORDER BY count_item DESC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS percentage,ms_keys_name,ms_keys_release FROM' at line 10
Author:  mikeyrb [ Tue Feb 20, 2007 5:40 am ]
Post subject: 
Without checking too much, I am guessing the stats pages are failing because the following line is missing from your include_config.php file:

$round_to_decimal_places = '2';

The services one is a MySQL error, so google that.
Author:  A_Hull [ Tue Feb 20, 2007 8:29 am ]
Post subject: 
Really, we should set a default value of 2 for those who don't have this set in their config :?
Author:  mikeyrb [ Tue Feb 20, 2007 9:14 am ]
Post subject: 
And we should store the config in the db ;)
Author:  harner [ Mon Feb 26, 2007 11:19 pm ]
Post subject: 
Good news, that did the trick! Thanks Mikey!
Author:  A_Hull [ Sat Mar 03, 2007 2:09 am ]
Post subject: 
[quote="mikeyrb"]And we should store the config in the db ;)
:twisted: Now why didn't I think of that.
Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/