Thread: Mass Mailer - notifies - supplied argument is not a valid MySQL result resource

Hi

Cron seems to be not working - error message.

- Start email send -
Total queued emails: 3
Ready for send: 3

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wayno/public_html/mysite/periodic/notifies.php on line 165

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wayno/public_html/mysite/periodic/notifies.php on line 184

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wayno/public_html/mysite/periodic/notifies.php on line 202
Processed emails: 1
Processed emails with errors: 0


so when sending out mail through the mass mailer

only people who have signed up for the news letter recieves it

and not the members.

Send to members and send to subscribers have been checked

and members have opted to recieve mail but do not get any?

any advice please?

Many thanks

Wendy

OK

Maybe I can put this another way.

Has anyone got cron fully working with 6.0.1

Many thanks

Wendy

nope - have the same problem - so you're not alone. my crons are right, I've edited the notify.php file and added @ before the mysql on the lines listed, but all that done was stop the error coming up - still doesn't send - sits :

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

like that. would be good if somebody knew anything about the sql sends in the notify file and now they link with sendmail.

checking notifies.php - you folks will see.... that this query is used for the latter work in the code:

Code:

SELECT
				NotifyQueue.Email as ID1,
				NotifyQueue.Msg as ID2,
				Profiles.RealName as Name,
				Profiles.Email,
				NotifyMsgs.Subj,
				NotifyMsgs.HTML as Body
			FROM NotifyQueue
			
			INNER JOIN NotifyMsgs
			ON (NotifyMsgs.ID =  NotifyQueue.Msg)
			
			INNER JOIN Profiles
			ON (Profiles.ID = NotifyQueue.Email)
			
			WHERE
				NotifyQueue.`From` = 'Profiles' AND
				Profiles.EmailNotify  = 'NotifyMe' AND
				Profiles.EmailFlag = 'HTML'";

this query has no variables in it (it is ok as is) - so you can run it in mysql - and see what happens.... doing that results in:

Code:

SELECT NotifyQueue.Email AS ID1, NotifyQueue.Msg AS ID2, Profiles.RealName AS Name, Profiles.Email, NotifyMsgs.Subj, NotifyMsgs.HTML AS Body
FROM NotifyQueue
INNER JOIN NotifyMsgs ON ( NotifyMsgs.ID = NotifyQueue.Msg )
INNER JOIN Profiles ON ( Profiles.ID = NotifyQueue.Email )
WHERE NotifyQueue.`From` = 'Profiles'
AND Profiles.EmailNotify = 'NotifyMe'
AND Profiles.EmailFlag = 'HTML'
LIMIT 0 , 30

MySQL said:
#1054 - Unknown column 'Profiles.RealName' in 'field list'

Checking the Profiles table... there is NO

Code:

RealName

field - thus - the bug/problem.

Changing

Code:

Profiles.RealName AS Name

to

Code:

Profiles.NickName AS Name

results in an SQL query with no errors.

I'm I a genius or what.

Give it a try on your site(s). I did not test it - just ran some queries in mysql to test the faulty query and fix to end up with a "clean" one.

Smoge

oh - my check and possible fix was in 6.0.1 - but perhaps 6.0.0 is the same?

Question is - how could such an issue be missed in the beta testing, v6.0.0 release, AND the 6.0.1 release.

Oh well - tell me if it works.

Smoge

Originally Posted by Smoge

checking notifies.php - you folks will see.... that this query is used for the latter work in the code:

very cool you explain how you found fix the problem

we all can learn to do same

null_master

Yes Smoge

It now works with no errors.

and yes indeed you are a genius

Many thanks

Wendy

I concur Genius you are - thanks a lot mate, really appreciated.

My "genius" comment was sarcastic... it was only to show how I troubleshooted the problem - this is why I put all the steps I did in the post - to show you folks an example of how to trouble shoot issues.

There is no "genius" to it - just a set of steps to find the problem and fix it. This is what I was trying to get across.

Smoge