|
[CMS] Template Running Error, click here to learn more. Exception message: SYS info: MySQL Query Error
Time: 2010-9-1 8:04am
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_ 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.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/www.ourhz.net/CMSware/include/lib/kDB/lib/mysql_error.php(42): trigger_error
/home/vhosts/www.ourhz.net/CMSware/include/lib/kDB/lib/mysql.php(120): require
/home/vhosts/www.ourhz.net/CMSware/include/lib/kDB/lib/mysql.php(111): mysql.halt
/home/vhosts/www.ourhz.net/CMSware/include/lib/kDB/lib/mysql.php(225): mysql.query
/home/vhosts/www.ourhz.net/CMSware/include/lib/kDB/driver/db.php(27): mysql.Execute
/home/vhosts/www.ourhz.net/CMSware/include/lib/kDB/kDB.php(54): db.Execute
/home/vhosts/www.ourhz.net/CMSware/include/cms.func.php(546): kDB.Execute
/home/vhosts/www.ourhz.net/CMSware/sysdata/templates_c/%%c_^@templates@ourhz@sh_index_intro.html(101): CMS_LIST
/home/vhosts/www.ourhz.net/CMSware/include/lib/kTemplate/kTemplate.class.php(256): include
/home/vhosts/www.ourhz.net/CMSware/include/lib/kTemplate/kTemplate.class.php(355): kTemplate._fetch
/home/vhosts/www.ourhz.net/CMSware/include/admin/publishAdmin.class.php(1196): kTemplate.fetch
/home/vhosts/www.ourhz.net/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: 2010-9-1 8:04am
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_ 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.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/www.ourhz.net/CMSware/include/lib/kDB/lib/mysql_error.php(42): trigger_error
/home/vhosts/www.ourhz.net/CMSware/include/lib/kDB/lib/mysql.php(120): require
/home/vhosts/www.ourhz.net/CMSware/include/lib/kDB/lib/mysql.php(111): mysql.halt
/home/vhosts/www.ourhz.net/CMSware/include/lib/kDB/lib/mysql.php(225): mysql.query
/home/vhosts/www.ourhz.net/CMSware/include/lib/kDB/driver/db.php(27): mysql.Execute
/home/vhosts/www.ourhz.net/CMSware/include/lib/kDB/kDB.php(54): db.Execute
/home/vhosts/www.ourhz.net/CMSware/include/cms.func.php(546): kDB.Execute
/home/vhosts/www.ourhz.net/CMSware/sysdata/templates_c/%%c_^@templates@ourhz@sh_index_intro.html(122): CMS_LIST
/home/vhosts/www.ourhz.net/CMSware/include/lib/kTemplate/kTemplate.class.php(256): include
/home/vhosts/www.ourhz.net/CMSware/include/lib/kTemplate/kTemplate.class.php(355): kTemplate._fetch
/home/vhosts/www.ourhz.net/CMSware/include/admin/publishAdmin.class.php(1196): kTemplate.fetch
/home/vhosts/www.ourhz.net/CMSware/admin/admin_task.php(250): publishAdmin.refreshIndex
|
