close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

opt in email verification - keeps saying link expired

Thread began 11/10/2016 11:41 am by russell298997 | Last modified 1/05/2017 11:16 am by Ray Borduin | 1040 views | 9 replies |

russell298997

opt in email verification - keeps saying link expired

Hi, ploughing thru this double opt-in registration (really thoro tutorial - excellent- thanks!) and running it live, i register ok, i get the email verification link ok, but when i click the link and go to

http://www.fhcsolution.co.uk/user-confirm.php?id=2&randomstring=5ino7d&email=russell@severndesign.co.uk

i get the message:

Your verification link has expired. Visit your profile page to send a new link.

dont understand why it doesnt verify. so far as i can see it has the three variables it should be passing and the email address is correct - probably my bad somehwere i'm sure - any ideas?

thanks in advance guys and keep up up the fab work

Attached Files
WAfiles.zip
Sign in to reply to this post

Ray BorduinWebAssist

The code looks correct to me on the confirm page. Is the random string stored correctly in the database? If you gave me FTP access I could go through the process and debug it along the way to figure out what is wrong.

Sign in to reply to this post

Ray BorduinWebAssist

I see that your code on lines 40-41 refers to: randomString, but the url parameter in the url is: randomstring. The capitol 'S' will make a difference. Try changing that in the emailed url and that should fix the problem.

Sign in to reply to this post

russell298997

see PM

Sign in to reply to this post

Ray BorduinWebAssist

Somehow your recordset is out of sync. It had on line 39 the parameter defined: $paramrandomstring_rsVerify

But then in the recordset it was referred to as: $paramrandomString_rsVerify

The case sensitivity. It probably didn't update properly when you tried to change it.

The resend confirmation link worked for me from the update page, so I'm not sure what the issue was with that, but it appears to be resolved.

Sign in to reply to this post

russell298997

Thanks. Whatever happened it worked for me now so grateful for your intervention. When I did subsequently log in I thought I'd told it to take me to questionnaire.php but it took me to the login page again saying I WAS logged in. Presumably that's just a tweak somewhere to the 'if successful' redirect. If you know offhand where I need to tweak that it'd be handy but otherwise I'll take a trawl thru.
Thanks as ever Ray

Sign in to reply to this post

Ray BorduinWebAssist

The login redirect is a setting in the login server behavior. Changing it won't cause any issues.

Sign in to reply to this post

russell298997

Hi Ray - quickie - i got the same problem as above with paramrandomString problem i think - may bne due to me making small update to userconfirm page and overwriting what you changed i think - i'm just not sure whether i should be changing the instance on line 39 to lower case or vice versa - i presume its the code here from 39-52 that needs to be in sync

$paramrandomstring_rsVerify = "1";
if (isset($_GET['randomstring'])) {
$paramrandomstring_rsVerify = $_GET['randomstring'];
}
$paramemail_rsVerify = "1";
if (isset($_GET['email'])) {
$paramemail_rsVerify = $_GET['email'];
}
mysql_select_db($database_fhcdbase, $fhcdbase);
$query_rsVerify = sprintf("SELECT * FROM users WHERE UserID = %s AND users.randomString = %s AND users.UserEmail = %s AND users.randomString <> '0'", GetSQLValueString($colname_rsVerify, "int"),GetSQLValueString($paramrandomString_rsVerify, "text"),GetSQLValueString($paramemail_rsVerify, "text"));
$rsVerify = mysql_query($query_rsVerify, $fhcdbase) or die(mysql_error());
$row_rsVerify = mysql_fetch_assoc($rsVerify);
$totalRows_rsVerify = mysql_num_rows($rsVerify);?>
<?php

which lines do i change?!

Sign in to reply to this post

Ray BorduinWebAssist

GetSQLValueString($paramrandomString_rsVerify, "text")

should be:

GetSQLValueString($paramrandomstring_rsVerify, "text")

Sign in to reply to this post

russell298997

Got it! Thanks Ray

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...