[CMS] Template Running Error, click here to learn more.

Exception message: SYS info: MySQL Query Error

Time: 2008-10-27 10:20am
Script:

SQL: select * from hsjmain.products order by comments desc Limit 0,2
Error: Unknown column 'comments' in 'order clause'
Errno.: 1054
Error code: 256
-- Backtrace --
(): templateerror.handler
/var/www/html/hsj/cms/include/lib/kDB/lib/mysql_error.php(61): trigger_error
/var/www/html/hsj/cms/include/lib/kDB/lib/mysql.php(451): require
/var/www/html/hsj/cms/include/lib/kDB/lib/mysql.php(434): mysql.halt
/var/www/html/hsj/cms/include/lib/kDB/lib/mysql.php(1268): mysql.query
/var/www/html/hsj/cms/include/lib/kDB/driver/db.php(38): mysql.execute
/var/www/html/hsj/cms/include/lib/kDB/kDB.php(65): db.execute
/var/www/html/hsj/cms/include/cms.func.php(1340): kdb.execute
/var/www/html/hsj/cms/sysdata/templates_c/%%c_^@templates@kb@kb_list.html(218): cms_sql
/var/www/html/hsj/cms/include/lib/kTemplate/kTemplate.class.php(347): include
/var/www/html/hsj/cms/include/lib/kTemplate/kTemplate.class.php(546): ktemplate._fetch
/var/www/html/hsj/cms/include/admin/publishAdmin.class.php(2183): ktemplate.fetch
/var/www/html/hsj/cms/admin/admin_task.php(453): publishadmin.refreshindex