Snitz Forums 2000 - 80040e14 error with register.asp

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

80040e14 error with register.asp

New Topic

Topic Locked

Printer Friendly

Author

Topic

iamba
Starting Member

7 Posts

Posted - 30 March 2004 : 14:11:19

I enabled email registration and I get the following error when trying to activate an account or when the emailed account clicks the activation link.

-----------------------------------
Microsoft JET Database Engine error '80040e14'

Number of query values and destination fields are not the same.

/forum/register.asp, line 189
-----------------------------------

I've installed several MODS in the past and I'm not sure which one could be causing the problems. I scoured the forums for related posts and I could only find problems related to the active users mod, but thats nothing like what is on line 189. I'm not really sure what to do... Any help would be rosey...

Thanks

Here is the link to my register.asp file
http://www.iamba.org/forum/register.txt

masterao
Senior Member

Sweden
1678 Posts

Posted - 30 March 2004 : 14:29:06

Could you list all the mods that you have added?

Update:

You seem to have mixed up lines 103-144, which can be the cause for this error. It should look as the following:


			'## Forum_SQL
			strSql = "INSERT INTO " & strMemberTablePrefix & "MEMBERS "
			strSql = strSql & "(M_NAME"
			strSql = strSql & ", M_USERNAME"
			strSql = strSql & ", M_PASSWORD"
			strSql = strSql & ", M_LEVEL"
			strSql = strSql & ", M_EMAIL"
			strSql = strSql & ", M_DATE"
			strSql = strSql & ", M_COUNTRY"
			strSql = strSql & ", M_AIM"
			strSql = strSql & ", M_ICQ"
			strSql = strSql & ", M_MSN"
			strSql = strSql & ", M_YAHOO"
			strSql = strSql & ", M_POSTS"
			strSql = strSql & ", M_HOMEPAGE"
			strSql = strSql & ", M_LASTHEREDATE"
			strSql = strSql & ", M_STATUS"
			strSql = strSql & ", M_RECEIVE_EMAIL"
			strSql = strSql & ", M_LAST_IP"
			strSql = strSql & ", M_IP"
			strSql = strSql & ", M_SIG"
			strSql = strSql & ", M_VIEW_SIG"
			strSql = strSql & ", M_SIG_DEFAULT"
			strSql = strSql & ", M_FIRSTNAME"
			strSql = strSql & ", M_LASTNAME"
			strSql = strSql & ", M_CITY"
			strSql = strSql & ", M_STATE"
			strSql = strSql & ", M_PHOTO_URL"
			strSql = strSql & ", M_LINK1"
			strSql = strSql & ", M_LINK2"
			strSql = strsql & ", M_AGE"
			strSql = strsql & ", M_DOB"
			strSql = strSql & ", M_MARSTATUS"
			strSql = strsql & ", M_SEX"
			strSql = strSql & ", M_OCCUPATION"
			strSql = strSql & ", M_BIO"
			strSql = strSql & ", M_HOBBIES"
			strsql = strsql & ", M_LNEWS"
			strSql = strSql & ", M_QUOTE"
			strSql = strSql & ", M_AUHIDE"
			strSql = strSql & ", M_SHA256"
			strsql = strsql & ", M_AVATAR_URL"

Im not sure if that is the only error, but that is the most easily spotted one.

Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod

Edited by - masterao on 30 March 2004 14:34:59

iamba
Starting Member

7 Posts

Posted - 30 March 2004 : 14:37:00

I don't know that this is all of them because it has been over a long stretch of time, but here are some candidates

Avatar Mod
Active Users
SmileManager Plus
Advanced Color Picker
Search by IP
Spell Check
Flash Mod (For using flash in posts)

I think that's it

Thank you

masterao
Senior Member

Sweden
1678 Posts

Posted - 30 March 2004 : 14:54:29

Ok. That will help if you receive more errors after doing the suggested changes I posted above.

Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod

iamba
Starting Member

7 Posts

Posted - 30 March 2004 : 15:44:23

Thank you Thank you Thank you.

Fixed the problem.

masterao
Senior Member

Sweden
1678 Posts

Posted - 30 March 2004 : 15:48:29