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

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?

Posted: Tue Oct 10, 2006 4:13 pm

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.

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

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

Posted: Tue Oct 10, 2006 8:39 pm

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

Posted: Tue Oct 10, 2006 8:41 pm

I'm on RN 2.02.02, btw.

Posted: Tue Oct 10, 2006 8:45 pm

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:
http://www.mysite.com/nukesite//modules.php?name=Mailing_List&op=MLActivate&email=myemail@yahoo.com&lid=1&check=1072713987

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.

Posted: Thu Oct 19, 2006 1:23 pm

*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><b>"._ML_ERROR_INVALID."</b></center><br>";


  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><b>"._ML_ERROR_ALREADY."</b></center><br>";


    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><b>".$result['code'].": ".$result['message']."</b></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><b>"._ML_CONFIRSENT."</b></center><br>";


      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><b>"._ML_ERROR_SUBLINK."</b></center>";


} elseif(!$db->sql_query($query2)) {


   $result = $db->sql_error($query);


   echo "<center><b>".$result['code'].": ".$result['message']."</b></center>\n";


} else {


  $result = $db->sql_query("SELECT * FROM `".$prefix."_nsnml_lists` WHERE `lid`='$lid'");


  $list_info = $db->sql_fetchrow($result);


  echo "<center><b>"._ML_MAIN."</b>: ".$list_info['title']."<br>\n";


  echo "<b>"._ML_SUBCOMPLETED."</b></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.

Posted: Thu Oct 19, 2006 1:32 pm

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><b>"._ML_ERROR_SUBLINK."</b></center>";

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

Posted: Thu Oct 19, 2006 11:09 pm

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