织梦会员空间文章列表无法分页的问题解决
织梦会员空间文章列表无法分页的问题解决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);
就可以了
页:
[1]