NSN Mailing List - Can't signup / Validate Email (FIXED!)

srhh · Involved Joined: Dec 27, 2005 Posts: 296

I just installed the NSN Mailing list. I try to sign up for a list, then click on the validation link it send to my e-mail. I get a page saying "The link is not valid!"
Any ideas?

srhh · Involved Joined: Dec 27, 2005 Posts: 296

I just checked my database and the information is getting to the database, it just isn't validating and thus doesn't show me as a subscriber.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4887

Are you tapped (i.e. using a URL rewriting scheme)?

srhh · Involved Joined: Dec 27, 2005 Posts: 296

I would have to say 'no' cuz I have no idea what that is. Smile

I do vaguly remember something about URL rewriting when I installed Gallery. I think it said to turn it off.
Maybe I'm confused.
Wait, no scratch that. I'm definatly confused.

Wink

srhh · Involved Joined: Dec 27, 2005 Posts: 296

I'm on RN 2.02.02, btw.

srhh · Involved Joined: Dec 27, 2005 Posts: 296

Ooo, I think I'm onto something. I don't think the clicky-URL in the email is being formated right. Here is the URL I got:

Only registered users can see links on this board!
Get registered or login to the forums!

Now if you look, there are two of "/" after the .com/nukesite
I took out the extra / and I still get the invalid link error.

srhh · Involved Joined: Dec 27, 2005 Posts: 296

*bump*

Anyone? I reformated my $nukeurl so there wasn't that extra "\" and still no go. Also tried re-uploaded and re-installing to.

So here is the code from modules/Mailing_List/public/MLAction.php that first puts together the confirmation URL

Code:

$pagetitle = " - "._ML_TITLE." ".$ml_config['version_number'];
include("header.php");
title(_ML_TITLE." ".$ml_config['version_number']);
OpenTable();
if(!preg_match("/@/", $email)) {
echo "<center>"._ML_ERROR_INVALID."</center> ";
echo "<center>"._GOBACK."</center>";
} elseif($sub == 'sub') {
$mid = $db->sql_numrows($db->sql_query("SELECT * FROM `".$prefix."_nsnml_users` WHERE `email`='$email' AND `lid`='$lid'"));
if($mid > 0) {
echo "<center>"._ML_ERROR_ALREADY."</center> ";
echo "<center>"._GOBACK."</center>";
} else {
srand ((double)microtime()*1000000);
$mycode = rand();
$joined = time();
$query = "INSERT INTO `".$prefix."_nsnml_users` VALUES (NULL, '$lid', '$email', '0', '$type', '$mycode', '$joined')";
if(!$db->sql_query($query)) {
$result = $db->sql_error($query);
echo "<center>".$result['code'].": ".$result['message']."</center>\n";
} else {
$buildlink = "$nukeurl/modules.php?name=$module_name&op=MLActivate&email=$email&lid=$lid&check=$mycode";
mail($email, _ML_SUBSCRIPTION, _ML_CONFIGTEXT."\n\n$buildlink", "From: $adminmail");
echo "<center>"._ML_CONFIRSENT."</center> ";
echo "<center>"._GOBACK."</center>";
}

I'm getting the confirmation e-mail and URL correctly. (I compared it with another functioning Mailing List system)
and here is the code from modules/Mailing_List/MLActivate.php:

Code:

$pagetitle = " - "._ML_TITLE." ".$ml_config['version_number'];
include("header.php");
title(_ML_TITLE." ".$ml_config['version_number']);
OpenTable();
$query2 = "UPDATE `".$prefix."_nsnml_users` SET `active`='1', `act_key`='0', `joined`='".time()."' WHERE `email`='$email' AND `lid`='$lid'";
$result = $db->sql_query("SELECT * FROM `".$prefix."_nsnml_users` WHERE `email`='$email' AND `act_key`='$check' AND `lid`='$lid'");
if($db->sql_numrows($result) != 1) {
echo "<center>"._ML_ERROR_SUBLINK."</center>";
} elseif(!$db->sql_query($query2)) {
$result = $db->sql_error($query);
echo "<center>".$result['code'].": ".$result['message']."</center>\n";
} else {
$result = $db->sql_query("SELECT * FROM `".$prefix."_nsnml_lists` WHERE `lid`='$lid'");
$list_info = $db->sql_fetchrow($result);
echo "<center>"._ML_MAIN.": ".$list_info['title']." \n";
echo ""._ML_SUBCOMPLETED."</center>";
}
CloseTable();
include("footer.php");

My feeling is the problem is from the MLActivate.php and the fact I'm on a subdomain, but just can't track it down.

srhh · Involved Joined: Dec 27, 2005 Posts: 296

I like trying to figure things out, so in MLActivate.php, this is what is calling up the invalid link error, right?

Code:

if($db->sql_numrows($result) != 1) {
echo "<center>"._ML_ERROR_SUBLINK."</center>";

But I'm stuck on what ever that means. It's not reading the database correctly ?

srhh · Involved Joined: Dec 27, 2005 Posts: 296

Interesting.
It works now.

I de-activated an add-on module that I guess was causing conflicts.
In the words of the immortal Rodney King, Why can't we all just get along?
Wink