SMFHacks.com
Newsletter Pro => Support => Topic started by: Rickardm on July 03, 2012, 02:39:32 am
-
I have more then 5000 members in one of my forums, sent a newsletter to all members, but it seems to have stopped at 2523 sent letters.
Any idea why?
My web host doesnt have any limitations.
Can it have with session time to do?
This is a question that will effect if i buy 2 more licenses, to my two larger forums, with more then 40 000 members.
-
What SMF Version?
And what happened did the page timeout? Or were you using a campaign?
-
SMF 2.0.2 with theme CSmanul (by crip).
No campaign, just an ordinary newsletter to all members.
I let the page show all the time, and the % was counting up to about 40%, left the computer, and when i came back i was forced to login in administration again, and i noticed that all members didnt get there letter.
I feels like the newsletters stopped going out when the admin login session elapsed?
-
I feels like the newsletters stopped going out when the admin login session elapsed?
I think that might be the case. I would check the "Disable administration security" for now when sending the newsletter. Will probably do an update to turn if off while sending a newsletter then turn it back on when the newsletter is completed
-
Is there some way of sending the next message just to member 2523 - last one?
Or will i need to disturb all those who already gotten it?
Sending 35 000 newsletters to my members in varmepumpsforum.com will take quite a few hours, is there a risk turning admin safety off?
-
Trying to send the message just to one person member 2523? Or where it left at from member id 2523 and higher
-
i would like to send it to member 2524 and up to the last one, member 5313.
-
Sending 35 000 newsletters to my members in varmepumpsforum.com will take quite a few hours, is there a risk turning admin safety off?
No big risk. That security is only there mainly to prevent cross site scripting such as when an admin clicks a bad link. As long as your just doing normal tasks your fine.
I am thinking the best way to complete the rest of mailing would use a an sql query on your database to get the list then export it
SELECT email_address FROM smf_members where id_member >= 2524
Export and csv then upload the list into the newsletter pro.
-
Mmm, i dont use mysql-commands myself, but i guess i can buy that service to.
Am i the first one who tries to send thousands of newsletters with newsletter PRO?
-
I can write a quick script if that helps that you can run. Attached below save as a script.php and upload to the root of your website.
<?php
require 'SSI.php';
$request = $smcFunc['db_query']('', "
SELECT email_address
FROM {db_prefix}members
WHERE ID_MEMBER >= 2524
");
while ($row = mysql_fetch_assoc($request))
{
echo $row['email_address'] . '<br />\n';
}
?>
I have used newsletter pro on this site. And on my main sites with tens of thousands of members.
I also run a marketing company which I built an email system which can scale into sending millions per day but that is more expensive unless you are doing high volumes.
-
I have a lot of sites on my server, with root, do you mean in poolforum.se if the forum is in: home/d12345/poolforum.se/forum ?
-
Would be in poolforum.se/forum
-
Does the script run by it self, or do i need to give it a commando of some sort?
The script is in place, and i have updated the email adress.
Nothing happens yet.
-
Hmm you just have to view it in the browser
Retry this
<?php
require 'SSI.php';
$request = $smcFunc['db_query']('', "
SELECT email_address FROM {db_prefix}members WHERE ID_MEMBER >= 2524
");
while ($row = mysql_fetch_assoc($request))
{
echo $row['email_address'] . '<br />';
}
?>
And then visit http://poolforum.se/forum//script.php in your browser
-
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
-
OK, noticed it was new code, updated the script, and did download a *.ps file that i cant open with any program i have installed.
-
Yeah I see that on your site.. I am not sure why though...It works on my test site fine that is running 2.0 make sure you grab the latest script above.
Save it as .txt file and try to upload the list to the newsletter system.
-
My misstake.
I changed the email_adress to my own adress, i did think there would be a list comming in my mailbox... :-[
No i have restored it, but I doesnt seem to be able to run the script again.
Trying another browser.
-
nothing happens when i try to run the script again, or does it take time?
-
Strange.
Viagra spammers can send millions of professional looking spam email every hour of the day, but i who really need a newsletter that works cant find anything that doesn't cost more than i can get from my sponsors in order to be seen in my newsletters...
Your newsletter PRO could be a solution, but i don't have limitless of time to get it to work.
I do appreciate your efforts to help me.
-
Looks like a permission issue I can't see the script either on my end on your site says a 404 error. If you can/wish you can send me an ftp login by pm and I can try to run the script to get the email data.
-
I changed the script name in so everybody else shouldnt be able to download my members email adresses.
script2.php