Support » Fixing WordPress » Enabling Multisite – created database errors – tried to repair w/o success

  • I’m setting up for a multisite installation which resulted in an error message:
    Error establishing a database connection.

    Then I tried to repair the database and got this…
    wp_1_posts: Table ‘bitnami_wordpress.wp_1_posts’ doesn’t exist
    wp_1_comments: Table ‘bitnami_wordpress.wp_1_comments’ doesn’t exist
    wp_1_links: Table ‘bitnami_wordpress.wp_1_links’ doesn’t exist
    wp_1_options: Table ‘bitnami_wordpress.wp_1_options’ doesn’t exist
    wp_1_postmeta: Table ‘bitnami_wordpress.wp_1_postmeta’ doesn’t exist
    wp_1_terms: Table ‘bitnami_wordpress.wp_1_terms’ doesn’t exist
    wp_1_term_taxonomy: Table ‘bitnami_wordpress.wp_1_term_taxonomy’ doesn’t exist
    wp_1_term_relationships: Table ‘bitnami_wordpress.wp_1_term_relationships’ doesn’t exist
    wp_1_termmeta: Table ‘bitnami_wordpress.wp_1_termmeta’ doesn’t exist
    wp_1_commentmeta: Table ‘bitnami_wordpress.wp_1_commentmeta’ doesn’t exist

    Any help would be appreciated

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • check database, are the tables exist?

    I do love multisite… I think Bitnami has a slightly modified process to setup multisite.

    I’ve also noticed the later versions of WordPress sometimes clobbers the database during install or database upgrade.

    I’d recommend reading this first https://codex.wordpress.org/Before_You_Create_A_Network

    If you wish to run your WordPress in a separate directory you’ll want to do this first… This is how I prefer to install WordPress. It’s not usually recommended but… some distro installers insist on installing to a subdirectory so I include this info here…

    https://codex.wordpress.org/Giving_WordPress

    Doing the above will make that install run as if it was installed in the web root directory. Remember also, this has no bearing on the type of install you want. You can still install the multisite as a subdirectory install or a subdomain install.

    My recommendation probably flies in the face of what most people would recommend but I’ve had really good success with version 4.9.8 as the multisite.

    If you want… reinstall your Bitnami distro and then install the https://wordpress.org/plugins/wp-downgrade/ and revert down to 4.9.8.

    I wouldn’t install any themes or plugins other than this one above. Now build your network again following these instructions now.

    https://codex.wordpress.org/Create_A_Network

    Get your network setup, tested and play around for a while. You don’t need to get in a hurry but when you’re comfortable with this and everything works well you can then upgrade the install to the ‘latest, greatest’ version.

    I would recommend a good backup plugin… I always use upDraftPlus myself. Make sure you do a complete backup of all files and the database before you do much anything else including the upgrade.

    WPBeginner and WPMUDev are my go to sites for more info this article might really help you also. https://premium.wpmudev.org/blog/ultimate-guide-multisite/

    wow! thank you for taking the time do such a detailed explanation. I’ll try it this weekend… I did an image of the system before I started… so I’ll just restore it… install the backup plugin and start hacking away.

    Best,
    Wayne

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.