• Ok so I am using multi-site and I am able to create a site in my network admin user panel but if I have someone go to the wp-signup.php page to create a site it creates the site but when they go to log in there is a database eror that reads like this

    One or more database tables are unavailable. The database may need to be repaired.

    So I clicked on the link that says “repaired” and it gives me the option to have wordpress auto repair the database. (I had to add the code define('WP_ALLOW_REPAIR', true); to the wp-config.php file to even have this option)

    This is what it says on the screen with the option to repair the database.

    One or more database tables are unavailable. To allow WordPress to attempt to repair these tables, press the “Repair Database” button. Repairing can take a while, so please be patient.
    “Repair Database”

    Once I click it it does it’s thing and says.

    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

    here is the following : )

    wp_6_posts: Table ‘kris_wrdp4.wp_6_posts’ doesn’t exist
    wp_6_comments: Table ‘kris_wrdp4.wp_6_comments’ doesn’t exist
    wp_6_links: Table ‘kris_wrdp4.wp_6_links’ doesn’t exist
    wp_6_options: Table ‘kris_wrdp4.wp_6_options’ doesn’t exist
    wp_6_postmeta: Table ‘kris_wrdp4.wp_6_postmeta’ doesn’t exist
    wp_6_terms: Table ‘kris_wrdp4.wp_6_terms’ doesn’t exist
    wp_6_term_taxonomy: Table ‘kris_wrdp4.wp_6_term_taxonomy’ doesn’t exist
    wp_6_term_relationships: Table ‘kris_wrdp4.wp_6_term_relationships’ doesn’t exist
    wp_6_commentmeta: Table ‘kris_wrdp4.wp_6_commentmeta’ doesn’t exist

    Ok so the rest of the story : )
    I am using the template plugin from WPMU Dev (https://premium.wpmudev.org/project/new-blog-template) to copy a default blog template when creating a new site. It works fine when I create them from my admin panel but when I have someone create one through the sign up page this is what happens. My default theme is Thesis which I had to manipulate according to their instructions (https://diythemes.com/thesis/rtfm/modifying-thesis-multisite/) so I could enable it to work with multisite. ummm I guess thats it lol I’ll be working on finding a solution. Any input would be highly appreciated : ) Thanks

  • The topic ‘database error when creating new sites with multisite’ is closed to new replies.