Missing Database tables with new Multisite install

  • Resolved inge12

    (@inge12)


    12 years, 7 months ago

    I thought this would be a cinch:
    Installed WordPress via Fantastico Deluxe on a Hostgator account.

    Logged in just fine.
    Followed instructions for multisite install from one of my other installs:

    uploaded sunrise.php into the wp-content directory, because that’s what I have in my working installs.

    Created blogs.dir directory in wp-content directory

    Added lines to wp-config.php as per instructions.
    Created .htaccess file, according to instructions in /public_html directory.

    But when I tried to log into WP, I got an “Error establishing database connection” message.

    With a retry, I got this more informative message:

    Error establishing database connection

    If your site does not display, please contact the owner of this network. If you are the owner of this network please check that MySQL is running properly and all tables are error free.

    Could not find site mm24-7.com. Searched for table wp_blogs in database mm247_wrdp1. Is that right?

    What do I do now? Read the bug report page. Some of the guidelines there may help you figure out what went wrong. If you’re still stuck with this message, then check that your database contains the following tables:

    wp_users
    wp_usermeta
    wp_blogs
    wp_signups
    wp_site
    wp_sitemeta
    wp_registration_log
    wp_blog_versions
    ~~~~~~~~~~~~~
    And sure enough, those tables are all missing.

    What would cause this sort of problem? Could it be a host issue? (We’re having problems with the Weaver theme on another install, and my partner figures it may be a hosting issue, but we don’t know just what questions to ask, etc.

    Oh, yeah, and if it’s not a hosting issue, what do I do about those missing databases. Couldn’t find instructions specific enough for a dummy like me. 🙁 (IOW, I have no idea what options are needed for each of those tables.)

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 7 months ago

    uploaded sunrise.php into the wp-content directory, because that’s what I have in my working installs.

    Unless you have a REASON for the file (like a plugin that needs it) don’t do that.

    Undo it all.

    If you want to use Fantastico to create the base WP build, that’s fine. But after you do that, you need to follow these directions: http://codex.wordpress.org/Create_A_Network

    Andrea Rennick

    (@andrea_r)

    12 years, 7 months ago

    Installed WordPress via Fantastico Deluxe

    this is probably the issue. most one-click in stalls fail to let you create new tables.

    do the manual install. it’s 3 minutes. actually, all you need to do now is make a new db and switch to it.

    Thread Starter inge12

    (@inge12)

    12 years, 7 months ago

    I need instructions re “how to make a new db.” Just creating it won’t make the tables, I’m thinking. I tried the “make new table” option, and there were all sorts of options I didn’t know what to do with. (Sorry!)

    Previously I did follow all the instructions in the Codex. The only thing extra I did was install sunrise.php.

    After Ipstenu’s comment I’m wondering what difference that file actually makes.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 7 months ago

    Just creating it won’t make the tables, I’m thinking.

    Right, you’re NOT making the tables, WordPress will do that.

    1) Create a DB via your control panel
    2) Copy up the WordPress files to your server
    3) Go to yourdomain.com
    4) Follow the directions

    (sunrise.php can do a lot, depending on what’s in it. Delete it)

    Thread Starter inge12

    (@inge12)

    12 years, 7 months ago

    Okay, thanks, Ipstenu 🙂

    That’s enough detail for me, I think. 🙂

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Missing Database tables with new Multisite install’ is closed to new replies.