MySQL为URL添加末尾斜杠：WordPress流媒体站HTTPS迁移故障排查

Hey there, sorry to hear you’ve been stuck on this for three days—let’s get this sorted out without needing to dive into complex coding or regex jargon!

The Core Problem #

You’ve already nailed it: your iframe-hosted videos only play when the source URL ends with a trailing slash (/) after migrating to HTTPS. URLs without that final slash fail to load the content.

Simple Solutions (No Advanced Tech Skills Needed) #

1. Check WordPress Permalink Settings First

Start with the easiest fix—make sure your site’s permalinks are set to enforce trailing slashes (this helps with URL consistency across your site):

• Log into your WordPress dashboard
• Go to Settings > Permalinks
• Select any structure that ends with a slash (e.g., "Post name" which uses /%postname%/ by default)
• Click "Save Changes" (this refreshes your site’s URL rules)

2. Use a Code Snippet to Auto-Add Slashes to Iframe URLs

If the issue is specifically with external iframe source URLs, you can use a simple code snippet to automatically append a trailing slash to any iframe src that’s missing one. Here’s how:

• Install the free Code Snippets plugin from the WordPress plugin repository (it’s safe and widely used)
• Once activated, go to Snippets > Add New
• Paste this code into the snippet editor:

function add_trailing_slash_to_iframe_src($content) {
    // Automatically adds a trailing slash to iframe URLs that don't have one
    $content = preg_replace('/src="(https?:\/\/[^"]+)(?<!\/)"/', 'src="$1/"', $content);
    return $content;
}
add_filter('the_content', 'add_trailing_slash_to_iframe_src');

• Name the snippet something like "Fix Iframe Trailing Slash"
• Click "Save and Activate"

This code will scan all the content on your site, find any iframe tags, and add a trailing slash to the src URL if it’s missing—no manual edits required.

3. Bulk Replace Existing Iframe URLs (For Manual Embeds)

If you’ve manually added hundreds of iframe codes to your posts, use a bulk search-and-replace tool to fix them all at once:

• Install the Better Search Replace plugin (another trusted free tool)
• Back up your site’s database first (always do this before bulk edits!)
• Go to Tools > Better Search Replace
• In the "Search for" field, enter a pattern that matches your iframe URLs without the slash. For example, if your embeds look like src="https://example.com/embed/abc123", search for:
  src="https://example.com/embed/([a-zA-Z0-9]+)"
• In the "Replace with" field, enter the same URL with a trailing slash:
  src="https://example.com/embed/$1/"
• Select your site’s database tables (usually just the wp_posts table is enough)
• Check the "Run as dry run" box first to test the changes without making them permanent
• If the dry run shows correct matches, uncheck the box and run the replace

Quick Testing Tip #

Before rolling out any bulk fixes, edit one problematic post manually: add the trailing slash to the iframe’s src URL and confirm the video plays. This confirms the slash is indeed the fix.

内容的提问来源于stack exchange，提问作者Caroline Wirawan