织梦DEDE会员空间文章列表无法分页的问题怎么办?

DEDECMS5.7会员空间文章分页总是显示0页0条记录错误。给予修正。
修正办法

打开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);

 

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/c7704638f254b20d9dcca127a263a251.html