Files got deleted

Resolved krohit
(@krohit)

11 years, 8 months ago

I have been running wordpress multisite for a few months now. Since yesterday, I was unable to access the super user dashboard, but could access the individual sites in my domain http://ientrepreneur.co.in

In an attempt to repair the sittuation, I added
define(‘WP_ALLOW_REPAIR’, true);
to the wp-config.php file

Now I’m getting the following errors

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

How can I restore my database? Please help asap. Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)

Moderator Ipstenu (Mika Epstein)
(@ipstenu)

🏳️‍🌈 Advisor and Activist

11 years, 8 months ago

Please check in your wp-config.php and ensure you have BOTH

define( 'WP_ALLOW_MULTISITE', true );

AND

define( 'MULTISITE', true );

Yes, both.

Thread Starter krohit
(@krohit)

11 years, 8 months ago

Thanks, this helped restore the database, but I still can’t access super admin to install new plugins, modify css files.

Dot 07
(@dot07)

11 years, 8 months ago

If you don’t have network access you should be able to go into the database and look in the “wp_sitemeta” table (presuming the default wp_ prefix).

Look down the “meta_key” column for “site_admins”. In the site_admins row you should see something like this:
a:1:{i:0;s:8:"username";}

If your username is not there, change it to your username and where s:8 is in the example, change that number 8 to the number of characters in your username.

“site_admins” is where you find Super Admin(s).

Also, you can look at the following threads:

http://wordpress.org/support/topic/super-admin-problem

http://wordpress.org/support/topic/recover-super-admin-access-after-username-change

I hope this helps.

Moderator Ipstenu (Mika Epstein)
(@ipstenu)

🏳️‍🌈 Advisor and Activist

11 years, 8 months ago

I still can’t access super admin to install new plugins, modify css files.

If that advice didn’t help, what’s the actual error 🙂 Can you log in as super admin? If so, what happens when you go to the network admin page?

Thread Starter krohit
(@krohit)

11 years, 8 months ago

Thanks Dot 07 and Mika. Issue resolved.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Files got deleted’ is closed to new replies.

Files got deleted

Topics

Topics with no replies

Non-support topics

Resolved topics

Unresolved topics

All topics