• Resolved lichtung

    (@lichtung)


    Hi All,

    I’ve installed WP Multisite successfully and added new sites. Now if I go to their dashboards it is my original site’s dashboard showing up and I only can visit that, but not the sub sites – their name doesn’t show up neither. If I type in the new sub sites’ address, this message shows up:
    “Error establishing a database connection”.

    Can you help me?

    Teréz

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter lichtung

    (@lichtung)

    And below the “Network Admin” name in Dashboard – My Sites, only the original website’s title shows up, no name for the new ones.

    Thread Starter lichtung

    (@lichtung)

    And when I do database repair I have the following:
    wp_9_posts: Table ‘usr_web373_1.wp_9_posts’ doesn’t exist
    wp_9_comments: Table ‘usr_web373_1.wp_9_comments’ doesn’t exist
    wp_9_links: Table ‘usr_web373_1.wp_9_links’ doesn’t exist
    wp_9_options: Table ‘usr_web373_1.wp_9_options’ doesn’t exist
    wp_9_postmeta: Table ‘usr_web373_1.wp_9_postmeta’ doesn’t exist
    wp_9_terms: Table ‘usr_web373_1.wp_9_terms’ doesn’t exist
    wp_9_term_taxonomy: Table ‘usr_web373_1.wp_9_term_taxonomy’ doesn’t exist
    wp_9_term_relationships: Table ‘usr_web373_1.wp_9_term_relationships’ doesn’t exist
    wp_9_commentmeta: Table ‘usr_web373_1.wp_9_commentmeta’ doesn’t exist

    What do I have to do?

    Then the sites did not actually get their tables created.Check the database to make sure the user has *ALL* permissions and is allowed to execute commands.

    Here are some mysql commands to run

    //replace user with username to see what grants you have
    SHOW GRANTS FOR 'user'@'localhost';
    
    //Grant all privs to user (replace user with username) on all tables
    GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost';
    
    //Dont forget to flush after granting
    FLUSH PRIVILEGES;

    Thread Starter lichtung

    (@lichtung)

    Hello,

    thank you! It sais
    #1045 – Access denied for user ‘xxx’@’localhost’ (using password: YES)

    What does it mean?

    Thread Starter lichtung

    (@lichtung)

    Well, ok, now I got every permissions from my host, recreated the multisite thing, but nothing has changed, and the error message is also the same when I try to repair the databases, only the numbers inside the names are increasing.

    wp_10_posts: Table ‘usr_web373_1.wp_10_posts’ doesn’t exist
    wp_10_comments: Table ‘usr_web373_1.wp_10_comments’ doesn’t exist
    wp_10_links: Table ‘usr_web373_1.wp_10_links’ doesn’t exist
    wp_10_options: Table ‘usr_web373_1.wp_10_options’ doesn’t exist
    wp_10_postmeta: Table ‘usr_web373_1.wp_10_postmeta’ doesn’t exist
    wp_10_terms: Table ‘usr_web373_1.wp_10_terms’ doesn’t exist
    wp_10_term_taxonomy: Table ‘usr_web373_1.wp_10_term_taxonomy’ doesn’t exist
    wp_10_term_relationships: Table ‘usr_web373_1.wp_10_term_relationships’ doesn’t exist
    wp_10_commentmeta: Table ‘usr_web373_1.wp_10_commentmeta’ doesn’t exist

    any other ideas?

    Talk to your webhost again. Tell them you are using multisite and the db user cannot create new tables.

    Thread Starter lichtung

    (@lichtung)

    Now we reinstalled the whole thing in a new database and it seem to work. (However if I go to https://www.lichtung.tv/uk/wp-admin, it still offers to repair the database).

    Thread Starter lichtung

    (@lichtung)

    Sorry, it doesn’t. Everything’s fine by now.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Same Dashboard for every sites’ is closed to new replies.