4.2K Star 23.9K Fork 7K

GVP铭飞 / MCMS

 / 详情

【5.2.8】静态化生成主页异常问题

已完成
创建于  
2022-06-02 11:10

默认的模板,生成主页异常,查看是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

评论 (1)

wudada 创建了任务

感谢对开源产品的关注,请关注新版本的更新

铭飞 任务状态待办的 修改为已完成
铭飞 里程碑设置为5.2.9

登录 后才可以发表评论

状态
负责人
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
参与者(2)
542665 mingsoft 1714360870
Java
1
https://gitee.com/mingSoft/MCMS.git
git@gitee.com:mingSoft/MCMS.git
mingSoft
MCMS
MCMS

搜索帮助