Error #1146 when updating URL's

Avatar
  • Answered
Transferring my WordPress site. In phpMyAdmin I opened ipex_posts, then clicked on SQL tab and entered code to replaced old URL's with new URL's. Got #1146 error. Can you check if my database file names are correct and new URL's correct? Used the following to make changes (as extracted and modified from your step 6 in Correcting Image Links: " UPDATE wp_posts SET post_content=(REPLACE (post_content, '','')); "
Avatar
IMH Support Agent 5
Hello, Thank you for your question about transferring your WordPress site. It looks like the database action is replacing the old URL with a Temporary URL. Was the WordPress site URL updated to match that? That could be a source for problems. Best, Christopher M.
Avatar
SpartanD39
Error 1146 in MySQL indicates the selected table you're trying to work with doesn't exist.

If you're running the exact command above, you'll need to change wp_posts in the command to ipex_posts and try again.