Title: ADPowers's Replies | WordPress.org

---

# ADPowers

  [  ](https://wordpress.org/support/users/adpowers/)

 *   [Profile](https://wordpress.org/support/users/adpowers/)
 *   [Topics Started](https://wordpress.org/support/users/adpowers/topics/)
 *   [Replies Created](https://wordpress.org/support/users/adpowers/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/adpowers/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/adpowers/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/adpowers/engagements/)
 *   [Favorites](https://wordpress.org/support/users/adpowers/favorites/)

 Search replies:

## Forum Replies Created

Viewing 8 replies - 1 through 8 (of 8 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[SendPress Newsletters] Re-Send Optin Email](https://wordpress.org/support/topic/re-send-optin-email/)
 *  Thread Starter [ADPowers](https://wordpress.org/support/users/adpowers/)
 * (@adpowers)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/re-send-optin-email/#post-6292428)
 * I have been thinking about this feature.
 * For this to work properly, there should be an additional user status — ‘Declined’,
   so that there can be two hyperlinks on the confirmation email, ie, ‘Approve’ 
   or ‘Decline’.
 * That way, resending the optin email should only be done to users with status 
   as unconfirmed.
 * At the moment, if people simply ‘ignore’ the email, their status remains as unconfirmed,
   when perhaps they would have ‘declined’ if given the option….
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[SendPress Newsletters] Re-Send Optin Email](https://wordpress.org/support/topic/re-send-optin-email/)
 *  Thread Starter [ADPowers](https://wordpress.org/support/users/adpowers/)
 * (@adpowers)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/re-send-optin-email/#post-6292368)
 * Cool.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[SendPress Newsletters] Double Opt In Email Not Being Sent](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/)
 *  Thread Starter [ADPowers](https://wordpress.org/support/users/adpowers/)
 * (@adpowers)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/#post-6276635)
 * It looks a little different (formatting, icons etc…), as I think you are using
   the ‘pro’ version, which I am not, but that is the option which I have selected,
   ie, using my website to deliver the messages (NOT google, or anything else).
 * I should also say (again) that sending of the opt in emails have always been 
   working fine, when using the explicit ‘subscribe’ form, the problem was when 
   this process should have been triggered with easy digital downloads checkout 
   via this plugin [https://wordpress.org/plugins/edd-sendpress/](https://wordpress.org/plugins/edd-sendpress/)
 * Cheers
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[SendPress Newsletters] Double Opt In Email Not Being Sent](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/)
 *  Thread Starter [ADPowers](https://wordpress.org/support/users/adpowers/)
 * (@adpowers)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/#post-6276628)
 * Ok so I found what is causing the problem:
 * In <PLUGINS ROOT>/sendpress/classes/class-sendpress-manager.php
 * Around line 415, static function send(…)
 * $sender = $sendpress_sender_factory->get_sender($method), is assigning null value
   to $sender, which is causing the next line to fail:
 * if( $sender != false ){
    // DO THE SENDING }
 * However, commented out below this block is:
 * $website = new SendPress_Sender_Website();
    return $website->send_email( $to,
   $subject, $body, $text, $test, $sid , $list_id, $report_id );
 * Which works, so the net function for me, is like this:
 * —
 * static function send($to , $subject, $body, $text, $test = false, $sid=0 ,$list_id
   = 0, $report_id = 0 ){
 *  global $sendpress_sender_factory;
    // $senders = $sendpress_sender_factory->
   get_all_senders(); $method = SendPress_Option::get( ‘sendmethod’ ); $sender =
   $sendpress_sender_factory->get_sender($method); if( $sender != false ){ if( empty(
   $text) || $text == ” || empty($body) || $body== ” || $body == ” “){ SPNL()->log-
   >add( ‘Email Skiped’ , ‘Email to ‘.$to.’ did not have any Text.’, 0 , ‘sending’);
   return false; } return $sender->send_email( $to, $subject, $body, $text, $test,
   $sid , $list_id, $report_id ); }
 *  $website = new SendPress_Sender_Website();
    return $website->send_email( $to,
   $subject, $body, $text, $test, $sid , $list_id, $report_id );
 *  }
 * —
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[SendPress Newsletters] Double Opt In Email Not Being Sent](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/)
 *  Thread Starter [ADPowers](https://wordpress.org/support/users/adpowers/)
 * (@adpowers)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/#post-6276627)
 * Still not resolved, but here is an error in the code:
    <PLUGINS ROOT>/sendpress/
   classes/db/class-sendpress-db-subscribers-tracker.php, Line 173
 * $sql = ” CREATE TABLE {$this->table_name} (
    subscriber_id int(11) unsigned NOT
   NULL, email_id int(11) unsigned NOT NULL, sent_at datetime NOT NULL DEFAULT ‘
   0000-00-00 00:00:00’, opened_at datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
   status tinyint(4) NOT NULL DEFAULT ‘0’, tracker_type tinyint(4) NOT NULL DEFAULT‘
   0’, opened_count int(11) unsigned NOT NULL, PRIMARY KEY (subscriber_id,email_id),
   KEY tracker_type ) $collate;\n”;
 * 2nd last line in the above should say “KEY (tracker_type)”, meaning that the 
   above block should be:
 * $sql = ” CREATE TABLE {$this->table_name} (
    subscriber_id int(11) unsigned NOT
   NULL, email_id int(11) unsigned NOT NULL, sent_at datetime NOT NULL DEFAULT ‘
   0000-00-00 00:00:00’, opened_at datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
   status tinyint(4) NOT NULL DEFAULT ‘0’, tracker_type tinyint(4) NOT NULL DEFAULT‘
   0’, opened_count int(11) unsigned NOT NULL, PRIMARY KEY (subscriber_id,email_id),
   KEY (tracker_type) ) $collate;\n”;
 * ———————————-
    perhaps this error is MYSQL version dependent… 🙁
 * My overall problem is still not resolved…
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[SendPress Newsletters] Double Opt In Email Not Being Sent](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/)
 *  Thread Starter [ADPowers](https://wordpress.org/support/users/adpowers/)
 * (@adpowers)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/#post-6276617)
 * This error is showing up in the error log:
    — WordPress database error Table ‘
   ubuntu_themes.wp_sendpress_subscribers_tracker’ doesn’t exist for query SHOW 
   FULL COLUMNS FROM `wp_sendpress_subscribers_tracker` made by require(‘wp-blog-
   header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘
   wp-settings.php’), do_action(‘init’), call_user_func_array, edd_post_actions,
   do_action(‘edd_purchase’), call_user_func_array, edd_process_purchase_form, do_action(‘
   edd_checkout_before_gateway’), call_user_func_array, SendPress_EDD_Signup::sendpress_edd_check_for_email_signup,
   SendPress_EDD_Signup::subscribe_email, SendPress_Data::subscribe_user, SendPress_Manager::
   send_optin, SendPress_DB_Subscribers_Tracker->add, SendPress_DB->replace —
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[SendPress Newsletters] Double Opt In Email Not Being Sent](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/)
 *  Thread Starter [ADPowers](https://wordpress.org/support/users/adpowers/)
 * (@adpowers)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/#post-6276587)
 * This spinner issue is the same for me, but the functionality works, if you click
   the button, you are subscribed
 * I have disabled Ajax via the advanced tab, but it makes no difference, the spinning
   wheel persists. So I really do not know what is going on.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[SendPress Newsletters] Double Opt In Email Not Being Sent](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/)
 *  Thread Starter [ADPowers](https://wordpress.org/support/users/adpowers/)
 * (@adpowers)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/double-opt-in-email-not-being-sent/#post-6276455)
 * Test emails get sent fine, so the email sending is set up correctly.
 * Double verification email sends fine if I explicitly add an email to the list,
   via the subscription page: [http://www.ubuntuthemes.org/subscribe/](http://www.ubuntuthemes.org/subscribe/).
   This email has a link, which if you click on it, the email is then marked as 
   approved.
 * However, if the user registers when checking out their cart (you will need to
   add a theme and download, the majority of which are free), and opts in for the
   newsletter, this same double verification email is NOT sent. To view this behaviour,
   visit [http://ubuntuthemes.org](http://ubuntuthemes.org) when not logged in, 
   and add a theme, going through the checkout procedure.

Viewing 8 replies - 1 through 8 (of 8 total)