[CMS] Template Running Error, click here to learn more.
Exception message: SYS info: MySQL Query Error
Time: 2014-6-4 8:42am
Script:
SQL: SELECT i2.NodeID,i2.ContentID,i2.State,i2.URL,i.IndexID,i.PublishDate,i.Type,i.Sort,i.Pink,co.*, c.* FROM cmsware_content_index i,cmsware_content_index i2 , cmsware_publish_1 c , cmsware_plugin_base_count co where c.IndexID=i2.IndexID AND co.IndexID=i2.IndexID AND (UNIX_TIMESTAMP() >= i.PublishDate) AND i.ParentIndexID=i2.IndexID AND i2.State=1 AND i.State=1 AND i2.Type!=3 AND i.NodeID IN(3,32,180,202,203,204,205,33,113,115,114,116,117,118,119,138,34,102,103,104,181,182,206,207,208,35,125,126,127,128,129,130,131,132,133,134,135,136,137,139,158,159,160,140,210,211,36,106,107,145,209,37,38,120,121,122,123,124,150,212,213,39,105,108,109,110,111,112,214,215,216,217,153,154,155,156,157,166,167,168,161,238,239,240,241,242) AND SchoolID= ORDER BY i.Top DESC,i.Sort DESC,i.PublishDate DESC Limit 0,2
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 i.Top DESC,i.Sort DESC,i.PublishDate DESC Limit 0,2' at line 1
Errno.: 1064
Error code: 256
-- Backtrace --
(): TemplateError.handler
/home/htdocs/cms/include/lib/kDB/lib/mysql_error.php(42): trigger_error
/home/htdocs/cms/include/lib/kDB/lib/mysql.php(120): require
/home/htdocs/cms/include/lib/kDB/lib/mysql.php(111): mysql.halt
/home/htdocs/cms/include/lib/kDB/lib/mysql.php(225): mysql.query
/home/htdocs/cms/include/lib/kDB/driver/db.php(27): mysql.Execute
/home/htdocs/cms/include/lib/kDB/kDB.php(54): db.Execute
/home/htdocs/cms/include/cms.func.php(546): kDB.Execute
/home/htdocs/cms/sysdata/templates_c/%%c_^@templates@uker@article@life@article.html(478): CMS_LIST
/home/htdocs/cms/include/lib/kTemplate/kTemplate.class.php(256): include
/home/htdocs/cms/include/lib/kTemplate/kTemplate.class.php(359): kTemplate._fetch
/home/htdocs/cms/setting/pager/default.php(376): kTemplate.fetch
/home/htdocs/cms/include/admin/publishAdmin.class.php(1637): include
/home/htdocs/cms/include/admin/publishAdmin.class.php(1102): publishAdmin.publishMakeHtml
/home/htdocs/cms/admin/admin_task.php(363): publishAdmin.refresh