Installing on Legacy WPMU site

  • Resolved techyfeely

    (@techyfeely)


    7 years, 2 months ago

    Greetings!
    I am attempting to install NinjaFirewall on my institutional multisite server. We have a legacy system that was originally WPMU and then became a multisite with WP3.0. We have almost 3000 blogs created at this point.

    I have installed the plugin and made the change recommended to our .htaccess file. I had to create the nfwlog directory manually but I do see files in it that were created.

    I am getting a fatal error, however: NinjaFirewall fatal error: Cannot retrieve user options from database (#2). Review your installation, your site is not protected.

    And, when I ran the troubleshooting script, I get the DB_NAME, etc information returned and then happens:

    Attempting to connect to the DB: OK
    Attempting to read NinjaFirewall’s options (nfw_options) from the DB: Error: Table ‘wordpressmu.wp_options’ doesn’t exist

    Thanks for suggestions for next steps!

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author nintechnet

    (@nintechnet)

    Hi,
    Does the “wordpressmu.wp_options” table exist?

    Thread Starter techyfeely

    (@techyfeely)

    There is not a table called ‘wordpress.mu_options’ nor one simply called wp_options. There are thousands of tables called wp_###_options where the ### is the blog number in the multisite.

    Thread Starter techyfeely

    (@techyfeely)

    Also, the table prefix in config file is wp_

    Plugin Author nintechnet

    (@nintechnet)

    “wordpressmu” is the database, it is likely correct (it was returned in the MySQL error message).

    I can’t see why you don’t have a “wp_options” table. I just tested on a multi-site and without it, it does not work at all and WordPress crashes and throws a “Error establishing a database connection” error.

    Which version of WordPress are you running?

    Thread Starter techyfeely

    (@techyfeely)

    We are running 4.8.1 This installation is over 10 years old and was upgraded from the WPMU install to WordPress Multisite with 3.0. I think that is why there is no wp_options table. All of the individual blogs have their own specific wp_##_options table instead.

    Plugin Author nintechnet

    (@nintechnet)

    The “wp_##_options” tables are always present in a multi-site network.
    But the “wp_options” table is used by the main site only, i.e., the site of the network admin where plugins can be installed etc.
    Do you have a main site and a network admin?

    Thread Starter techyfeely

    (@techyfeely)

    Yes. the blogs.pstcc.edu blog is the main site. I have a Super Admin account that I use to see the network admin stuff as well as the main blog.

    From what I can see in the database, our main site uses the wp_1_options table.

    Plugin Author nintechnet

    (@nintechnet)

    I see: the problem is that you are using “wp_1_options” for the main site, instead of “wp_options”. I assume it comes from the way it was installed.

    See this discussion about how to solve it: https://www.ads-software.com/support/topic/ninjafirewall-fatal-error-cannot-retrieve-user-options-from-database-1/

    Note that I recommend you first uninstall NinjaFirewall, and then re-install it right after making the above change to your wp-config.php.

    Thread Starter techyfeely

    (@techyfeely)

    Thank you. That seemed to do the trick! I truly appreciate your time and talents helping me.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Installing on Legacy WPMU site’ is closed to new replies.