[CMS] Template Running Error, click here to learn more.
Exception message: SYS info: MySQL Query Error
Time: 2008-10-27 10:21am
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_art.html(305): 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/setting/pager/auto.php(350): ktemplate.fetch
/var/www/html/hsj/cms/include/admin/publishAdmin.class.php(2904): include
/var/www/html/hsj/cms/include/admin/publishAdmin.class.php(2009): publishadmin.publishmakehtml
/var/www/html/hsj/cms/admin/admin_task.php(710): publishadmin.refresh
