联系官方销售客服
1835022288
028-61286886
错误代码: mysqli_sql_exception #1064 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 ') OR (`dr_1_news`.`catids` <>'' AND JSON_CONTAINS (`dr_1_news`.`catids`->'$[*]',' at line 1 搜索问题 → SELECT `dr_1_news`.*,`dr_1_news_hits`.`hits`,`dr_1_news_hits`.`day_hits`,`dr_1_news_hits`.`week_hits`,`dr_1_news_hits`.`month_hits`,`dr_1_news_hits`.`year_hits`,`dr_1_news_hits`.`day_time`,`dr_1_news_hits`.`week_time`,`dr_1_news_hits`.`month_time`,`dr_1_news_hits`.`year_time` FROM `dr_1_news` LEFT JOIN `dr_1_news_hits` ON `dr_1_news`.`id`=`dr_1_news_hits`.`id` WHERE (`dr_1_news`.`catid` IN () OR (`dr_1_news`.`catids` <>'' AND JSON_CONTAINS (`dr_1_news`.`catids`->'$[*]', '"0"', '$'))) ORDER BY `dr_1_news_hits`.`day_hits` DESC LIMIT 12
调用代码
{hits module=news catid=$catid order=day_hits num=12 cache=43200} {$t.title} {/hits}
作为栏目排行数据,目前只有一个栏目出错了,不清楚是哪篇文章出错,求教
check the manual that corresponds to your MySQL server version
mysql版本需要5.7以上