[Plugin: WangGuard] Help! Installation broke wp-admin

It’s right after I hit Activate on this screen that it all broke:

Downloading install package from https://downloads.www.ads-software.com/plugin/wangguard.1.5.1.zip…

Unpacking the package…

Installing the plugin…

Successfully installed the plugin WangGuard 1.5.1.

Activate Plugin | Return to Plugin Installer

Here’s some error log records I found that may help with diagnosis:

/home2/coached1/public_html/wp-admin/error_log:
[28-Aug-2012 20:16:10] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard_api_key’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:16:10] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:16:10] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:16:10] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard_api_key’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:16:10] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:16:10] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-blog’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:25:20] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-report-posts’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), include_once(‘/plugins/wangguard/wangguard-core.php’), wangguard_get_option
[28-Aug-2012 20:25:20] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard_api_key’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:25:20] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:25:20] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:25:20] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard_api_key’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:25:20] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:25:20] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-blog’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:25:20] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 30720 bytes) in /home2/coached1/public_html/wp-admin/includes/menu.php on line 38
[28-Aug-2012 20:27:23] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-report-posts’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), include_once(‘/plugins/wangguard/wangguard-core.php’), wangguard_get_option
[28-Aug-2012 20:27:23] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard_api_key’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:27:23] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:27:23] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:27:23] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard_api_key’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:27:23] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:27:23] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-blog’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:27:23] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 122880 bytes) in /home2/coached1/public_html/wp-admin/includes/menu.php on line 126
[28-Aug-2012 20:59:32] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-report-posts’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), include_once(‘/plugins/wangguard/wangguard-core.php’), wangguard_get_option
[28-Aug-2012 20:59:32] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard_api_key’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:59:32] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:59:32] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[28-Aug-2012 20:59:33] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard_api_key’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:59:33] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:59:33] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-blog’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[28-Aug-2012 20:59:33] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 30720 bytes) in /home2/coached1/public_html/wp-admin/includes/menu.php on line 38

Hi,

Something was wrong in activation. The database was not updated with WangGuard Tables.

Please, I will paste here the code to use in phpmyadmin

Thanks! Very much appreciated! I’m getting splogger sign-ups every hour or two now…

Hi tgattis,

Here is the code:

CREATE TABLE wangguardquestions (
			id mediumint(9) NOT NULL AUTO_INCREMENT,
			Question VARCHAR(255) NOT NULL,
			Answer VARCHAR(50) NOT NULL,
			RepliedOK INT(11) DEFAULT 0 NOT NULL,
			RepliedWRONG INT(11) DEFAULT 0 NOT NULL,
			UNIQUE KEY id (id)
		) COLLATE utf8_general_ci;

CREATE TABLE wangguarduserstatus (
			ID BIGINT(20) NOT NULL,
			user_status VARCHAR(20) NOT NULL,
			user_ip VARCHAR(15) NOT NULL,
			user_proxy_ip VARCHAR(15) NOT NULL,
			UNIQUE KEY ID (ID)
		) COLLATE utf8_general_ci;

CREATE TABLE wangguardreportqueue (
			ID BIGINT(20) NULL,
			blog_id BIGINT(20) NULL,
			reported_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
			reported_by_ID BIGINT(20) NOT NULL,
			KEY reported_by_ID (reported_by_ID),
			KEY ID (ID),
			KEY blog_id (blog_id),
			UNIQUE KEY ID_blog (ID , blog_id)
		) COLLATE utf8_general_ci;

CREATE TABLE wangguardsignupsstatus (
			signup_username VARCHAR(60) NOT NULL,
			user_status VARCHAR(20) NOT NULL,
			user_ip VARCHAR(15) NOT NULL,
			user_proxy_ip VARCHAR(15) NOT NULL,
			UNIQUE KEY signup_username (signup_username)
		) COLLATE utf8_general_ci;

CREATE TABLE wangguardoptions (
			option_name varchar(64) NOT NULL,
			option_value longtext NOT NULL,
			UNIQUE KEY option_name (option_name)
		) COLLATE utf8_general_ci;

