方法:SQL语句;
关键:除question数据表、article数据表、user数据表外,aws_posts_index数据表中的废数据也要删除,否则前台页面垃圾成堆;
删除aws_posts_index这个表中的废数据语句:
delete from aws_posts_index where post_type = 'article' and post_id not in (select id from aws_article);
delete from aws_posts_index where post_type = 'question' and post_id not in (select question_id from aws_question);
delete from aws_posts_index where post_type = 'question' and post_id not in (select question_id from aws_question);
wecenter版本为3.3.0
打赏作者,期待美好
打赏鼓励作者,为网友提供更多更好的测试,也许一瓶水就够了。