Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Sat Mar 30, 2024 1:16 am

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 6 posts ] 
Author Message
 Post subject: Multiple flaws.
PostPosted: Tue Feb 20, 2007 2:12 am 
Offline
Helper

Joined: Fri Aug 25, 2006 12:59 am
Posts: 75
Location: Northeast Pennsylvania
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



Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Tue Feb 20, 2007 5:40 am 
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.


Top
  
Reply with quote  
 Post subject:
PostPosted: Tue Feb 20, 2007 8:29 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
Really, we should set a default value of 2 for those who don't have this set in their config :?


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Tue Feb 20, 2007 9:14 am 
And we should store the config in the db ;)


Top
  
Reply with quote  
 Post subject:
PostPosted: Mon Feb 26, 2007 11:19 pm 
Offline
Helper

Joined: Fri Aug 25, 2006 12:59 am
Posts: 75
Location: Northeast Pennsylvania
Good news, that did the trick! Thanks Mikey!


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Sat Mar 03, 2007 2:09 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
[quote="mikeyrb"]And we should store the config in the db ;)

:twisted: Now why didn't I think of that.

Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 6 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group