Ruairisdad

OK thanks. I wrote a simple plugin (first time!) to create the shortcodes.

I wanted the total for the main thermometer to also be dynamic; i.e., automatically be the total of the secondary thermometers. I noticed that dynamic total values aren’t supported in the plugin so I implemented it in my copy, but maybe it’s something you might want to consider implementing in the plugin.

The shortcode is:
[fts_facebook type=page id=manesformovement posts=6 posts_displayed=page_only]

@calbuny glad to hear I’m not the only one.

Unfortunately, even the default token has stopped working now. No errors are displayed, but only the header for the feed is displayed; no posts are shown.

When I was trying to get this is work last month I asked the page owner to generate an access token and app ID, and when I use these, I get this error: Error: (#10) To use ‘Page Public Content Access’, your use of this endpoint must be reviewed and approved by Facebook. To submit this ‘Page Public Content Access’ feature for review please read our documentation on reviewable features: https://developers.facebook.com/docs/apps/review.
Type: OAuthException
Code: 10

When I put my token and ID back in, the error returns. ??

Is no one else seeing this issue?

Yes, I got it working again, but only by going back to the default APP ID. Is this what I’m supposed to do? I note this notice in the Facebook Settings menu:

“You are using our Default APP Token for testing purposes. Generate your shortcode on the settings page to test your feed, but remember to add your own tokens after testing as the default token will not always work”

The problem is, with my own token, it worked for a while, but then I got the error message I reported above.

FYI, I deleted my Access Token and App ID on the Facebook Settings, and now it’s working

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.

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

I think that means the email address you entered belongs to a registered user on your blog. So it’s telling the user to log in to the blog, and go to their profile, and manage their subscribe2 settings there.