[CMS] Template Running Error, click here to learn more.
Exception message: SYS info: MySQL Query Error
Time: 2008-10-27 11:05am
Script:
SQL: SELECT i2.NodeID,i2.ContentID,i2.State,i2.URL,i.IndexID,i.PublishDate,i.Type,i.Sort,i.Pink,co.*, c.* FROM cmsware27_content_index i,cmsware27_content_index i2 , cmsware27_publish_ c , cmsware27_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.PublishDate > ORDER BY i.PublishDate ASC Limit 0,1
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.PublishDate ASC Limit 0,1' at line 1
Errno.: 1064
Error code: 256
-- Backtrace --
(): TemplateError.handler
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql_error.php(42): trigger_error
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(120): require
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(111): mysql.halt
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(225): mysql.query
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/driver/db.php(27): mysql.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/kDB.php(54): db.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/cms.func.php(546): kdb.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/sysdata/templates_c/%%c_^@templates@org.cmsware.demo@photo@content.html(107): CMS_LIST
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(256): include
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(359): ktemplate._fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/admin/publishAdmin.class.php(1196): ktemplate.fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/admin/admin_task.php(250): publishadmin.refreshindex
[ 点击查看源图 ]
Time: 2008-10-27 11:05am
Script:
SQL: SELECT i2.NodeID,i2.ContentID,i2.State,i2.URL,i.IndexID,i.PublishDate,i.Type,i.Sort,i.Pink,co.*, c.* FROM cmsware27_content_index i,cmsware27_content_index i2 , cmsware27_publish_ c , cmsware27_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.PublishDate > ORDER BY i.PublishDate ASC Limit 0,1
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.PublishDate ASC Limit 0,1' at line 1
Errno.: 1064
Error code: 256
-- Backtrace --
(): TemplateError.handler
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql_error.php(42): trigger_error
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(120): require
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(111): mysql.halt
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(225): mysql.query
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/driver/db.php(27): mysql.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/kDB.php(54): db.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/cms.func.php(546): kdb.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/sysdata/templates_c/%%c_^@templates@org.cmsware.demo@photo@content.html(107): CMS_LIST
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(256): include
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(359): ktemplate._fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/admin/publishAdmin.class.php(1196): ktemplate.fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/admin/admin_task.php(250): publishadmin.refreshindex
[CMS] Template Running Error, click here to learn more.
Exception message: SYS info: MySQL Query Error
Time: 2008-10-27 11:05am
Script:
SQL: SELECT i2.NodeID,i2.ContentID,i2.State,i2.URL,i.IndexID,i.PublishDate,i.Type,i.Sort,i.Pink,co.*, c.* FROM cmsware27_content_index i,cmsware27_content_index i2 , cmsware27_publish_ c , cmsware27_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.PublishDate < ORDER BY i.Top DESC,i.Sort DESC,i.PublishDate DESC Limit 0,1
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,1' at line 1
Errno.: 1064
Error code: 256
-- Backtrace --
(): TemplateError.handler
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql_error.php(42): trigger_error
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(120): require
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(111): mysql.halt
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(225): mysql.query
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/driver/db.php(27): mysql.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/kDB.php(54): db.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/cms.func.php(546): kdb.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/sysdata/templates_c/%%c_^@templates@org.cmsware.demo@photo@content.html(129): CMS_LIST
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(256): include
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(359): ktemplate._fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/admin/publishAdmin.class.php(1196): ktemplate.fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/admin/admin_task.php(250): publishadmin.refreshindex
Time: 2008-10-27 11:05am
Script:
SQL: SELECT i2.NodeID,i2.ContentID,i2.State,i2.URL,i.IndexID,i.PublishDate,i.Type,i.Sort,i.Pink,co.*, c.* FROM cmsware27_content_index i,cmsware27_content_index i2 , cmsware27_publish_ c , cmsware27_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.PublishDate < ORDER BY i.Top DESC,i.Sort DESC,i.PublishDate DESC Limit 0,1
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,1' at line 1
Errno.: 1064
Error code: 256
-- Backtrace --
(): TemplateError.handler
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql_error.php(42): trigger_error
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(120): require
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(111): mysql.halt
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(225): mysql.query
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/driver/db.php(27): mysql.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/kDB.php(54): db.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/cms.func.php(546): kdb.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/sysdata/templates_c/%%c_^@templates@org.cmsware.demo@photo@content.html(129): CMS_LIST
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(256): include
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(359): ktemplate._fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/admin/publishAdmin.class.php(1196): ktemplate.fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/admin/admin_task.php(250): publishadmin.refreshindex
[ 点击查看源图 ]
[CMS] Template Running Error, click here to learn more.
Exception message: SYS info: MySQL Query Error
Time: 2008-10-27 11:05am
Script:
SQL: SELECT i2.NodeID,i2.ContentID,i2.State,i2.URL,i.IndexID,i.PublishDate,i.Type,i.Sort,i.Pink,co.*, c.* FROM cmsware27_content_index i,cmsware27_content_index i2 , cmsware27_publish_ c , cmsware27_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.PublishDate < ORDER BY i.Top DESC,i.Sort DESC,i.PublishDate DESC Limit 0,1
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,1' at line 1
Errno.: 1064
Error code: 256
-- Backtrace --
(): TemplateError.handler
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql_error.php(42): trigger_error
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(120): require
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(111): mysql.halt
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(225): mysql.query
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/driver/db.php(27): mysql.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/kDB.php(54): db.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/cms.func.php(546): kdb.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/sysdata/templates_c/%%c_^@templates@org.cmsware.demo@photo@content.html(161): CMS_LIST
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(256): include
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(359): ktemplate._fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/admin/publishAdmin.class.php(1196): ktemplate.fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/admin/admin_task.php(250): publishadmin.refreshindex
Time: 2008-10-27 11:05am
Script:
SQL: SELECT i2.NodeID,i2.ContentID,i2.State,i2.URL,i.IndexID,i.PublishDate,i.Type,i.Sort,i.Pink,co.*, c.* FROM cmsware27_content_index i,cmsware27_content_index i2 , cmsware27_publish_ c , cmsware27_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.PublishDate < ORDER BY i.Top DESC,i.Sort DESC,i.PublishDate DESC Limit 0,1
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,1' at line 1
Errno.: 1064
Error code: 256
-- Backtrace --
(): TemplateError.handler
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql_error.php(42): trigger_error
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(120): require
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(111): mysql.halt
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/lib/mysql.php(225): mysql.query
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/driver/db.php(27): mysql.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kDB/kDB.php(54): db.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/cms.func.php(546): kdb.execute
/home/vhosts/demo.lonmo.com/demoplus/cmsware/sysdata/templates_c/%%c_^@templates@org.cmsware.demo@photo@content.html(161): CMS_LIST
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(256): include
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/lib/kTemplate/kTemplate.class.php(359): ktemplate._fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/include/admin/publishAdmin.class.php(1196): ktemplate.fetch
/home/vhosts/demo.lonmo.com/demoplus/cmsware/admin/admin_task.php(250): publishadmin.refreshindex