Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 E-mail verification & Activate Account Errors		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

122Y
Starting Member

31 Posts
Posted - 04 April 2005 :  09:26:19  Show Profile
Hi

I am have two I think probably related problems.

First Problem: When members try to activate their account from the confirmation e-mail they are getting the message..

'Activation Key Not Found'

Second problem: I have a new member in pending.
When I click on "activate account" link, I get this error:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forum/register.asp, line 184

The lines arround 184 are

183: strSql = strSql & ", '" & chkString(rsKey("M_QUOTE"),"message") & "'"
184: strSql = strSql & ", '" & chkString(rsKey("M_AUHIDE"),"SQLString") & "'"
185: strSql = strSql & ", 1"
186: strSql = strSql & ")"

Any pointers would be appreciated.

IZZY
Edited by - ruirib on 04 April 2005 18:31:09

Hamlin
Advanced Member

United Kingdom
2386 Posts
Posted - 04 April 2005 :  11:24:07  Show Profile
The error means that it can not find the item M_AUHIDE in the record set. I would guess thats related to the active users mod? Try to find where that SQL statement is created and make sure your are selecting the M_AUHIDE field.

If in doubt post a link to a text version of your register.asp file so we can have a look. If you could also let us know what mods you have installed that would be useful.
Go to Top of Page

122Y
Starting Member

31 Posts
Posted - 04 April 2005 :  15:07:02  Show Profile
I have had a look through but I can't see what has gone wrong

The Forum is at http://www.thenudelive.co.uk/forum

I have uploaded a text version of the register.asp here http://www.thenudelive.co.uk/forum/register.txt

don't worry its not a porn site its my sons rock band, he likes to say he "plays bass in the nude".

I have the following Mods installed
  • Active Users vs. 4.0.17
  • Simple Active Users Lite
  • Photo Album v1.50
  • Private Messages
  • Website Intergation


All the mods seem to be working OK.


I am using Snitz Forums 2000 Version 3.4.03

I really appreciate the help.

IZZY
Go to Top of Page

Hamlin
Advanced Member

United Kingdom
2386 Posts
Posted - 04 April 2005 :  17:38:15  Show Profile
Try this.

Line 83-91 register.asp
		'###Forum_SQL
		strSql = "SELECT M_NAME, M_USERNAME, M_PASSWORD, M_KEY, M_LEVEL, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO" & _
			 ", M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT" & _
			 ", M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_LINK1, M_LINK2, M_AGE, M_DOB, M_MARSTATUS, M_SEX, M_OCCUPATION" & _
           	", M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_AUHIDE, M_SHA256" & _
			 " FROM " & strMemberTablePrefix & "MEMBERS_PENDING" & _
			 " WHERE M_KEY = '" & key & "'"

		set rsKey = my_Conn.Execute (strSql)
Add the code in red.
Go to Top of Page

122Y
Starting Member

31 Posts
Posted - 05 April 2005 :  08:01:45  Show Profile
Thanks Hamlin

Everything now in working order

You guys are great!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.33 seconds. Powered By: Snitz Forums 2000 Version 3.4.07