Blog broken after changing Site/Home URL

Question

I have two blogs installed in the domain foo.com:

They different WP installations which share the same domain. Database tables from the /marketing installation use a proper prefix.

By misunderstanding, I changed the Wordpress Address (URL) and Site Address (URL) values in Settings:

enter image description here

I'm 90% sure the old values were the following: http://foo.com/marketing.

So I changed the values to some other one, realised that this breaks the blog, and changed back the values to http://foo.com/marketing.

However the pages remain broken - sometimes they are handled by the other blog, other times they return HTTP 500 because of too many redirects.

I tried setting http://foo.com/marketing everywhere advised - the database, wp-config.php, functions.php. Nothing worked.

There's the possibility that the http://foo.com/marketing value itself is somehow wrong, but the value seems ok to me.

What could I be missing? What solutions could I try?

Could you post the contents of the .htaccess files of both wordpress installations? — Thomas, Jun 29 '15 at 13:08
@Thomas here you go, thank you very much. gist.github.com/anonymous/294a047e61ef1f0a3296 — vemv, Jun 29 '15 at 13:12
It's better to edit your question and paste in the .htaccess files' content, rather than linking somewhere off-site. — Pat J, Jun 29 '15 at 20:27

danhgilmore · Accepted Answer · 2016-04-27 15:09:24Z

If you have access to the MySQL DB, make sure that wp_blogs.domain is correct, and also wp_blogs.path.

Also, run the following to verify the values are correct (assuming WP_OPTIONS is the table holding the options for your main site).

SELECT * from wp_options where option_name = 'siteurl' or option_name = 'home';

1 Answer 1