WordPress.org

Ready to get started?Download WordPress

Forums

Adding blogs to multisite doesn't work (48 posts)

  1. motherswhowork
    Member
    Posted 3 years ago #

    Hi there,

    I have a multisite installation that was recently moved from one directory to the rood directory on my server.

    I have two blogs set up, but for some reason, whenever I try to set up another blog (add new site), even though it is listed under Admin Sites, the backend (wp-admin) reverts back to the main site's wp-admin. The same happens when I try to visit the site on the frontend.

    I have also noticed the following:

    1. on going to the backend of the frontend, the 'Edit Sites' which would normally say the site's name at the end does not show the name at the end.
    2. my plugins that come up for upgrading are not upgrading - I wondered if there is a connection?

    Has anyone experienced this?

    Can anyone shed some light on this?

    Please help!

  2. Need more info.

    Did the domain name change at all?
    IE, was it yourdomainname.com/folder/ and is now yourdomainname.com?
    Subdomains or subfolders?
    Have you upgraded lately?
    Did you try disabling plugins?

  3. motherswhowork
    Member
    Posted 3 years ago #

    Hi Andrea,

    was it yourdomainname.com/folder/ and is now yourdomainname.com?

    Yes

    The structure uses subdirectories, and the only upgrade I've made is the most recent version of WP - but that was a while ago, and the site was working fine after that...

    Did you try disabling plugins?

    Yes - but this doesn't help with the adding of new sites. And when I enabled them again and tried to upgrade automatically, while it says the upgrade has completed fine, when I browse away from the page, I get an alert to upgrade again...now there are 3 plugins waiting fro upgrade...

  4. When you moved the site, did you go through the ENTIRE database and change all the URLs to remove the folder name? And the wp-config file?

  5. motherswhowork
    Member
    Posted 3 years ago #

    Hi Andrea,

    My web designer did the change, but I think it did all of that. I can see in the wp-config file that the directory shows the domain.co.uk as it should be.

    We installed the redirection plugin, which he configured to redirect old links from the /folder/ url to point to the new path on the yourdomain.co.uk path.

  6. The structure uses subdirectories

    I don't think that was what she was asking :) It's easy to get confused!

    Initial install was in http://yourdomain.com/folder with subsites as http://yourdomain.com/folder/site2 and so on.

    You then moved to http://yourdomain.com/ with subsites as http://yourdomain.com/site2 etc etc.

    Either way, though, Andrea's right about checking the whole DB. And the killer? Not all of it is easy to find when you're doing that move. You'll also need to search for 'folder' (i.e. the old folder name) and be VERY careful replacing.

  7. We installed the redirection plugin, which he configured to redirect old links from the /folder/ url to point to the new path on the yourdomain.co.uk path.

    This is probably why you're having issues.

  8. motherswhowork
    Member
    Posted 3 years ago #

    This is probably why you're having issues.

    Really? Will deactivating/deleting the plugin fix the issue?

    Either way, though, Andrea's right about checking the whole DB. And the killer? Not all of it is easy to find when you're doing that move. You'll also need to search for 'folder' (i.e. the old folder name) and be VERY careful replacing.

    Is there a simple find and replace plugin or script that can do this?

  9. motherswhowork
    Member
    Posted 3 years ago #

    Hi Andrea,

    deactivating the Redirection plugin doesn't help...

    When I deactivated, I also updated (Site Admin > Update), but the following error message came up:

    Warning! Problem updating . Your server may not be able to connect to sites running on it. Error message: A valid URL was not provided.

  10. motherswhowork
    Member
    Posted 3 years ago #

    Also (sorry!) whenever I create a new site, WP automatically takes the sites name as the username - not admin, which I am permanently logged in as...I thought I'd mention that in case it gave any clues about what's going on.

  11. motherswhowork
    Member
    Posted 3 years ago #

    Ok, so I've got some information from my web designer who did the initial move an database work:

    Here's what we've done with the DB so far:
    When we moved the site, I did a search / replace on the database across the database on my local machine before re-uploading the database to the server via SSH - with an aim to remove all instances of /cms from the database. This was pretty tricky as the file when opened was around 100MB. As such I wouldn't be able to say if I caught all of the instances, but I certainly covered all of the obvious angles (such as the multisite blog tables / options tables), along with all instances of /cms where site_url and home was set. It's worth perhaps bearing in mind that when your site was broken into, we had to replace the post tables with an older backup, which contains links to /cms areas of the site still (for instance with images etc).

    I have spotted some instances of the /folder in the database, though these are not in the core structural files... these are being replaced as we speak.

  12. That's the thing :( There is not a simple search/replace string that handles this. Yet. I'm sure we'll sort it out one day, but right now, moving WP MultSite is akin to a root canal.

    No, not really, but it will drive you to drink :/

    Look for all instances of /cms AND just cms - Yeah, without the slash. And THAT is why I say you need to do the replace part MANUALLY and look very very carefully at what it is :(

  13. Someone's really going to have to go over your setup with a fine tooth comb. there isn't really anything here that stands out as needing a simple fix.

    When it tries to create a new blog, what address does it give?

  14. motherswhowork
    Member
    Posted 3 years ago #

    Hi Andrea,

    When it tries to create a new blog, what address does it give?

    It gives the url of the blog, but when I click on it it takes me to the wp-admin of the main site...very strange.

  15. I want you to tell *me* what URL it gives. :)

  16. motherswhowork
    Member
    Posted 3 years ago #

  17. No, not where the link goes. Give me the URL to a new blog you just created.

  18. motherswhowork
    Member
    Posted 3 years ago #

    No, not where the link goes. Give me the URL to a new blog you just created.

    Ok - here is one: http://www.motherswhowork.co.uk/jatest/

  19. I get this:

    Error establishing a database connection

  20. motherswhowork
    Member
    Posted 3 years ago #

    Error establishing a database connection

    Same here - but I don't know why this would happen if multisite uses one database...

  21. AWESOME.

    Now we are actually getting somewhere. ;)

    Go look in the database - I suspect the tables for each new blog aren;t getting created. look under Super Admin -> Sites at the list and see the number in front of the /jatest/ blog. Now go look in the db for wp_THATNUMBER_posts.

    If it's not there, that's your problem.

  22. dbldee
    Member
    Posted 3 years ago #

    What does it mean if the tables do not match the site id?
    eg. I see wp_110 but blog ids are from 1-9

    With tables After wp_1, its wp_12-19, then wp_110
    Is this normal or system error?
    thanks

  23. Did you delete some sub-sites?

  24. motherswhowork
    Member
    Posted 3 years ago #

    Go look in the database - I suspect the tables for each new blog aren;t getting created. look under Super Admin -> Sites at the list and see the number in front of the /jatest/ blog. Now go look in the db for wp_THATNUMBER_posts.

    If it's not there, that's your problem.

    Oh good!

    I checked, and no - no tables are being created...very odd.

    Do you know why/how to fix this?

  25. motherswhowork -- Ask your host if your SQL id has the rights to create new DB tables?

    Tell them which ID you use to connect to the DB with (it's listed in wp-config as your username).

  26. motherswhowork
    Member
    Posted 3 years ago #

    Ask your host if your SQL id has the rights to create new DB tables?

    Tell them which ID you use to connect to the DB with (it's listed in wp-config as your username).

    Do you mean as them if my admin login has rights?

    Can I quickly add that whenever I add a site it creates a user with the name of the site - so it I set one up called "test", it creates a user with that name, and admin isn't automatically listed...

    Not sure if that makes a difference to this whole database tables thing..

  27. No. Not your admin login. Your SQL database login. The account listed as username in your wp-config.php

    That account is what WordPress uses to communicate to the database.

    That account needs to be able to create new TABLES. When you add users, you're making new rows. A new table is different. Since it's not making the tables needed, it's likely that your account doesn't have the rights to make tables :)

  28. motherswhowork
    Member
    Posted 3 years ago #

    No. Not your admin login. Your SQL database login. The account listed as username in your wp-config.php

    They are saying that there is no SQL database login!!! 1and1 can be a real nightmare sometimes!

    I've just spent more than an hour on the phone to them, and they don't seem to know or understand what I'm talking about.

  29. You have PHPMyAdmin, right? You should be able to see what permissions you have on that database.

  30. motherswhowork
    Member
    Posted 3 years ago #

    You have PHPMyAdmin, right? You should be able to see what permissions you have on that database.

    Hi,

    Where can I find this?

Topic Closed

This topic has been closed to new replies.

About this Topic