Mass Mailer not working

Hi, I've spent a lot of time trying to get my mass mailer working with no success. Firstly, I've read every topic on the forum and I've done everything suggested.

My cron jobs are set up correctly, I'm getting reports that say this:

- Start email send -
Total queued emails: 2
Ready for send: 2
Processed emails: 0
Processed emails with errors: 0

The emails do not send and the reports just stay that way.

I've also modified admin/notifies.php, changing `EmailNotify` = 'NotifyMe'  to `EmailNotify` = '0' but still, it doesn't work.

I'm currently looking in periodic/notifies.php and have noticed that this code:

SELECT
NotifyQueue.Email as ID1,
NotifyQueue.Msg as ID2,
NotifyEmails.Name as Name,
NotifyEmails.Email,
NotifyMsgs.Subj,
NotifyMsgs.HTML as Body
FROM NotifyQueue
INNER JOIN NotifyMsgs ON
(NotifyMsgs.ID =  NotifyQueue.Msg)
INNER JOIN NotifyEmails ON
(NotifyEmails.ID = NotifyQueue.Email)
WHERE
NotifyQueue.`From` = 'NotifyEmails' AND
NotifyEmails.EmailFlag = 'NotifyMe'
LIMIT $total_per_query

doesn't actually return any results when run in phpMyAdmin. I removed the LIMIT on the last line and also changed 'NotifyMe' to 0 with no success.

Can anyone help?

My NotifyEmails table that code is refering to doesn't contain any data. Can anyone confirm what is the purpose of that table and how is it populated with data? There's an insert statement in admin.inc.php but when is it run by the script?

I am having the same problem.  Surely somebody out there has some insight... Thank you in advance

I managed to resolve this. You may need to change `EmailNotify` = 'NotifyMe' to EmailNotify` = '0' in admin/notifies.php. If you're going to use the value of 0 for EmailNotify then you'll also need to change:

Profiles.EmailNotify  = '1'

to

Profiles.EmailNotify  = '0'

in periodic/notifies.php.

The reason I had trouble was because my database has been migrated from a different social network platform and as such there has been the occasional mismatch with fields and data.

The only problem I have with the mass mailer now is that my previous database didn't require a users gender to be entered, where as Dolphin does but the mass mailer will only send emails to users that have a gender specified.

I need a fix to this code to select users that are either male, female or null if anyone can help:

SELECT `ID` FROM `Profiles` WHERE `Status` <> 'Unconfirmed' AND `EmailNotify` = '1' $sex_filter_sql $age_filter_sql $country_filter_sql

Having just had a quick look at the variable $sex_filter_sql in admin/notifies.php, it appears to be empty. Does this feature actually work in Dolphin?

This worked perfectly for me - thanks!