Author |
Topic  |
Rtwhite
Starting Member
USA
27 Posts |
Posted - 24 November 2008 : 11:57:10
|
Our forum board appears to be setup to require new users to "Require Unique E-mail" with "E-mail Validation" but new users never appear in the table that shows me a list of registered users that are waiting to be authenticated. New users are added without e-mail valadation. Can someone please help me figure out why this is happening? Any help will be greatly appreciated.
Thanks, R T White< |
|
Podge
Support Moderator
    
Ireland
3776 Posts |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 24 November 2008 : 12:53:01
|
the list of users are thse that HAVE NOT validated their emails, if your new members are not validating then they will ALL appear in the list, if they are not, then they must be validating their email on registering.
what exactly makes you think that they are not validating? if email wasn't working then evry attempted registration would appear in the waiting to be authenticated list.< |
 |
|
Rtwhite
Starting Member
USA
27 Posts |
Posted - 24 November 2008 : 13:57:16
|
Response to Podge,
That may well be the problem. I have noticed that when I attempt to send an email to a member I receive the following error message.
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'rs'
/supportforum/pop_mail.asp, line 202
When you ask, "Where is your forum" are you asking about the website address? If yes it is at http://www.salem-baptist.com being hosted by Parcom.
Response to HuwR,
What makes me think they have not valiaded their emails is that they appear as members in the members list but I have not approved them from the list.
quote: Originally posted by Podge
Is email enabled on your board ? Where is your forum ?
< |
 |
|
Carefree
Advanced Member
    
Philippines
4217 Posts |
Posted - 24 November 2008 : 14:06:55
|
Please provide a link to your pop_mail.asp in .txt format. Since that line doesn't refer to "rs" in the stock Snitz, we'll need to see what modifications you've made in order to help.< |
 |
|
Classicmotorcycling
Development Team Leader
    
Australia
2085 Posts |
Posted - 24 November 2008 : 14:08:09
|
Have you checked Google.com for your error? There are way to many for me to tell you what is wrong, as they are pretty much the same.
The reason they would like to know where the site is, as it makes it easier to help and test.< |
Cheers, David Greening |
 |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 24 November 2008 : 14:45:57
|
quote: Response to HuwR,
What makes me think they have not valiaded their emails is that they appear as members in the members list but I have not approved them from the list.
You don't have to approve them for email validation to work, you only need to approve them if you have 'restrict registration' enabled. like I said, if they DON't appear in the lsit then they HAVE validated their email, if they are in the lsit then they HAVE NOT validated their email, that is exactly how it is suppoed to work< |
 |
|
Rtwhite
Starting Member
USA
27 Posts |
Posted - 24 November 2008 : 15:59:50
|
That's the problem. I do have restrict registration on.
quote: Originally posted by HuwR
quote: Response to HuwR,
What makes me think they have not valiaded their emails is that they appear as members in the members list but I have not approved them from the list.
You don't have to approve them for email validation to work, you only need to approve them if you have 'restrict registration' enabled. like I said, if they DON't appear in the lsit then they HAVE validated their email, if they are in the lsit then they HAVE NOT validated their email, that is exactly how it is suppoed to work
< |
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
Posted - 24 November 2008 : 16:38:53
|
So, just for clarity, you have "Restrict Registration" turned on, as well as "Require Unique E-Mail" and "Require E-Mail Validation"?< |
 |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 24 November 2008 : 17:04:18
|
if you have not modified the code in anyway then there is no way that users can just register without your approval if you have restrict registration turned on, it is simply not possible.
also, email validation happens AFTER you have approved the user not before.< |
 |
|
pwhitehurst
Starting Member
United Kingdom
18 Posts |
Posted - 24 November 2008 : 19:42:28
|
quote: Originally posted by Carefree
Please provide a link to your pop_mail.asp in .txt format. Since that line doesn't refer to "rs" in the stock Snitz, we'll need to see what modifications you've made in order to help.
I've got the original stock snitz 3.4.06 code for pop_mail.asp and on line 202 it does have rs
Response.Write " <p><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>Click to send <a href=""mailto:" & chkString(rs("M_EMAIL"),"display") & """>" & strRName & "</a> an e-mail</font></p>" & vbNewLine end if
I presume rs is short for the record set which is returned higher up in the code around line 47
'## Forum_SQL strSql = "SELECT M.M_RECEIVE_EMAIL, M.M_EMAIL, M.M_NAME FROM " & strMemberTablePrefix & "MEMBERS M" strSql = strSql & " WHERE M.MEMBER_ID = " & intMemberID
set rs = my_Conn.Execute (strSql)
Sounds like the email is not configured right in the admin options . But as Huw says if this is the case then nobody should be able to complete their registration. I have unique email, restrict registration and email verification turned on and it works exactly as Huw says. You register, admin see the pending members list,they approve you, then an email is sent, you click on the link in the email and your userid is then authenticated and your registration is complete. The link text in the email looks suspiciously like the password after 256 bit Hash Sum encryption using the functions to be seen in sha256.asp< |
Edited by - pwhitehurst on 24 November 2008 19:47:05 |
 |
|
Rtwhite
Starting Member
USA
27 Posts |
Posted - 25 November 2008 : 08:03:54
|
Yes your statement is correct.
I am not sure if the code has been modified or not another young man helped me set it up. Please go to the website and register. See if you are able to post without receiving an e-mail validation.
The website is, http://www.salem-baptist.com
Thanks for your assistance I appreciate it very much.
quote: Originally posted by AnonJr
So, just for clarity, you have "Restrict Registration" turned on, as well as "Require Unique E-Mail" and "Require E-Mail Validation"?
< |
 |
|
Rtwhite
Starting Member
USA
27 Posts |
Posted - 25 November 2008 : 08:12:05
|
I will be happy to do this, however I'm not sure I know how?
quote: Originally posted by Carefree
Please provide a link to your pop_mail.asp in .txt format. Since that line doesn't refer to "rs" in the stock Snitz, we'll need to see what modifications you've made in order to help.
< |
 |
|
Podge
Support Moderator
    
Ireland
3776 Posts |
|
Rtwhite
Starting Member
USA
27 Posts |
Posted - 25 November 2008 : 08:39:18
|
I have done this and it can be seen at that URL. Thank you for showing me how to do it.
quote: Originally posted by Podge
ftp into your webspace and rename pop_mail.asp to pop_mail.txt
We should then be able to see it here - http://www.salem-baptist.com/supportforum/pop_mail.txt
< |
 |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 25 November 2008 : 09:15:37
|
quote: Originally posted by Podge
ftp into your webspace and rename pop_mail.asp to pop_mail.txt
We should then be able to see it here - http://www.salem-baptist.com/supportforum/pop_mail.txt
what does pop_mail have to do with it ? pop_mail has nothing to do with the registration process< |
 |
|
Topic  |
|