[RESOLVED] sql error?

Posted: Sat Sep 03, 2005 3:53 pm

Hi, installed the newsletter today and have run into a problem.
I can add categorys, I can use the main config and seems everything else is working find except when I go to send a newlsetter or use "send tested"

If I try a send tested I get
view = 1
groups = 1
filename = 1125776998.php
sql = SELECT user_id, user_email FROM nuke_users WHERE user_email > ''
Total Emails Sent: 2
(it does not send the mail)

If I create a newsletter I can preview it fine but when I got to send it I get the same :
view = 1
groups = 1
filename = 1125776998.php
sql = SELECT user_id, user_email FROM nuke_users WHERE user_email > ''
Total Emails Sent: 2

id take a guess since it's got the sql line in there that something is amiss in the database but I really don't know a damn thing about sql work or enough about php coding to feel safe enough to go toying around.
Has anyone seen this problem before?
Thanks for any info in advance.

Posted: Sat Sep 03, 2005 3:54 pm

PhPnuke 7.6 3.0

Site Admin Joined: Jul 18, 2005 Posts: 383

I have not had a problem with this at all.
The sql echo would probably be because you have 'debug' turned on in the config - this will also prevent the test newsletter from being sent.

Posted: Sat Sep 03, 2005 7:32 pm

Looks like that worked. Thanks.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

Wow, Guardian, you are too quick for me! Sorry, cannot aford to add you to the "payroll". Laughing

But, you nailed it!

Thanks!

montego

Site Admin Joined: Jul 18, 2005 Posts: 383

Not a problem glad to help out if/when I can.