WordPress数据库问题：菜单保存异常、媒体缩略图无法显示

Looks like you’re stuck with two frustrating database-linked WordPress headaches—let’s break down how to tackle them step by step, building on the database root cause you’ve already identified.

First: Confirm & Repair Core Database Table Integrity #

Menu items and media files both rely heavily on the wp_posts and wp_postmeta tables, so let’s start by making sure these tables aren’t corrupted:

• Use your hosting’s database tool (like phpMyAdmin) to access your WordPress database.
• Run this SQL command to scan for table errors:

  CHECK TABLE wp_posts, wp_postmeta, wp_options;
  

• If errors show up, run a repair (note: this works best for MyISAM tables; for InnoDB, use your host’s dedicated repair tool or restore from backup if repair fails):

  REPAIR TABLE wp_posts, wp_postmeta, wp_options;
  

Critical reminder: Always back up your database before running repair commands!

Fixing Menu Save Failures (Pages Turning to Blank Custom Links) #

WordPress stores menu items as nav_menu_item custom posts in wp_posts, with critical connection data in wp_postmeta. When adding a page reverts to a blank Custom Link, it’s almost always because key metadata isn’t saving properly.

Here’s what to check:

• Verify menu item metadata: For each nav_menu_item entry in wp_posts, look in wp_postmeta for these non-negotiable keys:
  • _menu_item_object: Should be page (for page links)
  • _menu_item_object_id: Must match the ID of the page you’re trying to link
  • _menu_item_type: Should be post_type
    If any of these are missing or wrong, that’s why your menu is breaking. Repairing the tables might fix this, but if not, you can manually add the missing meta entries (just make sure to use the correct post ID for the menu item and linked page).
• Check wp_options for menu settings: Look for options named theme_mods_yourthemename or nav_menu_locations—corruption here can also block menu saves.

Fixing Media Library Thumbnail & Frontend Image Display Issues #

Media files are stored as attachment posts in wp_posts, with file path and size data in wp_postmeta. If thumbnails won’t load, corrupted metadata or missing entries are the likely culprits:

• Validate attachment metadata: For each image attachment in wp_posts, confirm wp_postmeta has:
  • _wp_attached_file: The relative path to the image in wp-content/uploads (e.g., 2024/05/my-photo.jpg)
  • _wp_attachment_metadata: A serialized array with image size details (width, height, thumbnail paths). If this is missing or garbled, thumbnails won’t generate.
• Regenerate metadata if needed: If the metadata exists but is invalid, you can use a plugin to regenerate thumbnails (but prioritize table repairs first, since you suspect database issues). Re-uploading images is a last resort.
• Match file paths: Double-check that the actual file in wp-content/uploads matches the path stored in _wp_attached_file—mismatches from migrations or broken uploads will break image display.

Additional Database Checks #

• Confirm user permissions: Ensure your WordPress database user has full permissions (SELECT, INSERT, UPDATE, DELETE, ALTER) for all tables. Missing permissions can block saving changes to menus or media.
• Check collation consistency: Mismatched collations across tables can cause data saving glitches. Make sure all WordPress tables use the same collation (typically utf8mb4_unicode_ci—adjust this in phpMyAdmin if needed).
• Restore from backup: If all else fails, roll back to a recent database backup where menus and media worked correctly—this is often the fastest fix for severe corruption.

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