Dedecms dream weaving article list Title repeated display solution

DEDECMS Weaving dream article list Title repeated display solution ：

Restore today database after , Browse web pages http://www.mimisucai.com/a/wangluobiancheng/list_7_2.html Duplicate list page title found , First map ：

Checked the list call rule , No problem ！

<div class="pleft">
  <div class="place"> <strong> The current position :</strong> {dede:field name='position'/} </div>
  <!-- /place -->
  <div class="listbox">
   <ul class="e2">
    {dede:list pagesize='10'  titlelen='200' }
    <li> [field:array runphp='yes']@me = (empty(@me['litpic']) ? "" : "<a href='{@me['arcurl']}' 

class='preview'><img src='{@me['litpic']}'/></a>"); [/field:array]
     [<b>[field:typelink/]</b>] <a href="[field:arcurl/]" class="title" target="_blank">[field:title/]</a> 

<span class="info"> <small> date ：</small>[field:pubdate function="GetDateTimeMK(@me)"/] <small> Click on ：</small>

[field:click/] <small> Praise ：</small>[field:scores/] </span>
     <p class="intro"> [field:description/]... </p>
    </li>
    {/dede:list}
   </ul>
  </div>
  <!-- /listbox -->
  <div class="dede_pages"><ul class=pagelist>{dede:pagelist listitem="info,index,end,pre,next,pageno,option"listsize="1"/}

</ul></div>
  <!-- /pages -->
 </div>

Some people say , hold dede:list Change to dede:arclist It's nonsense ！ This is not a column Table page title call rule .

I read my article backstage , There is no repetition , So I suspect that there is something wrong with the database .

Check the database , I found that the number of articles in my database is almost twice as many as my actual number ！ It's certain that , It may be when the previous backup is restored , Duplicate database , And then Repeated calls occur .

Some people say , You can enter the backstage of dream weaving - System -SQL Command line tools

Empty three tables

dede_addonarticle The article is attached with a table

dede_archives Document main table

dede_arctiny Document micro table

DELETE FROM dede_addonarticle WHERE aid >= 1 and aid<=200000;

DELETE FROM dede_archives WHERE aid>=1 and aid<=200000;

DELETE FROM dede_arctiny WHERE aid>=1 and aid<=200000;

But now , Using this method, all article pages in the web page will disappear ！

that , Here's what I did , Since there is a problem with database backup , Then take a look at data Folder . open data-backupdata. notice dede_addonarticle There are many files with such prefixes , It must be repeated here , So I looked at the data sheet dede_addonarticle_901_b464f4bc4ffa604f.txt stay 50 Line with dede_addonarticle_1431_9ea6815a4513472f.txt stay 31 The title of the article is repeated in the line , Suggest using EditPlus The text editor opens .

Delete one of the data table article contents , Here I delete 31 Row data .

Then log in to Zhimeng , System , Database restore ,

Then log in to Zhimeng , Generate , Update the column of the article HTML,

Finally, return to the article list page , The title is repeated, and the article only needs one , Solve the problem perfectly ！