subscribe2 activate error in version 9 – WordPress 3.7.1

Gives this error at the bottom of the site pages, when I try to activate the plugin. It works on my other sites.

@rpittam,

If you have no data to lose uninstall the plugin and then install it again.

If you have data in the plugin already (subscribers for example) then click the Reset Button in the Settings page under the miscellaneous tab if you can access it and see if that helps.

Tried the reset, no change. Reinstalled the plugin, no change, same error. I have removed some plugins, no change. Would it work, if I upgraded my WordPress to 3.8?
Thanks.
Richard.

@rpittam,

I doubt it. For some reason the code is failing when trying to create the Subscribe2 table as it thinks it already exists. But if the table is already there that code should not even be getting called.

Try accessing PHPMyAdmin and dropping the table and then re-creating it by directly applying the following SQL:

CREATE TABLE wpsbam_subscribe2 ( id int(11) NOT NULL auto_increment, email varchar(64) NOT NULL default '', active tinyint(1) default 0, date DATE default '2013-12-13' NOT NULL, time TIME DEFAULT '00:00:00' NOT NULL, ip char(64) NOT NULL default 'admin', conf_date DATE, conf_time TIME, conf_ip char(64), PRIMARY KEY (id) )

Also, one other thing of note is that your WordPress prefix contains upper and lower case characters. For simplicity it might be wise if you can make it all lower case. It seems that on some installs having upper case in there causes issues.

Yep, tried that, no joy.
Thanks.
Richard.

@richard,

In that case I suspect a case sensitivity issue in the table name. MySQL documentation confirms that this might be a problem.

https://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

I’ve read the link content, but i am afraid it leaves me confused. i have not had this problem before, it only started recently. what would be the effect of renaming all my tbles to lower case have on all my other plugins and asp/vbscript code?

@richard,

That might well cause problems, I was thinking this was a new site but if it is already existing changing that might have consequences.

If the table appear to be created correctly in PHPMyAdmin try commenting out this line in the classes/class-s2-core.php file:

if ( $wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $this->public)) != $this->public ) { $this->install(); }

that seems to have fixed it.

@richard,

You’l have to bear that in mind in future updates, it’s a workaround for you issue rather than a total fix.

Thanks.

Hi Matt.
I installed subscribe version 10.2 and commented out line 1646, in the classes\class-s2-core.php, as below.

//if ( $wpdb->get_var($wpdb->prepare(“SHOW TABLES LIKE %s”, $this->public)) != $this->public ) { $this->install(); }

but I still get the same error, as below.

PHP Warning: Missing argument 2 for wpdb::prepare(), called in D:\Sites\xxxxxxxx

This has been working as I updated and modified the line, but until the latest upgrade to 10.2.

Help.
Thanks.
Richard.

@richard,

What file and line is that error being reported on?

This is the error, with my bits masked out;

PHP Warning: Missing argument 2 for wpdb::prepare(), called in D:\Sites\Single58\xxxx\webroot\blogname\Blog\wp-content\themes\piano-black\sidebar.php on line 75 and defined in D:\Sites\Single58\xxxx\webroot\blogname\Blog\wp-includes\wp-db.php on line 1147

Maybe it’s not an subscribe2 error.

@richard,

No, that error is coming from on of your theme files it would seem.