Forums

The WordPress MU forums have moved to the MultiSite forum on WordPress.org

Database Problem; Website Lost in Space (4 posts)

  1. Njualem
    Member
    Posted 2 years ago #

    Hi Guys,

    I have a problem with my entire website. I am using Wordpress Mu 2.7.1 and I installed the WP-Options-Manager Plugin to clean up deprecated Plugin options from my data base. It worked well when I started using it in one of my WPMU Blogs but when I activated the Plugin on the WPMU Main Blog then came the catastrophe.

    On the WPMU Main Blog, I noticed that the Plugin was not functioning well so I went back to the Blog I first activated the Plugin to check-out its behavior but unfortunately I had a NO PAGE FOUND screen. Both the front-end and the back-end of all of my other Blogs display a NO PAGE FOUND screen as well, but on the WPMU Main Blog I can access the back-end but for the front-end, only the front-page displays and any other link like categories etc display a NO PAGE FOUND screen.

    I tried uninstalling the Plugin and removing it entirely from my Wordpress Plugins directory but to no avail, the damage had already been done.

    I then accessed my database through phpmyadmin and I discovered that the "blog-id" in wp-options table for all the different Blogs has been set to 0.
    i.e:
    wp_1_option, blog_id = "0"
    wp_2_option, blog_id = "0"
    wp_3_option, blog_id = "0"
    wp_4_option, blog_id = "0"
    wp_5_option, blog_id = "0" ... and so on.

    I even created a new blog, it was created successfully with tables in the database but it's back-end and front-end also display a NO PAGE FOUND screen.

    I am in a fixed now, since I had only made backup just for the first Blog I started from and now I risk losing my entire site because the other Blogs don't have up to date backups.

    Please can anyone give me some insides on what steps to take?

    Thanks for your support.

    NB: This should stand as a warning to WPMU users; DON'T USE WP_OPTIONS_MANAGER Plugin, for you risk losing your entire Website.

  2. andrea_r
    Moderator
    Posted 2 years ago #

    "I then accessed my database through phpmyadmin and I discovered that the "blog-id" in wp-options table for all the different Blogs has been set to 0.
    i.e:
    wp_1_option, blog_id = "0"
    wp_2_option, blog_id = "0"
    wp_3_option, blog_id = "0"
    wp_4_option, blog_id = "0"
    wp_5_option, blog_id = "0" ... and so on."

    Did you trry changing the 0 to the ID number of the blog in each line?

    Like this:

    wp_1_option, blog_id = "1"
    wp_2_option, blog_id = "2"
    wp_3_option, blog_id = "3"
    wp_4_option, blog_id = "4"
    wp_5_option, blog_id = "5"

  3. Njualem
    Member
    Posted 2 years ago #

    Yes I did but it did not help.

  4. wpmuguru
    Member
    Posted 2 years ago #

    The blog_id field in the wp_x_options tables is not used by MU. It is typically 0 in any option table I look at.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags