默认的模板,生成主页异常,查看是sql中又个limit null,导致sql有误
附查询sql;
select
cms_content.id as id,
content_title as title,
content_title as fulltitle,
content_author as author,
content_source as source,
category.category_title as typetitle,
category.id as typeid,
category.category_path as typepath,
category.category_img as typelitpic,
category.category_keyword as typekeyword,
category.top_id as topId,
category.category_parent_ids as parentids,
category.category_type as "type",
(
select
CONCAT(category_path, '/index.html')) as typelink,
content_description as descrip,
content_hit as hit,
content_type as flag,
cms_content.content_keyword as keyword,
content_img as litpic,
CONCAT(category.category_path, '/', cms_content.id, '.html') as "link",
content_datetime as "date"
from
cms_content
left join cms_category as category on
cms_content.category_id = category.id
where
content_display = 0
and cms_content.del = 0
and (cms_content.category_id = null
or cms_content.category_id in (
select
id
from
cms_category
where
cms_category.del = 0
and FIND_IN_SET(null, CATEGORY_PARENT_IDS)))
order by
cms_content.id desc
limit null