Database error after editing the .htaccess file for multisite.

  • endoki

    (@endoki)


    10 years, 7 months ago

    Hi, I was trying to convert my current local WP installation to multisite and after editing the .htacces file as per WordPress instructions, my site is no longer functioning. I am getting an “Error establishing a database connection” error when trying to access the site or the backend. I know I should have made a backup of .htaccess before committing changes but now it is too late for that. Bellow is the error log for when I try to repair the database. Can someone please help me fix this? Thanks in advance.

    hcc_1_posts: Table ‘hcc946.hcc_1_posts’ doesn’t exist
    hcc_1_comments: Table ‘hcc946.hcc_1_comments’ doesn’t exist
    hcc_1_links: Table ‘hcc946.hcc_1_links’ doesn’t exist
    hcc_1_options: Table ‘hcc946.hcc_1_options’ doesn’t exist
    hcc_1_postmeta: Table ‘hcc946.hcc_1_postmeta’ doesn’t exist
    hcc_1_terms: Table ‘hcc946.hcc_1_terms’ doesn’t exist
    hcc_1_term_taxonomy: Table ‘hcc946.hcc_1_term_taxonomy’ doesn’t exist
    hcc_1_term_relationships: Table ‘hcc946.hcc_1_term_relationships’ doesn’t exist
    hcc_1_commentmeta: Table ‘hcc946.hcc_1_commentmeta’ doesn’t exist

Viewing 2 replies - 1 through 2 (of 2 total)
  • mydiskdriveonline

    (@mydiskdriveonline)

    10 years, 7 months ago

    Greetings,

    The default htaccess for NON multisite installs can be found at http://codex.wordpress.org/htaccess

    See if replacing that brings your site back up and then follow http://codex.wordpress.org/Create_A_Network to convert it to multisite.

    Cheerz

    metulburr

    (@metulburr)

    10 years, 7 months ago

    here is an example of my htaccess file after i made it multisite. Make sure that you remove the single site wordpress info on htaccess and not add the multisite to it. 

    metulburr ~ $ cat /var/www/html/.htaccess
RewriteEngine On
RewriteBase /blog/wordpress/
RewriteRule ^index\.php$ - [L]

# add a trailing slash to /wp-admin
RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
RewriteRule . index.php [L]
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database error after editing the .htaccess file for multisite.’ is closed to new replies.