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 list of articles in the DreamWeaver member space cannot be paginated?

藏色散人
藏色散人Original
2020-01-09 09:55:142655browse

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn