Subsite Dashboard loading tables from main site

  • Resolved tiofelix

    (@tiofelix)


    10 years, 4 months ago

    I have a MU install that whenever i open a subsite dashboard, it loads the main site info, and by that i mean posts, menus, pages, options, etc.

    For instance: if i try to change a subsite theme, it changes also on the main site and also on all subsites. Like i said, it seems to be loading the main site tables on subsites because i checked the Database and everything seems in order, all subsite tables are there, with all the correct information.

    It happened recently, and i can’t find the reason.

    I suspect of one thing, though: Recently my host updated their servers to work with cloudflare, and they did a hell of change on their DNS tables, and also tried to run a script on all databases to change the wp_options “home_url” and “site” to add a “www.” on the domain urls.

    The problem is… our multisite seems to be the only one having this problem. So i’m not either sure if it’s something on my end or something the host did. Any guesses?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Bet Hannon

    (@bethannon1)

    Can you post urls to the main site & a subsite exhibiting the behavior, so we can take a look?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    and also tried to run a script on all databases to change the wp_options “home_url” and “site” to add a “www.” on the domain urls.

    Oh… Oh NO NO NO Nooooooooo.

    If your host edited your database tables you need a new host. Period.

    Because unless they did it right, unless they did it serialization safe, you are in a world of broken site hurt. There are places where the URL is stored and the absolute length of it is encoded. So https://www.domain.com and domain.com are NOT the same.

    I’m talking https://www.nooooooooooooooo.com/vader.jpg levels here ??

    Please tell me you (or they) have a backup?

    Thread Starter tiofelix

    (@tiofelix)

    Hey, thanks for the help and sorry for the late reply.

    Unfortunately i’m not sure if i’m allowed to post the url here, the company i work on owns it and they have very strict rules about publishing stuff everywhere. I’ll check with my boss later.

    And about the serialization thing, i was aware of that and i even considered that could be the problem.

    Usually whenever i want to change stuff on the database of every WP install, i use this tool.

    I also wanted to ask: If i use this script on the database NOW, would that fix the serialized data and probably solve the problem? I just didn’t do it yet cause i was afraid it could cause even more problems.

    About the backup, we never worried about it because it was just a development installment, and never considered the host would have a failure like that so yeah, learning it the hard way i guess.

    The host might have a backup though, i’ll see if i can ask them one and change the urls by myself using the tool.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    If i use this script on the database NOW, would that fix the serialized data and probably solve the problem?

    It MIGHT. Make a backup first.

    And … yeah. I work for a webhost, and I’m the first one who’ll tell you “Don’t count on your host’s backups for data.” We care about the server first.

    Thread Starter tiofelix

    (@tiofelix)

    Hey there, thanks for the help, i manage to solve the problem.

    They did have a backup and the host even told me what they changed, they actually just tried to run a query to change “siteurl” and “home” on the wp_options, nothing else, so no biggie, i fixed that and then ran the wp recommended script to make the changes (adding a www.)

    Everything seemed to work fine but the problem i mentioned still happened.

    Then i remembered the wp-config.php file holds the main website url on the DOMAIN_CURRENT_SITE constant. I changed the url adding the www. aaaaaand… Presto! the whole network came back to life.

    Like i said, the host now was enforcing only “www.domain” to forward for the website path on their DNS tables so i took that guess.

    Anyway, thanks for all the help, and i hope that if anyone else has the same problem, find their solution with this thread. Thank you all once again.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Subsite Dashboard loading tables from main site’ is closed to new replies.