迁移主机后WordPress菜单、文章及页面重复三倍的技术求助

Hey there, sorry to hear you're stuck with this triplicate content mess after moving to Wealthy Affiliate with your Streamstore theme—total headache, I know. Let's walk through how to diagnose and fix this properly.

First: Rule Out Display Glitches (Not Actual Duplicates) #

Sometimes the backend count or frontend display bugs out due to caching or theme/plugin conflicts, not real duplicate entries. Start here:

• Clear your WordPress backend cache (if you have a caching plugin enabled) and your browser's cache, then refresh the page to check if the counts normalize.
• Temporarily switch to a default WordPress theme like Twenty Twenty-Four. If the menu duplication and page/post counts fix themselves, the problem is likely a bug or misconfiguration in your Streamstore theme.
• Disable all plugins, then check the counts again. If things look right, re-enable plugins one by one to find which one was causing the conflict.

Second: Tackle Real Database Duplicates #

If you've confirmed there are actual duplicate pages/posts in your database (33 total vs 11 visible is a big red flag), you'll need to dig into the database. First, back up your database—this is non-negotiable before making any changes!

1. Access Your Database Tool #

Wealthy Affiliate provides phpMyAdmin or a similar database manager for your WordPress site. Log in and locate your site's database.

2. Identify Duplicate Posts/Pages #

Your pages and posts live in the wp_posts table (swap wp_ for your actual table prefix if you changed it). Use this SQL query to find duplicates grouped by title and content:

SELECT post_title, COUNT(ID) AS duplicate_count
FROM wp_posts
WHERE post_type IN ('post', 'page') AND post_status = 'publish'
GROUP BY post_title, post_content
HAVING duplicate_count > 1;

This will show you which posts/pages are duplicated and how many times.

3. Delete Duplicate Entries #

To keep the original (oldest) version and delete the duplicates, use this query (replace Your Duplicate Page Title with the actual title of the duplicated content):

DELETE FROM wp_posts
WHERE ID NOT IN (
    SELECT MIN(ID)
    FROM wp_posts
    WHERE post_title = 'Your Duplicate Page Title' AND post_type IN ('post', 'page')
    GROUP BY post_title, post_content
) AND post_title = 'Your Duplicate Page Title' AND post_type IN ('post', 'page');

Pro tip: Run a SELECT version of this first (replace DELETE with SELECT *) to make sure you're targeting the right IDs before deleting anything.

4. Fix Duplicate Menus #

Menus can duplicate either because multiple menu sets were created, or the same menu items were added repeatedly:

• Go to Appearance → Menus in your backend. Check if there are multiple copies of your main menu—delete the extras, keeping only the one with the correct structure.
• If it's the same menu with duplicate items, just select the extra entries and click "Remove" to delete them.
• If the menu still displays triplicated on the frontend, try creating a brand new menu, rebuild your navigation items, and set it as your primary menu (replace the old one).

Third: Use Plugins for Easier Bulk Removal #

If SQL queries make you nervous, use a trusted WordPress plugin to handle duplicates safely:

• Duplicate Post: This plugin detects duplicates and lets you bulk delete them (remember to back up first!). It also has tools to manage duplicates if you need to keep copies for testing.
• WP Bulk Delete: Lets you filter posts/pages by title, content, or creation date to find and delete duplicates in bulk.

Fourth: Prevent This From Happening Again #

Three duplicates usually means the migration process was run three times by accident. Next time you migrate, double-check that you only import your database and site files once—avoid repeating the import step if you think something went wrong without verifying first.

内容的提问来源于stack exchange，提问作者Kitty Smith