Multisite connection error

  • venturesday

    (@venturesday)


    2 years, 11 months ago

    Hi,

    I tried setup multisite and got “Error establishing a database connection“

    After repaired, there are still errors:

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

    How do I create those tables?

    My wordpress hosted on Hostinger VPS, and using Cyber Panel to install wordpress.

    Thanks

    • This topic was modified 2 years, 11 months ago by James Huff. Reason: moved to Networking WordPress since this is a multisite issue
Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    2 years, 11 months ago

    Use the phpMyAdmin app to confirm that the tables really do not exist. wp_1_ tables typically belong to the first sub-site you’ve added. That site will be non-functional if its tables are missing. You may as well delete the site, then recreate it. WP should then create the associated tables for you.

    Please make a backup of your current DB before attempting any further changes. Better safe than sorry 😉

    If you prefer, you could manually create the missing tables through phpMyAdmin. Use similar tables that already exist as a guide to what structure each should have. I believe the tables can initially be empty. Except for the options table. There are many required options that are set when you add a site. You could export an existing table. Edit the export file so when it’s imported it’ll create the desired missing table. Review the data in the imported table, some values may be inappropriate for a new site and may need modification or removal.

Viewing 1 replies (of 1 total)

The topic ‘Multisite connection error’ is closed to new replies.

Tags