Emails dont stop sending.

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].

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

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)

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.

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

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.

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.

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