Exception message:
SYS info: MySQL Query Error
Time: 2008-7-5 7:53am
Script:
SQL: SELECT i.NodeID,i.ContentID,i.State,i.URL,i.IndexID,i.PublishDate,i.Type,i.Sort,i.Pink, c.* FROM cms_content_index i ,cms_publish_1 c where (UNIX_TIMESTAMP() >= i.PublishDate) AND i.IndexID =c.IndexID AND i.State!=-1 AND i.Type=1 AND ( c.Keywords LIKE '%眼霜%' OR c.Keywords LIKE '%倩碧%' OR c.Keywords LIKE '%CLINIQUE%' OR c.Keywords LIKE '%黑眼圈%' OR c.Keywords LIKE '%雅诗兰黛%' OR c.Keywords LIKE '%EsteeLauder%' OR c.Keywords LIKE '%美体小铺%' OR c.Keywords LIKE '%The body shop%' OR c.Keywords LIKE '%契尔氏%' OR c.Keywords LIKE '%kiehl's%' ) AND c.ContentID!= 97328 AND i.PublishDate <1205385736 and c.NodeID in (10) ORDER BY i.Top DESC,i.Sort DESC,i.PublishDate DESC Limit 0,20
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 's%' ) AND c.ContentID!= 97328 AND i.PublishDa
Error code: 256
-- Backtrace --
(): error.handler
/usr/local/app/lady8845/cms/include/lib/kDB/lib/mysql_error.php(42): trigger_error
/usr/local/app/lady8845/cms/include/lib/kDB/lib/mysql.php(120): require
/usr/local/app/lady8845/cms/include/lib/kDB/lib/mysql.php(111): mysql.halt
/usr/local/app/lady8845/cms/include/lib/kDB/lib/mysql.php(225): mysql.query
/usr/local/app/lady8845/cms/include/lib/kDB/driver/db.php(27): mysql.execute
/usr/local/app/lady8845/cms/include/lib/kDB/kDB.php(54): db.execute
/usr/local/app/lady8845/cms/include/cms.func.php(1229): kdb.execute
/usr/local/app/lady8845/cms/sysdata/templates_c/%%c_^@templates@lady8844_001@default@modules@content_xiangguanwenzhang.html(21): cms_search
/usr/local/app/lady8845/cms/sysdata/templates_c/%%c_^@templates@lady8844_001@default@content.html(116): include
/usr/local/app/lady8845/cms/include/lib/kTemplate/kTemplate.class.php(256): include
/usr/local/app/lady8845/cms/include/lib/kTemplate/kTemplate.class.php(359): ktemplate._fetch
/usr/local/app/lady8845/cms/setting/pager/default.php(146): ktemplate.fetch
/usr/local/app/lady8845/cms/include/admin/publishAdmin.class.php(1633): include
/usr/local/app/lady8845/cms/include/admin/publishAdmin.class.php(1098): publishadmin.publishmakehtml
/usr/local/app/lady8845/cms/shell/init.php(434): publishadmin.refresh
/usr/local/app/lady8845/cms/shell/cron.php(733): refreshnodecontent