?a=admin_standings DB Error

[GoogleCodeExporter]

This error appears upon accessing the "?a=admin_standings".

I suggest we just remove or overhaul this completely... API Standings import?

Database error: 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 ') 
ORDER BY sta_value DESC' at line 1
SQL: SELECT * FROM kb3_standings WHERE () ORDER BY sta_value DESC
ERROR [256] SQL error (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 
') ORDER BY sta_value DESC' at line 1
Error on line 46 in file 
/home/webs/podkill.net/sites/kb/common/includes/class.dbnormalquery.php
PHP 5.2.6-1+lenny13 (Linux), EDK 4.0.1 (Crucible)
File: /home/webs/podkill.net/sites/kb/common/includes/class.dbnormalquery.php, 
line: 46, function: trigger_error
File: /home/webs/podkill.net/sites/kb/common/admin/admin_standings.php, line: 
110, class: DBNormalQuery, function: execute
File: /home/webs/podkill.net/sites/kb/common/index.php, line: 293, function: 
include
File: /home/webs/podkill.net/sites/kb/index.php, line: 27, function: include

Board URL - http://kb.podkill.net/ (This is a test killboard and will be 
deleted in the near future)

Original issue reported on code.google.com by wyatt@podkill.net on 7 Dec 2011 at 9:21

[GoogleCodeExporter]

I think this is because your board has no owner. The standings page assumes all 
standings are relative to board owners. Whether an owner is set should be 
checked, though, to avoid this error.

Original comment by kovellia on 8 Dec 2011 at 2:56

[GoogleCodeExporter]

This issue was closed by revision d9090cc56712.

Original comment by kovellia on 12 Dec 2011 at 10:33

• Changed state: Fixed