[CMS] Template Running Error, click here to learn more.
Exception message: SYS info: MySQL Query Error
Time: 2015-5-14 10:08am
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(285,244,246,247,245,248,249,250,251,252,253,254,255,256,257,261,262,263,258,264,265,266,259,267,268,260,269,270,271,272) AND USAER_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@usaer@www@news@article.html(286): 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(946): publishAdmin.publishMakeHtml
/home/htdocs/cms/admin/admin_publish.php(523): publishAdmin.publish