Support » Multisite » [Resolved] "My Sites" gone after doing clean upload of WordPress files

[Resolved] "My Sites" gone after doing clean upload of WordPress files

  • I found that someone had hacked my site recently, so I was following the list of security protocols to follow. In doing so, I uploaded new WordPress files for all of the following:

    • Main directory
    • wp-admin directory
    • wp-includes directory

    I did NOT upload a fresh version of wp-config.php — saved my previous.

    Now, none of my MU sites are showing up in the “My Sites” drop-down on the menu bar at the top of the page.

    When I go to my Network Admin Dashboard, it DOES show “You have 10 sites”, but there doesn’t appear to be a way to view them from the Network Admin area.

    If I go to one of the sites directly, the WP menu bar at the top of the page still allows me to access that site’s Dashboard, however, all the users who should be assigned to that site are completely gone. It’s this way across the MU network.

    I attempted the solution in this thread of commenting-out lines 699 and 700 of wp-includes/user.php and that did not solve the problem.

Viewing 15 replies - 1 through 15 (of 16 total)
  • Are they still listed in your database in the wp_sites table?

    I don’t seem to have a “wp_sites” table. I have a “wp_site” table — that shows 1 record, and that’s my main domain.

    However, there are records for each of the other sites, still in the database. i.e.- wp_1_table, wp_2_table, etc.

    wp_blogs, I’m sorry. My brain was dead last night, clearly.

    Yes, they’re all still listed in wp_blogs.

    Have you tried renaming plugins and mu-plugins folders to OLD-plugins etc? Just to see if that’s the issue?

    Yes, that is not the issue. (Just tried it again for good measure.)

    Were you using version 3.3.1 before?

    Yes. Seriously, the ONLY thing that changed was that I uploaded the new versions of the files I listed above. Before, worked fine, and after, kaput. 🙂

    [Removed this post — issue no longer present.]

    Okay! So, I’m still not sure exactly what the problem is — in fact, I’m still HAVING problems, but I’m getting closer to a solution.

    I gave the “move plugins to another directory and move them back in one-by-one” thing another try and lo-and-behold! some of the issues suddenly started to become clearer.

    First off, a plugin (Pending Posts Indicator) was messing with the “Sites” menu on the Network Admin page. Not sure why that started happening now, when it’s never been a problem before, but it’s off now.

    Next, somehow the list of users that is assigned to each site was removed. So I could access each site because I’m a super-admin, but they weren’t showing up in the “My Sites” drop down on the menu bar because me, and everyone else, had been removed from every site except home.

    Here’s where it gets really mysterious — now that I’ve figured all this out, I’m still having a problem with the user pages on each sub-site. Here’s what’s occurring:

    1. When viewing “Network Admin > Sites” I see a list of all my sites. I’ve added myself back to a few of them, and I see my name on this list.
    2. However, when I go to any site’s user list, where I’ve been added, it says “2 items” on the page, but NOTHING shows in between the top and bottom rows of the table. So, I see both the top and bottom table bars (showing “Username | Name | Email” etc.) but nothing in between them.
    3. Next, if I go to any site’s “Users > Add New” page, the “Role” box is empty — no “Admin”/”Editor”/”Author”, etc. — just an empty drop-down with nothing in it. This page allows me to add new users, but again, they don’t show up in the Users page.

    So I thought this might help. Here’s an album showing what’s going on with a few pages: http://imgur.com/a/vFF90

    I’ve only seen that when my data serialization got goobered after I did a search/replace in my DB.

    Anyone have any idea how to fix this? I don’t care if the user lists are gone — I can recompile them, since we have a relatively small site. I’m just more concerned about making sure it works properly.

    I have very recent database backups (from before this was an issue) and can maybe replace tables with previous versions, if I knew which ones to use?

    Anyone anyone? Some of our sites are unfortunately crippled until I can fix this 🙁

    Pulling from a backup may not be a bad idea. It could be corrupt settings FROM a plugin…

    If you have a good known backup from before you were hacked, restore that to a different DB and see if you can point wp-config to that and if it all works.

    You MAY be able to copy of the wp_options table from that.

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘[Resolved] "My Sites" gone after doing clean upload of WordPress files’ is closed to new replies.