<?php
$sql = urlencode('SELECT COUNT(*) as ct,uid FROM `'.\Phpcmf\Service::M()->dbprefix(SITE_ID.'_wenda_comment').'` where uid>10 and DATE_SUB(CURDATE(), INTERVAL 90 DAY) <= date(from_unixtime(inputtime)) GROUP by uid ORDER BY `ct` DESC limit 20');
?>
把錯(cuò)誤日志內(nèi)容發(fā)來看看,方法是:http://help.xunruicms.com/658.html
回復(fù)@官方插件技術(shù)-張均碩
ERROR - 2021-07-16 11:22:44 --> Table 'thinkadmin.dr_1_wenda_comment' doesn't exist
CRITICAL - 2021-07-16 11:22:44 --> Table 'thinkadmin.dr_1_wenda_comment' doesn't exist
好像是表前綴有問題,我數(shù)據(jù)庫已經(jīng)改了表前綴,但是這個(gè)插件的表前綴是默認(rèn)的dr
/pc/default/home/wenda/sidebar.html
改成