KingCMS地方门户版 v2.2帮助文档

期刊导读

KingCMS 地方门户版系统 V2.2是一套轻巧，快速和安全的建站程序，采用流行的PHP+MySQL开发，其最大的特色是根据目前成熟成型的地方门户网站运营模式而制定的整站程序，应用了大量的AJAX、JSON等流行的信息交互技术和全文检索、负载优化等先进技术，支持前台管理操作和云管理后台批量操作。

用KingCMS地方门户版建立地方门户网站非常简单，因为网站程序默认自带了成..

1055) 数据查询错误：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'focuznet.t1.tid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT t1.tid,t2.id,t2.title,t2.url,t2.date,t3.id FROM king_content_tag_bind t1 LEFT OUTER JOIN (king_content t2,king_content_tag_bind t3) ON t2.id=t3.id WHERE t2.mid=3 and t2.status=1 and t1.id=2593 and t3.tid=t1.tid and t2.id<>2593 GROUP BY t2.id asc LIMIT 1

期刊精彩内容

本期头条

SELECT t1.tid,t2.id,t2.title,t2.url,t2.description,t3.id FROM king_content_tag_bind t1 LEFT OUTER JOIN (king_content t2,king_content_tag_bind t3,king_content_categroy_bind t4) ON t2.id=t3.id and t4.id=t2.id WHERE t4.cid=56 and t2.mid=7 and t2.status=1 and t1.id=2593 and t3.tid=t1.tid and t2.id<>2593 GROUP BY t2.id desc LIMIT 2

本期推荐

SELECT t1.tid,t2.id,t2.title,t2.url,t2.description,t3.id FROM king_content_tag_bind t1 LEFT OUTER JOIN (king_content t2,king_content_tag_bind t3,king_content_categroy_bind t4) ON t2.id=t3.id and t4.id=t2.id WHERE t4.cid=57 and t2.mid=7 and t2.status=1 and t1.id=2593 and t3.tid=t1.tid and t2.id<>2593 GROUP BY t2.id desc LIMIT 3

本期全部【更多】

SELECT t1.tid,t2.id,t2.title,t2.url,t2.description,t3.id FROM king_content_tag_bind t1 LEFT OUTER JOIN (king_content t2,king_content_tag_bind t3,king_content_categroy_bind t4) ON t2.id=t3.id and t4.id=t2.id WHERE t2.mid=7 and t2.status=1 and t1.id=2593 and t3.tid=t1.tid and t2.id<>2593 GROUP BY t2.id asc LIMIT 3