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

Double opt in problem

Thread began 1/30/2014 9:48 pm by david323147 | Last modified 1/31/2014 5:02 pm by Jason Byrnes | 1057 views | 9 replies |

david323147

Double opt in problem

I have followed the video tutorial several times and keep having problems. The verification email is sent but when the verification link is clicked, the page that loads is blank and the emailVerified row of the db does not update from 0 to 1. The URL for the verification link is in this format - http://www.letsparksfly.com/userconfirm.php?id=1&randomString=t6he9m&email=dgwebs@gmail.com. All of the variables are correct. In this instance, the userID is 1, the randomString is correct (based on the one showing in table), and the email is correct.

In the tutorial at 22:53 of the video tutorial a session value is being added to the userconfirm page and in the dialog box that appears, the session variable name defaults to emailVerified. I do not have a session variable of emailVerified available. I notice earlier in the video that session variable appears in the bindings panel but it is has never appeared in mine in any of the six times I've tried this. Could that be my problem?

Many thanks for your help!

Sign in to reply to this post

Jason ByrnesWebAssist

if the session binding does not get created automatically, you may need to create it manually.

on the bindings panel, click the plus button, select Session and enter the name for the session binding.

sometimes the sites _notes folder can become corrupted and cause creating new bindings to fail.

use the OS File System explorer to browse to the site and delete the _notes folder if you are not able to manually create the binding.


can you send a copy of the userconfirm.php file so i can see how it is set up.

Sign in to reply to this post

david323147

I created the session binding manually and tried again. Still the same result. I'm attaching both the userconfirm.php and the email form in case the problem might be there. My userconfirm.php page doesn't contain links to log in because once the user verifies him/herself, a representative from the company will be in touch with them via phone and the user doesn't have any need to access any of the profile information.

Sign in to reply to this post

Jason ByrnesWebAssist

visiting your original link shows a blank page.

a blank page means that a php error is occurring but error reporting is turned off.

to turn error reporting on, add the following code at line 1:

<?php
error_reporting(E_ALL);
ini_set('display_errors','on');
?>



once we know what the error is, we will be able to troubleshoot the cause.

Sign in to reply to this post

david323147

First off, thanks so much for your help Jason!

Okay, I added that code and it immediately said there was a syntax error on line 48 but I do not know what that error is. I'm attaching the updated file.

Sign in to reply to this post

Jason ByrnesWebAssist

ok, the syntax error is the use of squiggly brace where a square bracket should be.

line 47 - 50:

$paramemail_rsVerify = "-1";
if (isset($_GET['email'})) {
$paramemail_rsVerify = $_GET['email'};
}



should be:

$paramemail_rsVerify = "-1";
if (isset($_GET['email'])) {
$paramemail_rsVerify = $_GET['email'];
}
Sign in to reply to this post

david323147

Ahhhhhhhh!!!! Thank you so much Jason!

Sign in to reply to this post

Jason ByrnesWebAssist

no worries.

when creating the paramemail variable in the recordset, you where entering:
$_GET['email'}

as the run time value instead instead of:
$_GET['email']

Sign in to reply to this post

david323147

The weird thing is, each time I tried this I was positive I entered it proprely. Obviously, I was wrong!

Thanks again. The video tutorial is great, by the way. I feel like the woman who recorded it and I are now close friends since I listened to her so many times.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

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...