While allowing multisite network, I’ve got an error.

  • durume

    (@durume)


    5 years, 4 months ago

    Hi all,
    I was trying to create a multisite network adding the scripts to “wp-config.php” as follows:

    // activate subdomain service
define('WP_ALLOW_MULTISITE', true);
define('SUBDOMAIN_INSTALL', true);
define('DOMAIN_CURRENT_SITE', 'psir.shoplic.site');
define('PATH_CURRENT_SITE', '/');
define('SITE_ID_CURRENT_SITE', 1);
define('BLOG_ID_CURRENT_SITE', 1);

    As soon as I uploaded the updated file to my server by ftp connection.

    It says there’s a DB error.

    So I’ve add another code to the file.

    //DB auto repair
define('WP_ALLOW_REPAIR', true);

    And I could easily find ‘DB repair’ button.

    After the DB repair code, I’ve lost the way with the follow messages.
    And the message recommended me to ask this forum.

    wp_1_posts: Table ‘psir.wp_1_posts’ doesn’t exist
    wp_1_comments: Table ‘psir.wp_1_comments’ doesn’t exist
    wp_1_links: Table ‘psir.wp_1_links’ doesn’t exist
    wp_1_options: Table ‘psir.wp_1_options’ doesn’t exist
    wp_1_postmeta: Table ‘psir.wp_1_postmeta’ doesn’t exist
    wp_1_terms: Table ‘psir.wp_1_terms’ doesn’t exist
    wp_1_term_taxonomy: Table ‘psir.wp_1_term_taxonomy’ doesn’t exist
    wp_1_term_relationships: Table ‘psir.wp_1_term_relationships’ doesn’t exist
    wp_1_termmeta: Table ‘psir.wp_1_termmeta’ doesn’t exist
    wp_1_commentmeta: Table ‘psir.wp_1_commentmeta’ doesn’t exist

    May I have a chance to meet a hero, here?

    Thank you in advance!!!

    • This topic was modified 5 years, 4 months ago by James Huff. Reason: moved to Networking WordPress since this is a multisite question

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    5 years, 4 months ago

    Apparently the DB permissions assigned to the WP user didn’t allow it to create new tables. Or some other error occurred in trying to create tables for multisite. Be sure the WP user for the DB has adequate permissions or you’ll have the same problem every time a site is added. This is usually done through phpMyAdmin, but your host may have some alternative UI.

    You could try patching the DB by creating the missing tables. You can copy a table (use the structure only option) from the More>Operations tab of phpMyAdmin. Most of the tables can be empty from the onset, except for wp_1_options. You need data typical of a newly created site in that one.

    You may be better off reverting back to single site, then retry invoking multisite again, this time with adequate DB permissions.

Viewing 1 replies (of 1 total)

The topic ‘While allowing multisite network, I’ve got an error.’ is closed to new replies.