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/ |