<?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ā)來(lái)看看,方法是:http://help.xunruicms.com/658.html
開(kāi)源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!
回復(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
好像是表前綴有問(wèn)題,我數(shù)據(jù)庫(kù)已經(jīng)改了表前綴,但是這個(gè)插件的表前綴是默認(rèn)的dr
/pc/default/home/wenda/sidebar.html
改成
<?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'); ?>開(kāi)源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!