404 error – Page not found after migration to localhost. I already updated the sql links and the permalinks. Wp-admin page works perfectly


So basically whats in the title. I migrated the company website to my localhost to implement some changes. First I cloned the repository, then I created the database, and uploaded the sql file. Configured the wp-config.php file. Ran the sql querries to update the links in the databse, restarted everything, and when I go to the local host address it throws an “oops, page not found” error. What’s weirder is that the wp-admin page works perfectly and I can see all the contents of the site in there, but whenever I try to open any page it throws the same “page not found” screen. The links seem to be working well too. And I even added this:

define( 'WP_HOME', 'http://localhost/example/' );
define( 'WP_SITEURL', 'http://localhost/example/' );

To the wp-config.php file. I’m at loss here, because I did everything I usually do to migrate a site but couldn’t get it to work. I searched here for an answer but most, if not all of them suggest the same fixes of:

“Update the urls in the sql” (done)
“Make the .htaccess writable and go to the permalinks page on wp-admin and save changes” (done)
“Update WordPress to the latest version” (I’m not allowed to make such decisions, especially because the site in live runs on an older WordPress, 5.4.1, and it works fine)

For the record, these are the sql querries I ran:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.example.org', 'http://localhost/example') WHERE option_name="home" OR option_name="siteurl";

UPDATE wp_posts SET guid = REPLACE (guid, 'http://www.example.org', 'http://localhost/example');

UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://www.example.org', 'http://localhost/mysite/');

UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://www.example.org', 'http://localhost/example/');

UPDATE wp_posts SET post_content = REPLACE (post_content, 'src="http://www.example.org', 'src="http://localhost/example/');

UPDATE `wp_posts` SET `guid` =  REPLACE( `guid` , 'http://www.example.org' , 'http://localhost/example/' ) WHERE `post_type` = 'attachment';

UPDATE wp_posts SET  guid = REPLACE (guid, 'http://www.example.org', 'http://localhost/example/') WHERE post_type="attachment";

Where “example” is the site im working on, but I cant share due to company policies. Any help would be greatly appreciated.

Alejandro Arturo Pumpido 2 months 2021-06-09T15:06:08-05:00 0 Answers 0 views 0

Leave an answer