Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: rcane on June 26, 2024, 12:04:00 AM

Title: tracking messages sent to PM from newsletter
Post by: rcane on June 26, 2024, 12:04:00 AM
I have 1600 members.

Normally when I send a message out using newsletter it chews on it (showing percentages of completion for a few minutes).

This one sent instantly and as far as I can tell there were no errors.

Which table would i look into in order to find the message and confirm it was sent to at least one person?  I just need to take a small sampling.

Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on June 26, 2024, 12:23:54 AM
I tested it by sending to a member group with only 3 members and it did the usual (1.5%, 5.3%, etc) to complete it.  When i did the 1600 membergroup it just instantly sent off, and I cannot see any messages in smf_personal_messages...if that's even the table where newsletters are stored.

I'm sure I'm not asking the proper question or providing something. 

Permissions says everyone can send and receive PM

Also, in the logs I see "sent newsletter" from a few days ago, but it doesn't even show the successful newsletter "test" i sent to the 3-member membergroup.

Title: Re: tracking messages sent to PM from newsletter
Post by: Illori on June 26, 2024, 04:39:20 AM
by default the newsletter is sent to the users email and not via PM unless you select that option.
Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on June 26, 2024, 09:47:46 AM
Quote from: Illori on June 26, 2024, 04:39:20 AMby default the newsletter is sent to the users email and not via PM unless you select that option.

I did use the PM option
Title: Re: tracking messages sent to PM from newsletter
Post by: Doug Heffernan on June 26, 2024, 10:27:34 AM
Quote from: rcane on June 26, 2024, 12:04:00 AMWhich table would i look into in order to find the message and confirm it was sent to at least one person?  I just need to take a small sampling.

For the pms you would need to look at the smf_personal_messages and smf_pm_recipients tables.
Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on June 26, 2024, 10:30:33 AM
Ok, I'm not seeing it there.  I was looking in the proper place.

Is there a limit on the max number of personal messages you can send at once using NewsLetter?

I just clicked 'regular members'  (1600) and clicked the advanced option to override alerts being set to off.

Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on June 26, 2024, 10:45:35 AM
I've sent PM using newsletter to another group last week (600 folks in that) and it worked.

Is there perhaps a max number?
Title: Re: tracking messages sent to PM from newsletter
Post by: Doug Heffernan on June 26, 2024, 02:09:42 PM
Quote from: rcane on June 26, 2024, 10:45:35 AMIs there perhaps a max number?

Do you mean as in how many users pms can be sent? If that's the case then no a.f.a.i.k.
Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on June 26, 2024, 03:33:17 PM
ok, that rules that out.

Newsletter sent them all as emails fine as far as I can tell (my server meters up to 500 emails per hour, but they did go through).

But, as PM, i'm not seeing them anywhere when sent by checking the box next to a membergroup (and not the EXCLUDE options...the check boxes at the top of the page).
Title: Re: tracking messages sent to PM from newsletter
Post by: shawnb61 on June 26, 2024, 05:21:03 PM
I have never sent a newsletter, so take this with a grain of salt...

I believe when you click the "Send as PMs" option, they are sent as PMs only...  No email.  I believe it's an either/or thing. 

And when sending as PMs, there is no mail queue involved, so that should go very quickly - no countdown.  (It's just a DB update, no need to throttle, like email...)

I don't think there is any log of PMs sent, other than querying the PM & PM recipient tables itself.
Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on June 26, 2024, 05:31:31 PM
Yes, one or the other.  That's certain.

I have seen countdowns when sent as PM's--sometimes even when it's just 5 or less.

yeah, it definitely seems like if i send it to just "Regular Members" they aren't going through.
Title: Re: tracking messages sent to PM from newsletter
Post by: shawnb61 on June 26, 2024, 07:55:29 PM
I suspect the countdown when sending PMs is to check which users who have opted to receive an email notification for new PMs...  It still has to go thru the motions to check.

I just tested sending a PM to all "Regular Members" in 2.1 & it worked fine.

A query like this might help check what really went out:

SELECT id_member_from, from_name, subject, from_unixtime(msgtime), count(*) AS pm_count
FROM smf_personal_messages AS pm
INNER JOIN smf_pm_recipients AS pr
ON pm.id_pm = pr.id_pm
WHERE id_member_from = 1
GROUP BY subject, pm.id_member_from
ORDER BY msgtime DESC, subject DESC, pm.id_member_from DESC
LIMIT 5;

Change the id_member_from in the WHERE clause to your ID. 
Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on June 26, 2024, 10:36:16 PM
NOPE, query good...no messages sent
Title: Re: tracking messages sent to PM from newsletter
Post by: Steve on June 30, 2024, 06:37:49 PM
Status?
Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on July 04, 2024, 07:59:52 PM
I have not needed to send another mass message.  Unfortunately it will be a spell before I do.
Title: Re: tracking messages sent to PM from newsletter
Post by: Steve on July 05, 2024, 08:20:05 AM
Then I'll mark it 'Paused' until you respond.  :)
Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on July 26, 2024, 01:37:02 PM
I just sent another PM out to 1600 folks, and nothing appears to have gone out.  using 2.0.19.

I checked the table personal_messages and the number of messages hasn't changed.  It's been about 10 minutes.

I checked a test account that i have (you know, to test additional groups and such), and that account has no new messages either.

If i manually add some names (not emails) it will send.   I haven't tested a max number of recipients.


Permissions show regular members can send and receive PM.
As far as I can tell, admin is exempt from and limit of #'s of PM
Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on July 26, 2024, 03:59:11 PM
so, i was able to send it to everyone if I selected all the member groups. 

regular members has everyone shown in parenthesis next to it, so I'm confused as to why other groups would need to be checked.  I wasn't using the exclude options--only the include groups.
Title: Re: tracking messages sent to PM from newsletter
Post by: Arantor on July 26, 2024, 06:57:57 PM
Regular members = users that have *no primary member group*. If your users all have primary member groups, regular members will match no-one.
Title: Re: tracking messages sent to PM from newsletter
Post by: rcane on July 26, 2024, 07:13:39 PM
Well it's been a while since I did anything stupid so thanks for that.

Haha. Really thank you.  I'll make a group called general or something and plug folks in there.