織夢(mèng)DedeCMS 5.7會(huì)員空間的文章列表分頁(yè)顯示不正常,總是顯示0頁(yè)0條記錄錯(cuò)誤。下面告訴大家如何解決這個(gè)問(wèn)題:找到并打開(kāi)include/arc.memberlistview.class.php文件,在里面找到下面這句代碼:
$countQuery = preg_replace("/select[ \r\n\t](.*)[ \r\n\t]from/i","Select count(*) as dd From",$this->sourceSql);修改為:$countQuery = preg_replace("#SELECT[ \r\n\t](.*)[ \r\n\t]FROM#is", 'SELECT COUNT(*) AS dd FROM', $this->sourceSql);$countQuery = preg_replace("#ORDER[ \r\n\t]{1,}BY(.*)#is", '', $countQuery); |
完成。