CREATE TABLE wangguardcronjobs (
				id mediumint(9) NOT NULL AUTO_INCREMENT,
				RunOn VARCHAR(20) NOT NULL,
				RunAt VARCHAR(5) NOT NULL,
				Action VARCHAR(1) NOT NULL,
				UsersTF VARCHAR(1) NOT NULL,
				LastRun TIMESTAMP NULL,
				UNIQUE KEY id (id)
			) COLLATE utf8_general_ci;

Please, change “COLLATE utf8_general_ci” to your collate, if you dont use utf8_general_ci

Kind regards

Thanks! OK, I ran each of these, I believe successfully. There was a flash of red, but it disappeared too quickly to read, then got a green success bar and the table appeared for each one (although with zero rows in each, of course). Unfortunately, it does not seem to have fixed the problem. wp-admin still not loading. Any other suggestions?

Here’s what gets added to the PHP error log every time I try to load wp-admin. If I’m reading this correctly, it’s saying the tables don’t exist, but I’m looking at them in phpMyAdmin! (although they are empty tables – is that the issue?)

[29-Aug-2012 21:58:31] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-report-posts’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), include_once(‘/plugins/wangguard/wangguard-core.php’), wangguard_get_option
[29-Aug-2012 21:58:31] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard_api_key’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[29-Aug-2012 21:58:31] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[29-Aug-2012 21:58:31] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wangguard/wangguard-admin.php’), wangguard_get_option
[29-Aug-2012 21:58:32] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard_api_key’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[29-Aug-2012 21:58:32] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-btn’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[29-Aug-2012 21:58:32] WordPress database error Table ‘coached1_wrd1.wp_wangguardoptions’ doesn’t exist for query SELECT option_value FROM wp_wangguardoptions WHERE option_name = ‘wangguard-enable-bp-report-blog’ LIMIT 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wangguard_init, wangguard_get_option
[29-Aug-2012 21:58:32] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 30720 bytes) in /home2/coached1/public_html/wp-admin/includes/menu.php on line 38

Note there’s also a memory error at the end there. I’m using BlueHost with a very simple site, so I doubt that’s the real issue.

Ups… sorry,

I forgot something

In every code, you will see something like this:

CREATE TABLE tablename

Ok, you need to add the prefix to the table, ex:

CREATE TABLE prefix_tablename

The standard table prefix is wp_

I’m sorry :S

BlueHost is saying I can deactivate it by removing from this entry in the database:

a:6:{i:0;s:19:”akismet/akismet.php”;i:1;s:19:”bbpress/bbpress.php”;i:2;s:24:”buddypress/bp-loader.php”;i:3;s:19:”jetpack/jetpack.php”;i:4;s:29:”wangguard/wangguard-admin.php”;i:5;s:23:”wordfence/wordfence.php”;}

Do you know if WangGuard is compatible with all of those plug-ins, esp. WordFence?

Yes, it is.

I have that plugins in all my installations.

Have you tried resetting the plugins folder by FTP or PhpMyAdmin?

Thanks. That makes sense. I dropped all the old tables and put the new ones in. Unfortunately wp-admin still doesn’t work, but the error table has changed to only be memory errors. Unless you have a suggestion, I guess I have to check with bluehost on fixing that problem…

22:24:21] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 30720 bytes) in /home2/coached1/public_html/wp-admin/includes/menu.php on line 38
[29-Aug-2012 22:24:25] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 122880 bytes) in /home2/coached1/public_html/wp-admin/includes/menu.php on line 126
[29-Aug-2012 22:25:14] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 122880 bytes) in /home2/coached1/public_html/wp-admin/menu.php on line 73

That’s a site issue – not a plugin specific one. Try increasing the memory available to PHP.

Thanks. Done! And it seems to be working now. Thanks again for all the help!

I’m guessing the ultimate issue was not WangGuard itself, but running out of PHP memory during the WangGuard activation process. BlueHost defaults to 64mb, but I followed their procedure (https://my.bluehost.com/cgi/help/memory) and upped it to 128mb. Problem solved!