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
|