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

Statistics?
https://www.open-audit.org/phpBB3/viewtopic.php?f=10&t=1835
Page 1 of 1

Author:  slay [ Sat Dec 09, 2006 10:52 am ]
Post subject:  Statistics?

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]

Author:  mikeyrb [ Sat Dec 09, 2006 1:24 pm ]
Post subject: 

Add this line to your include_config.php:
[code]$round_to_decimal_places = '2';[/code]

Author:  slay [ Tue Dec 12, 2006 7:37 am ]
Post subject: 

Did the trick!!!!

Thanks

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/