代码拉取完成,页面将自动刷新
我本地Mysql版本号:5.7.4
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT
cms_content.id AS id,
@rownum := @rownum + 1 AS `index`,
LEFT (content_title, 40) AS title,
content_title AS fulltitle,
content_author AS author,
content_source AS source,
content_details AS content,
category.category_title AS typename,
category.category_id AS typeid,
( CASE category.category_img WHEN '' THEN category.category_img ELSE CONVERT ( JSON_UNQUOTE( JSON_EXTRACT( category.category_img -> '$[0]', '$.path' ) ) USING utf8 ) END ) AS typelitpic,
(SELECT "index.html") AS typelink,
( CASE content_img WHEN '' THEN content_img ELSE CONVERT ( JSON_UNQUOTE( JSON_EXTRACT( content_img -> '$[0]', '$.path' ) ) USING utf8 ) END ) AS litpic,
CONCAT(category.category_path,"/",cms_content.id,".html") AS link,
content_datetime AS date,
content_description AS descrip,
content_hit AS hit,
content_type AS flag,
category_title AS typetitle,
cms_content.content_keyword AS keyword
FROM
(SELECT @rownum := 0) r,
cms_content
LEFT JOIN cms_category as category ON content_category_id = category.id
WHERE
content_display=0
and cms_content.app_id=1
and cms_content.id>0
and (content_category_id=149 or content_category_id in
(select id FROM cms_category where cms_category.del=0 and find_in_set(149,CATEGORY_PARENT_ID)))
ORDER BY cms_content.id
LIMIT
6]; nested exception is java.sql.SQLSyntaxErrorException: 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 '> '$[0]', '$.path' ) ) USING utf8 ) END ) AS typelitpic,
(SELECT "index.html"' at line 11
同问,你解决了吗,怎么解决的
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。
我这里测试的情况是不兼容MariaDB,Mysql55也不行,只能用Mysql57,我还是用的最新的版本5.7.29这里才没报错。建议作者把sql代码写通用点,连MariaDB都不能兼容很不方便部署
我也遇到这个问题,怎么解决?
用的数据库是maria db
登录 后才可以发表评论