Post by oz457 » Fri Aug 10, 2012 1:36 am

Anyone found a solution to this problem. Did the last code change solve the problem? I don't have https enabled on my shop, just plain http, and I get stuck at sending 100 of 160 recipients
Shop version 1.5.3.1

I don't dare sending the same mail again to the other 60 recipients who didn't get any message without upsetting the 100 first ones.

Any update on this issue is welcome.

I just want to add that I have selected a customer group, so not ALL CUSTOMERS, so the problem is not related to the selected recipients, but to a bug? Could it be someone gave a wrong email address and it stops there? The thing is, I did the mailing twice, once it got to 40 recipients. Then I took the same group and then it went to 100 of 160 recipients.
Last edited by oz457 on Fri Aug 10, 2012 1:39 am, edited 1 time in total.

New member

Posts

Joined
Wed Oct 28, 2009 5:33 am

Post by teratyke » Fri Aug 10, 2012 1:39 am

oz457 wrote:Anyone found a solution to this problem. Did the last code change solve the problem? I don't have https enabled on my shop, just plain http, and I get stuck at sending 100 of 160 recipients
Shop version 1.5.3.1

I don't dare sending the same mail again to the other 60 recipients who didn't get any message without upsetting the 100 first ones.

Any update on this issue is welcome.
It could be that one of your customers email fields is empty.
Use phpmyadmin to select all the newsletter subscribers and then sort the table alphabetically by email address, any empty one's should be at the top of the list.
Did you already try that?

Active Member

Posts

Joined
Sun Jun 12, 2011 3:05 pm

Post by oz457 » Fri Aug 10, 2012 4:14 pm

Hi,

have checked the email addresses of the entire database (400 customers). I don't see any problems.

So other people do mailings and have no problems? Also with large(r) databases?

New member

Posts

Joined
Wed Oct 28, 2009 5:33 am

Post by teratyke » Fri Aug 10, 2012 11:33 pm

ADD Creative wrote:I think in admin\controller\sale\contact.php

changing

Code: Select all

						$json['next'] = str_replace('&', '&', $this->url->link('sale/contact/send', 'token=' . $this->session->data['token'] . '&page=' . ($page + 1)));
to

Code: Select all

						$json['next'] = str_replace('&', '&', $this->url->link('sale/contact/send', 'token=' . $this->session->data['token'] . '&page=' . ($page + 1), 'SSL'));
might fix it.

Can anyone test and I will do a Git pull request.

Just sent an email to the Newsletter Subscribers group. I sent without your fix first and it failed, resent after applying your fix and the message sent successfully to the whole list.
Thanks.
Rob

Active Member

Posts

Joined
Sun Jun 12, 2011 3:05 pm

Post by oz457 » Sun Aug 12, 2012 8:54 pm

Same problem. I only get 5 or 6 customers mailed, and that's it. I changed the code as you have written, no solution so far.

Kind regards

New member

Posts

Joined
Wed Oct 28, 2009 5:33 am

Post by ADD Creative » Mon Aug 13, 2012 4:20 pm

oz457 wrote:Same problem. I only get 5 or 6 customers mailed, and that's it. I changed the code as you have written, no solution so far.

Kind regards
That sounds like a different problem, as people have posted, without SSL email sending worked anyway. Could it be something to do with your hosting preventing bulk email?

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by forexengineer.us » Thu Oct 11, 2012 7:09 am

i hope this problem continue to be discussed as i got the same problem. let discuss. :crazy:

New member

Posts

Joined
Sat Jul 21, 2012 1:40 pm

Post by ADD Creative » Thu Oct 11, 2012 7:26 pm

What's your setup as regards to OpenCart version, SSL and email settings?

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by forexengineer.us » Fri Oct 12, 2012 6:25 am

hi. we are using latest version of OC.
SSL? we dont have any SSL. any recommended setting that work in Non-SSL store? Or we can force it up?
Email also using standard email setting like follows :
SMTP timeout : 5
SMTP Port : 25
others follow the standard rules.

how about u ?

New member

Posts

Joined
Sat Jul 21, 2012 1:40 pm

Post by ADD Creative » Fri Oct 12, 2012 4:21 pm

I'm just using the standard settings, but I am using SSL. It might be worth asking your host if they have any limits of sending mail from a server.

How many emails get sent before it fails?
Do you get any error messages?

One thing the might be worth trying is to changes the Mail Protocol to SMTP and fill in all the SMTP fields with the details of a email account.

Check that all the customer's email addresses all look valid without any invalid characters.

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by thysm00 » Tue Dec 02, 2014 12:00 am

Hey Guys,

The SSL patch seems to fix my issue of not sending and the vaue staying at 0 of xxx.

Now, if you have an issue with the newsletter that is blocked while sending, it is often due to the fact that the script is called by the opened page. If there is a small connection failure, then the scripts stops and sending will be stopped as well.
The script sends emails 10 by 10, and increases the "$page" variable.
So in the admin/controller/sale/contact.php page, you can just change

Code: Select all

$page = 1;
to

Code: Select all

$page = thenumberyougotstuckat/10+1;
So basically if you got stuck at 1260, you need to put

Code: Select all

$page = 127;
Then when you relaunch the newsletter sending, it will start from where it was stuck before.
I hope this helps someone, i just avoided sending 2500 people the same email thanks to that ;)

New member

Posts

Joined
Sun Oct 16, 2011 1:53 am
Who is online

Users browsing this forum: No registered users and 2 guests