My registration form sends a link to the recipients email, then when we click the verification link we only get "Your verification link has expired go to your profile page so a new link can be sent", how do I fix this problem?

1) I'm creating a 'Double Opt in Registration system'
2) I'm using my own data base table called fm_reg
3) I've noticed that on the Registration page's server bindings' Session, has "SecurityAssist_UserID. Did WA create this when it created all the pages in the beginning of the tutorial?
4) Is this the correct variable for me to use? Given I need my database table to be used.
5) Should the session variable be SecurityAssistfmregtbl_regID?
6) Could this be the reason my verification link goes straight to "Your verification link has expired...etc"?

I am completely new to web building but I am ready to learn. I apologise if this seem confusing as I do not understand all the jargon as yet.
Thank you for the tutorial and videos.
Deeanna

on the registration page, the table being used is the users table, and the name of the session being created is SecurityAssist_UserID the first few lines of the insert behavior set this:

<?php
// WA DataAssist Insert
if ((isset($_POST["Registration_submit"]) && $_POST["Registration_submit"] != "")) // Trigger
{
$WA_connection = $classroomConn;
$WA_table = "users";
$WA_sessionName = "SecurityAssist_UserID";


when you click the link in the email, what is the full address in the address bar, I'm betting the email or ID are missing from the URL which is causing the rsVerify recordset to be blank.

Oh Jason I'm soooo impressed with your quick and timely responses. I read other peoples appreciation for your quick response but did not think it would happen to me. So as I was trying to learn and sort my problem I messed the page and had to start again. I did get to fall on my back up. :(

I will be waiting on your reply in the future.
Deeanna

The insert record behavior on the Registration page.

Open the registration page, then open the server behaviors panel (Window -> Server Behaviors)

In the server behaviors list, look for the insert record server behavior.

Hi

Email Link now works:<a href="http://www.affinitysounds.com/user-confirm.php?id=5&randomString=p9aj7j?email=john@phonejockeyrecords.com">Click here to verify your email address</a>

But user confirm instantly reports "link has expired" and update doesn't work either.

Thank you. I hope I'm nearing the end with these problems (my goofs).

I'll need to troubleshoot directly, see the private message section.

Jason, thanks.

Please see the attached private site and login details.

Hi Jason
I have redone my Registration page and now I am trying to connect the correct email code. Should I copy the format of 'beaded' in the above message he sent?

Originally Said By: Jason Byrnes

  on the registration page, the table being used is the users table, and the name of the session being created is SecurityAssist_UserID the first few lines of the insert behavior set this:

<?php
// WA DataAssist Insert
if ((isset($_POST["Registration_submit"]) && $_POST["Registration_submit"] != "")) // Trigger
{
$WA_connection = $classroomConn;
$WA_table = "users";
$WA_sessionName = "SecurityAssist_UserID";


when you click the link in the email, what is the full address in the address bar, I'm betting the email or ID are missing from the URL which is causing the rsVerify recordset to be blank.  

Hi Jason,
It still does not work.