Home > Article > CMS Tutorial > What should I do if the list of articles in the DreamWeaver member space cannot be paginated?
What should I do if the article list in the Dreamweaver member space cannot be paginated?
Solution to the problem that the list of articles in the DreamWeaver space cannot be paginated
Recommended study:梦Weavercms
DEDECMS5.7 member space articles Paging always shows 0 pages and 0 records errors. Give corrections.
Correction method
Open include/arc.memberlistview.class.php
Find
$countQuery = preg_replace("/select[ \r\n\t](.*)[ \r\n\t]from/i","Select count(*) as dd From",$this->sourceSql);
and change it to
$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);
~~
The above is the detailed content of What should I do if the list of articles in the DreamWeaver member space cannot be paginated?. For more information, please follow other related articles on the PHP Chinese website!