NinjaFirewall fatal error : cannot retrieve user options from database (#1).

Hi,

This error means that NinjaFirewall options cannot be found in your database. Its options are stored in the “nfw_options” row in the WordPress “wp_options” table. There must be a “nfw_rules” row as well in that table.

They were either deleted or not created.

The only way to re-create them, is to:
1. remove the “auto_prepend_file” directive that was added to your PHP INI file during the installation.
2. goto to your WP admin console and click on NinjaFirewall menu to start the installer.

Thanks for you quick reply ??

I tried out your idea but it just resulted in the initial error code again

It did, however, push me towards finding where the heart of the problem lies. These older sites do not have a wp_options table. Instead the ‘nfw options and rules rows’ have been created in the wp_1_options table. It must have been how the mu/multisites were set up back then.

Is it possible to have NinjaFirewall draw the options from that table?

Thanks!
Peter

What is the value of $table_prefix in your wp-config.php ?

$table_prefix = ‘wp_’

You can try to edit your wp-config.php.
So far, you have:

$table_prefix  = 'wp_';

Append 3 lines to it:

$table_prefix  = 'wp_';

/* For NinjaFirewall only :
$table_prefix  = 'wp_1_';
End of NinjaFirewall code */

PHP (and WP), will use the first one, wp_, as usual. But NinjaFirewall will parse and use the second one, wp_1_.
The firewall, which runs before WordPress, will look for wp_1_options and that should work.

But what I do not understand in your configuration, is how the plugin can find the right options table ? Does that mean the superadmin main site of your network uses wp_1_* tables rather than wp_* ?

I’m not sure I totally understand some of those older configurations ??

What I do know is that your fix worked a treat!

Thank you so much!!

Best wishes