Now will only work on main site, wont work on MU sites

Having issue with this plug in was all working fine for both main site and MU sites.

Now will only work on main site, wont work on MU sites.

If you subscribe on main site all works fine, email is added, yet if same thing is done on sub site it comes up as if its added but when you look at subscription no new email comes up on MU site subscriptions page or main site ?

I have uninstalled and re installed but same issue, look like it has done this since 3.5 upgrade.?

So not sure what the issue is?

    rosscataldo

    yes multi site setup

    Copy of config - DB & Define Keys as requested.

    <?php
    /**
    * The base configurations of the WordPress.
    *
    * This file has the following configurations: MySQL settings, Table Prefix,
    * Secret Keys, WordPress Language, and ABSPATH. You can find more information
    * by visiting {@link http://codex.wordpress.org/Editing_wp-config.php Editing
    * wp-config.php} Codex page. You can get the MySQL settings from your web host.
    *
    * This file is used by the wp-config.php creation script during the
    * installation. You don't have to use the web site, you can just copy this file
    * to "wp-config.php" and fill in the values.
    *
    * @package WordPress
    */

    // ** MySQL settings - You can get this info from your web host ** //
    /** The name of the database for WordPress */
    //define('WP_CACHE', true); //Added by WP-Cache Manager
    define();

    /** MySQL database username */
    define('D);

    /** MySQL database password */
    define('');

    /** MySQL hostname */
    define('DB_HOST', 'localhost');

    /** Database Charset to use in creating database tables. */
    define('DB_CHARSET', 'utf8');

    /** The Database Collate type. Don't change this if in doubt. */
    define('DB_COLLATE', '');

    /**#@+
    * Authentication Unique Keys and Salts.
    *
    * Change these to different unique phrases!
    * You can generate these using the {@link https://api.wordpress.org/secret-key/1.1/salt/ WordPress.org secret-key service}
    * You can change these at any point in time to invalidate all existing cookies. This will force all users to have to log in again.
    *
    * @since 2.6.0
    */
    define('AUTH_KEY', ');
    define('SECURE_AUTH_KEY', ');
    define('LOGGED_IN_KEY', ');
    define('NONCE_KEY', ');
    define('AUTH_SALT', ');
    define('SECURE_AUTH_SALT', );
    define('LOGGED_IN_SALT', ');
    define('NONCE_SALT', ');

    /**#@-*/

    /**
    * WordPress Database Table prefix.
    *
    * You can have multiple installations in one database if you give each a unique
    * prefix. Only numbers, letters, and underscores please!
    */
    $table_prefix = 'wp_';

    /**
    * WordPress Localized Language, defaults to English.
    *
    * Change this to localize WordPress. A corresponding MO file for the chosen
    * language must be installed to wp-content/languages. For example, install
    * de_DE.mo to wp-content/languages and set WPLANG to 'de_DE' to enable German
    * language support.
    */
    define('WPLANG', '');

    /**
    * For developers: WordPress debugging mode.
    *
    * Change this to true to enable the display of notices during development.
    * It is strongly recommended that plugin and theme developers use WP_DEBUG
    * in their development environments.
    */
    define('WP_DEBUG', false);
    /** Allow Multisite */
    define('WP_ALLOW_MULTISITE', true);
    define( 'MULTISITE', true );
    define( 'SUBDOMAIN_INSTALL', false );
    $base = '/';
    define( 'DOMAIN_CURRENT_SITE', 'project365.com.au' );
    define( 'PATH_CURRENT_SITE', '/' );
    define( 'SITE_ID_CURRENT_SITE', 1 );
    define( 'BLOG_ID_CURRENT_SITE', 1 );

    /** Allow Multi Domains */
    define( 'SUNRISE', 'on' );

    /** SEO Multi Site Access for Role -define( 'WDS_SITEWIDE', false ); */

    /** Post to your blog using email Activation*/
    define( 'POST_BY_EMAIL', true );
    /* That's all, stop editing! Happy blogging. */

    /** Absolute path to the WordPress directory. */
    if ( !defined('ABSPATH') )
    define('ABSPATH', dirname(__FILE__) . '/');

    /** Sets up WordPress vars and included files. */
    require_once(ABSPATH . 'wp-settings.php');

    rosscataldo

    Just an update, i was clearing out error log and came across this which ref to subscription

    I turned on subscriptions on subsites to see if any errors would occure, this is a sample of what i go.

    I would make the assumption that someone has tried to subscribe and got ok on webpage but when it has gone to insert email it rejects it in back end.

    I hope this helps

    Ross

    Examples below.

    1.
    [29-Jan-2013 11:34:45 UTC] WordPress database error Table 'project3_wrdp1.wp_52_subscriptions' doesn't exist for query SELECT * FROM wp_52_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications
    [29-Jan-2013 11:34:46 UTC] WordPress database error Table 'project3_wrdp1.wp_52_subscriptions' doesn't exist for query SELECT * FROM wp_52_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications
    [29-Jan-2013 11:34:47 UTC] WordPress database error Table 'project3_wrdp1.wp_52_subscriptions' doesn't exist for query SELECT * FROM wp_52_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications

    2.
    [29-Jan-2013 11:37:39 UTC] WordPress database error Table 'project3_wrdp1.wp_665_subscriptions' doesn't exist for query SELECT * FROM wp_665_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications
    [29-Jan-2013 11:37:40 UTC] WordPress database error Table 'project3_wrdp1.wp_665_subscriptions' doesn't exist for query SELECT * FROM wp_665_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications
    [29-Jan-2013 11:37:41 UTC] WordPress database error Table 'project3_wrdp1.wp_665_subscriptions' doesn't exist for query SELECT * FROM wp_665_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications
    [29-Jan-2013 11:37:42 UTC] WordPress database error Table 'project3_wrdp1.wp_665_subscriptions' doesn't exist for query SELECT * FROM wp_665_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications
    [29-Jan-2013 11:37:42 UTC] WordPress database error Table 'project3_wrdp1.wp_665_subscriptions' doesn't exist for query SELECT * FROM wp_665_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications
    [29-Jan-2013 11:37:42 UTC] WordPress database error Table 'project3_wrdp1.wp_665_subscriptions' doesn't exist for query SELECT * FROM wp_665_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications

    3.
    [29-Jan-2013 12:00:16 UTC] WordPress database error Table 'project3_wrdp1.wp_66_subscriptions' doesn't exist for query SELECT * FROM wp_66_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications
    [29-Jan-2013 12:00:16 UTC] WordPress database error Table 'project3_wrdp1.wp_66_subscriptions' doesn't exist for query SELECT * FROM wp_66_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications
    [29-Jan-2013 12:00:17 UTC] WordPress database error Table 'project3_wrdp1.wp_66_subscriptions' doesn't exist for query SELECT * FROM wp_66_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications
    [29-Jan-2013 12:00:25 UTC] WordPress database error Table 'project3_wrdp1.wp_66_subscriptions' doesn't exist for query SELECT * FROM wp_66_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications

    4.
    [29-Jan-2013 12:07:04 UTC] WordPress database error Table 'project3_wrdp1.wp_52_subscriptions' doesn't exist for query SELECT * FROM wp_52_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications

    5. [29-Jan-2013 13:04:26 UTC] WordPress database error Table 'project3_wrdp1.wp_541_subscriptions' doesn't exist for query SELECT * FROM wp_541_subscriptions WHERE subscription_type = 'instant' made by do_action_ref_array, call_user_func_array, ab_process_autoblog_for_cron, autoblogcron->always_process_autoblog, autoblogcron->process_feed, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, subscribe_by_email_process_instant_subscriptions, subscribe_by_email_send_instant_notifications

    kennibc

    Are you using the https://premium.wpmudev.org/project/new-blog-template/ New Blog Template Plugin? I had this issue with sub-sites Subscribe by Email not working because when I created a new blog it didn't copy the subscription table in the database.

    You have to check off this database table in the Advanced Settings page of the New Blog Template plugin.

    This will not fix the issue for existing blogs but it will for future created blogs using the New Blog Template Plugin.

    rosscataldo

    ok i have tested created new site and subscription section is working
    Plugin is activated individualy in free site template and main site but not network activated.

    I attempted to activate in nextwork and tested one of the other sites and still not working.

    I turned this off and activated on individual blog where it was working and still not working so now a bit confused.

    Would not network activating it create tables for all blogs ?

    Still need help please.

    Need to know how to reactivate for all existing users seeinh new users seem to be now working

    Ross