Not sure if you guys know about this but I get the following whn I click anything under statistics menu. Any clues?
[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( * ), ) 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[/code]
[/code]
|