The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

New MultiSite Blog Installation (8 posts)

  1. moodsoft
    Posted 5 years ago #

    I try to follow the directions to activate MultiSite and I keep having issues as to creating the tables for the first site:

    hp_1_posts: Table 'helpme_wdps1.hp_1_posts' doesn't exist
    hp_1_comments: Table 'helpme_wdps1.hp_1_comments' doesn't exist
    hp_1_links: Table 'helpme_wdps1.hp_1_links' doesn't exist
    hp_1_options: Table 'helpme_wdps1.hp_1_options' doesn't exist
    hp_1_postmeta: Table 'helpme_wdps1.hp_1_postmeta' doesn't exist
    hp_1_terms: Table 'helpme_wdps1.hp_1_terms' doesn't exist
    hp_1_term_taxonomy: Table 'helpme_wdps1.hp_1_term_taxonomy' doesn't exist
    hp_1_term_relationships: Table 'helpme_wdps1.hp_1_term_relationships' doesn't exist
    hp_1_commentmeta: Table 'helpme_wdps1.hp_1_commentmeta' doesn't exist

    Is this a bug in 3.0.5? It looks like its not renaming tables and then complains the tables are in error...

  2. moodsoft
    Posted 5 years ago #

    I found that renaming all of the tables listed above fixes the issue. However shouldn't WordPress do this on its own?

  3. Andrew Nacin
    Lead Developer
    Posted 5 years ago #

    I imagine your prefix is hp_.

    In WordPress MU, the first blog would have been installed at hp_1, the second blog at hp_2, etc.

    In WordPress 3.0 multisite -- when not updating from MU -- the first blog is instead at hp_, and the second blog at hp_2. This is actually the single fundamental architectural difference between 3.0 and MU.

    So, if this is a new multisite installation, then you will have added define('MULTISITE', true); to wp-config.php, which will trigger the new version -- i.e. hp_, hp_2. Only if you omitted MULTISITE but WordPress still detected a network would you have issues with hp_1.

    How would that occur? Well, the MULTISITE constant is only for 3.0-originated networks -- it's how WP decides this exact difference in architecture. But in order to detect an MU-originated network, it's looking for a few other constants: VHOST, SUBDOMAIN_INSTALL, and SUNRISE. If any of those are defined, then multisite will be kicked on in the legacy MU mode, and your install will be looking for hp_1_posts.

    Make sense? I'd check out your wp-config.php file and see what's up.

  4. I try to follow the directions to activate MultiSite

    Are you following these directions?

  5. moodsoft
    Posted 5 years ago #

    Yes I followed the directions at http://codex.wordpress.org/Create_A_Network 3 times and always had the exact same issue.

    So not sure what happened, as I said this was a new install of 3.0.5 not an upgrade. WordPress kept complaining that the _1_ blogs did not exist, however once I renamed them it was happy.

    If you like I can paste my wp_config here, so you can see what I'm saying better.

  6. No, don't do that.

    If this is a new install, I'd scrub the whole thing and start over. Empty the DB entirely.

  7. moodsoft
    Posted 5 years ago #

    Ipstenu, I actually did that 2 times and came with the same answer. That is when I decided to rename the tables, and the issue went away :-).

  8. But like nacin pointed out, it *shouldn't* be doing that. Hrm.

Topic Closed

This topic has been closed to new replies.

About this Topic