Adding blogs to multisite doesn't work

  • 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!

Viewing 15 replies - 16 through 30 (of 49 total)

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

    Thread Starter motherswhowork

    (@motherswhowork)

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

    Ok – here is one: https://www.motherswhowork.co.uk/jatest/

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    I get this:

    Error establishing a database connection

    Thread Starter motherswhowork

    (@motherswhowork)

    Error establishing a database connection

    Same here – but I don’t know why this would happen if multisite uses one database…

    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.

    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

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Did you delete some sub-sites?

    Thread Starter motherswhowork

    (@motherswhowork)

    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?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    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).

    Thread Starter motherswhowork

    (@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).

    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..

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    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 ??

    Thread Starter motherswhowork

    (@motherswhowork)

    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.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

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

    Thread Starter motherswhowork

    (@motherswhowork)

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

    Hi,

    Where can I find this?

    Did you delete some sub-sites?

    No subsites have been deleted

    Sites id go from 1-10 but tables go from 1,12,13,14…19 then 110 so it appears that the 1 prefix is being added.

    in the wp-config.php
    $table_prefix = 'wp_1';
    Is this required or optional ?
    Should the wp-config be edited?
    Will it still be possible to access subsites?

    thanks

Viewing 15 replies - 16 through 30 (of 49 total)
  • The topic ‘Adding blogs to multisite doesn't work’ is closed to new replies.