WordPress.org

Ready to get started?Download WordPress

Forums

WPNewsman Lite
[resolved] Emails dont stop sending. (9 posts)

  1. greben99
    Member
    Posted 1 year ago #

    Love the plugin, the features are awesome!! Just having a slight issue with sending emails to our mailing list.

    In the mailbox page, I compose an email, click send now.
    It takes me to the ?page=newsman-mailbox page, it says pending then sending, and it doesn't stop sending emails, even when its sent to the entire list. Sent 865 of 389 emails and the Sent number keeps growing, I clicked stop and it still kept sending... it only stopped when I deleted the entire email. We had a lot of unhappy subscribers, when they received over 10 emails in a couple of seconds.

    I have tried to find the problem, but I cant seem to figure out whats happening, and there are no errors appearing in the logs.

    Cheers

    http://wordpress.org/extend/plugins/wpnewsman-newsletters/

  2. neocoder
    Member
    Plugin Contributor

    Posted 1 year ago #

    Hello,

    this is weird behavior. I saw your other post about register_widget. It's possible that some plugin or your theme breaks WPNewsman plugin. Could you please answer the questions below so I can try to recreate your environment and track the bug?

    Do your run your blog on shared hosting or VPS?
    Who's your provider if you use shared hosting?
    What's the version of WPNewsman plugin?
    What's the version of WordPress?
    What theme do you use? ( Please add a URL to download if it's free. )
    What plugins do you use? ( you can just copy and paste the names of active plugins )

    If it will be more convenient you can send me a response to the [email moderated - please keep the support in the forum].

  3. greben99
    Member
    Posted 1 year ago #

    Hey,

    Sorry for the delay in getting back to you, the email you provided has been moderated.

    I didn't want to waste your time, so the questions you asked above got me thinking, and I did some testing.

    I whipped up a test environment (benefits of using AWS), disabled all the other plugins, it was still happening.

    I started with the original g-lock subscriber app ages ago, then moved over to wpnewsman lite, the migration didn't work when I did it, I don't think there was a migration at the time, so I manually had to move the contacts over. I started with the original version of wpnewsman, and have just upgraded as you have released it new versions. I thought maybe something could have been corrupted, some of the data.

    I dropped all the newsman tables, disabled and enabled the newsman plugin so it setup the tables from scratch (left the options settings there) imported a test list, sent the email and it worked!

    Not sure if this is related, but just noticed this error appearing in the logs sometimes...

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM bc_newsman_sentlog\n\t\t\tWHERE \n\t\t\tbc_newsman_sentlog.emailId = 1 AND\n\t\t' at line 7 for query \n\t\t\tSELECT \n\t\t\tbc_newsman_sentlog.listId,\n\t\t\t'' as 'listName',\n\t\t\tbc_newsman_sentlog.recipientId,\n\t\t\tbc_newsman_sentlog.statusMsg,\n\t\t\tbc_newsman_sentlog.recipientAddr as 'email',\n\t\t\tFROM bc_newsman_sentlog\n\t\t\tWHERE \n\t\t\tbc_newsman_sentlog.emailId = 1 AND\n\t\t\tbc_newsman_sentlog.recipientId = 0 AND\n\t\t\tbc_newsman_sentlog.errorCode > 0\n\t\t made by do_action('wp_ajax_newsmanAjGetErrorLog'), call_user_func_array, newsmanAJAX->ajGetErrorLog, newsmanSentlog->getErrors, newsmanSentlog->getErrorsForList, referer: /wp-admin/admin.php?page=newsman-mailbox

  4. greben99
    Member
    Posted 1 year ago #

    In addition to this, I had a look at the database structure of the one that wasn't working with the one that was working... I noticed 2 differences. I made those 2 changes to wpnewsman that wasn't working, and everything is now working.

    The differences were

    Not working version had MUL on the recipientId in the sentLog table

    | recipientId | int(10) unsigned | NO | MUL | 0

    Also, in the contact list the not working version had NO for NULL whereas the new version had YES

    | bounceStatus | text | NO | | NULL

    Below are the table structures

    FRESH INSTALL WORKING

    mysql> SHOW COLUMNS FROM bc_newsman_lists;
    +----------------+------------------+------+-----+---------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    +----------------+------------------+------+-----+---------+----------------+
    | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
    | uid | varchar(255) | NO | | | |
    | name | varchar(255) | NO | | | |
    | tblSubscribers | varchar(255) | NO | | | |
    | title | text | NO | | NULL | |
    | header | text | NO | | NULL | |
    | footer | text | NO | | NULL | |
    | form | text | NO | | NULL | |
    | extcss | text | NO | | NULL | |
    +----------------+------------------+------+-----+---------+----------------+
    9 rows in set (0.04 sec)

    mysql> SHOW COLUMNS FROM bc_newsman_lst_default;
    +--------------+---------------------+------+-----+---------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    +--------------+---------------------+------+-----+---------+----------------+
    | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
    | ts | datetime | NO | | NULL | |
    | ip | varchar(50) | NO | | NULL | |
    | email | varchar(255) | NO | UNI | NULL | |
    | status | tinyint(3) unsigned | NO | | 0 | |
    | ucode | varchar(255) | NO | | NULL | |
    | fields | text | YES | | NULL | |
    | bounceStatus | text | YES | | NULL | |
    +--------------+---------------------+------+-----+---------+----------------+
    8 rows in set (0.06 sec)

    mysql> SHOW COLUMNS FROM bc_newsman_sentlog;
    +---------------+------------------+------+-----+---------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    +---------------+------------------+------+-----+---------+----------------+
    | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
    | emailId | int(10) unsigned | NO | MUL | NULL | |
    | listId | int(10) unsigned | NO | | 0 | |
    | recipientId | int(10) unsigned | NO | | 0 | |
    | recipientAddr | varchar(255) | NO | | | |
    | statusMsg | text | NO | | NULL | |
    | errorCode | int(10) unsigned | NO | | 0 | |
    +---------------+------------------+------+-----+---------+----------------+
    7 rows in set (0.01 sec)

    NOT WORKING VERSION

    mysql> SHOW COLUMNS FROM bc_newsman_lists;
    +----------------+------------------+------+-----+---------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    +----------------+------------------+------+-----+---------+----------------+
    | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
    | uid | varchar(255) | NO | | | |
    | name | varchar(255) | NO | | | |
    | tblSubscribers | varchar(255) | NO | | | |
    | title | text | NO | | NULL | |
    | header | text | NO | | NULL | |
    | footer | text | NO | | NULL | |
    | form | text | NO | | NULL | |
    | extcss | text | NO | | NULL | |
    +----------------+------------------+------+-----+---------+----------------+
    9 rows in set (0.00 sec)

    mysql> SHOW COLUMNS FROM bc_newsman_lst_default;
    +--------------+---------------------+------+-----+---------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    +--------------+---------------------+------+-----+---------+----------------+
    | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
    | ts | datetime | NO | | NULL | |
    | ip | varchar(50) | NO | | NULL | |
    | email | varchar(255) | NO | UNI | NULL | |
    | status | tinyint(3) unsigned | NO | | 0 | |
    | ucode | varchar(255) | NO | | NULL | |
    | fields | text | YES | | NULL | |
    | bounceStatus | text | NO | | NULL | |
    +--------------+---------------------+------+-----+---------+----------------+
    8 rows in set (0.00 sec)

    mysql> SHOW COLUMNS FROM bc_newsman_sentlog;
    +---------------+------------------+------+-----+---------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    +---------------+------------------+------+-----+---------+----------------+
    | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
    | emailId | int(10) unsigned | NO | MUL | NULL | |
    | listId | int(10) unsigned | NO | | 0 | |
    | recipientId | int(10) unsigned | NO | MUL | 0 | |
    | recipientAddr | varchar(255) | NO | | | |
    | statusMsg | text | NO | | NULL | |
    | errorCode | int(10) unsigned | NO | | 0 | |
    +---------------+------------------+------+-----+---------+----------------+
    7 rows in set (0.01 sec)

  5. neocoder
    Member
    Plugin Contributor

    Posted 1 year ago #

    Thanks for the investigation. Apparently the plugin update didn't go well. Could you tell me from which version did you update last time? You can look the old version number at the /wp-admin/options.php page, the newsman_old_version option.

  6. greben99
    Member
    Posted 1 year ago #

    The old version is 1.3.8

    I did upgrade it though, when it wasn't working hoping that the new version had the fixed bug. The version I had before that I believe was 1.0.0, as on my PC, the only 3 copies of wpnewsman I have is 1.0.0, 1.3.8, 1.4.5

  7. staceym
    Member
    Posted 1 year ago #

    I just did a brand new install of version 1.4.5 and am having the same problem. I created a list with only two subscribers to do a test run before upgrading to Pro. It sent over one hundred copies of the message to the two subscribers in a matter of seconds until I clicked "stop". I tried all different sending methods and it still did the same thing.

    I tested again with some plugins disabled to check for conflicts. I updated the settings and turned on throttling to 10 messages per minute to prevent it from going crazy, but it still sent 119 messages in a matter of seconds. This is a dedicated server using SendGrid SMTP for mail.

    Have you made any further progress on this issue?

    Thanks.

  8. staceym
    Member
    Posted 1 year ago #

    After further testing, I have determined that this problem occurs when the W3 Total Cache plugin is enabled and database caching is turned on. To solve the problem, go to the W3 Total Cache settings panel and under advanced settings for Database Cache add "wp_newsman_" to the list of "Ignored Query Stems."

    Hope that can save somebody a little time. Cheers.

  9. G-Lock Software
    Member
    Plugin Author

    Posted 1 year ago #

    Thank you for notifying us about the solution. We will add it to our FAQ section on the site and in our KnowledgeBase.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.