Add Subscriber failing

@randyn,

I suspect that this is because your database subscribe2 table is incomplete and missing some columns.

It should have the following columns inPHPMyAdmin:
id, email, active, date, time, ip, conf_date, conf_time, conf_ip.

Which of those are missing? If you look in the classes/class-s2-upgrade.php file you should see the functions to add these columns associated with Subscribe2 releases. If you can run the functions of SQL directly that will fix the issue if there were column names missing.

If you need the SQL let me know which columns are missing on your table.

If the columns are not missing then it’ll be a permissions issue, your WordPress login account for the database has permission to delete but not add That needs to be fixed in cPanel.

That worked; thanks. I added the missing columns and now subscribers can be added.

Were these columns not added during a previous upgrade?

@randyn,

Indeed, at some point in past iterations of the code the upgrade has failed. I see this issue rarely now so presumed it had been fixed. It’s a hard bug to track down!

Hi,

I’m having the same problem. I’ve tracked it down to a failure in the function add() in class-s2-core.php. Specifically, the statement:
$wpdb->query($wpdb->prepare("INSERT INTO $this->public (email, active, date, time, ip) VALUES (%s, %d, CURDATE(), CURTIME(), %s)", $email, 0, $this->ip));
is returning FALSE.

Checking the script log file on the server shows error messages like this when I attempt to add a public subscriber:

[12-Nov-2013 23:30:51] WordPress database error Unknown column ‘time’ in ‘field list’ for query INSERT INTO wp_subscribe2 (email, active, date, time, ip) VALUES (‘blog url’, 0, CURDATE(), CURTIME(), ‘ip address’) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include (‘/themes/theme3/page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, s2_frontend->filter, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, s2_frontend->shortcode, s2class->add

Searching further back, I found these messages:

[06-Nov-2013 18:47:44] WordPress database error ALTER command denied to user ‘[DB username]’@’localhost’ for table ‘wp_subscribe2′ for query ALTER TABLE wp_subscribe2 ADD time TIME DEFAULT ’00:00:00’ NOT NULL AFTER date made by shutdown_action_hook, do_action(‘shutdown’), call_user_func_array, s2class->upgrade, s2class_upgrade->upgrade85, maybe_add_column

[06-Nov-2013 18:47:44] WordPress database error ALTER command denied to user ‘[DB username]’@’localhost’ for table ‘wp_subscribe2’ for query ALTER TABLE wp_subscribe2 ADD conf_date DATE AFTER ip made by shutdown_action_hook, do_action(‘shutdown’), call_user_func_array, s2class->upgrade, s2class_upgrade->upgrade86, maybe_add_column

[06-Nov-2013 18:47:44] WordPress database error ALTER command denied to user ‘[DB username]’@’localhost’ for table ‘wp_subscribe2’ for query ALTER TABLE wp_subscribe2 ADD conf_time TIME AFTER conf_date made by shutdown_action_hook, do_action(‘shutdown’), call_user_func_array, s2class->upgrade, s2class_upgrade->upgrade86, maybe_add_column

[06-Nov-2013 18:47:44] WordPress database error ALTER command denied to user ‘[DB username]’@’localhost’ for table ‘wp_subscribe2’ for query ALTER TABLE wp_subscribe2 ADD conf_ip char(64) AFTER conf_time made by shutdown_action_hook, do_action(‘shutdown’), call_user_func_array, s2class->upgrade, s2class_upgrade->upgrade86, maybe_add_column

[06-Nov-2013 18:47:44] WordPress database error ALTER command denied to user ‘[DB username]’@’localhost’ for table ‘wp_subscribe2′ for query ALTER TABLE wp_subscribe2 ADD time TIME DEFAULT ’00:00:00’ NOT NULL AFTER date made by shutdown_action_hook, do_action(‘shutdown’), call_user_func_array, s2class->upgrade, s2class_upgrade->upgrade88, maybe_add_column

[06-Nov-2013 18:47:47] PHP Warning: include_once(/[blog dir]/wp-
content/plugins/subscribe2/subscribe2.php) [function.include-once]: failed to open stream: Stale NFS file handle in /[blog dir]/wp-settings.php on line 197

[06-Nov-2013 18:47:47] PHP Warning: include_once() [function.include]: Failed opening ‘/[blog dir]/wp-content/plugins/subscribe2/subscribe2.php’ for inclusion (include_path=’.:/include:/usr/lib/php’) in /'[blog dir]’/wp-settings.php on line 197

I opened the database with phpMyAdmin, and the only columns are: id, email, active, date

OK, more info:

The username used by wordpress to access the database did not have ALTER privileges for the database. It can CREATE tables, but not ALTER them; I wonder if that’s the default my ISP sets up for new users. So augmenting an existing subscribe2 table (as when doing an upgrade) wasn’t possible. I logged in to phpMyAdmin with the main Database Administrator username, added the columns, and now things work fine.

@ruairisdad,

You got there ahead of me ??

You basically had a call to insert information into the database failing because the query to add information to specific columns did not match the columns in the current database. By adding the correct columns you have fixed the issue.

Mattyrob,

I have this problem and I check my conlumn.
I do not have these conlumn. conf_date, conf_time, conf_ip.
and I do not know how to put it in.

Please help me.

@sakadasam,

Probably the easiest way is to edit the subscribe2.php file looking for this line:
define( 'S2VERSION', '9.2' );

Change that to:
define( 'S2VERSION', '2.0' );

And load you site a few times in your browser before changing that line back to the original and loading your site a few times again. That should site the upgrade functions and create those columns in the table.