| Author |
 Topic  |
|
|
DaMegz
Junior Member
126 Posts |
 Posted - 24 July 2002 : 14:15:12
|
I am trying to install this mod (unsuccessfully). When a user tries register, they read the privacy agreement and then click on AGREE
Here's the error that Im getting quote:
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
/forum/register.asp, line 554
else
^
I have posted the register file at http://www.oceanlanes.com/forum/register.txt
and inc_profile at http://www.oceanlanes.com/forum/inc_profile.txt
Any help would be greatly appreciated.
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 July 2002 : 14:39:17
|
You're missing the code in red, starting at line 517 in your register.asp file:'################### Email Validation Mod ###################
if lcase(strEmail) = "1" and strEmailVal = "1" then
'Do Nothing
else
'############################################################
docount
end if '<--- ##### Email Validation Mod - 1 line #####
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
 |
|
|
DaMegz
Junior Member
126 Posts |
Posted - 24 July 2002 : 14:48:47
|
ok...now getting this error:
quote:
Microsoft VBScript compilation error '800a0400'
Expected statement
/forum/register.asp, line 604
<%
^
Just updated the register.txt
Edited by - DaMegz on 24 July 2002 14:50:42 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 July 2002 : 14:53:31
|
Oh yeah I saw that problem in your file but forgot to mention it.
Just remove that asp tag from that line.
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
|
|
|
DaMegz
Junior Member
126 Posts |
Posted - 24 July 2002 : 14:57:45
|
Davio,
Thanks...but here's the new error.
quote:
Microsoft VBScript compilation error '800a03f8'
Expected 'Sub'
/forum/inc_profile.asp, line 645
end if
----^
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 July 2002 : 15:17:49
|
Lines 610 - 613 needs to be changed from this:<INPUT type="hidden" name="Email2" value="<% =RS("M_EMAIL") %>"></font></td>
'######################## Email Validation Mod ########################
if strEmailVal = "0" or Request.QueryString("mode") <> "Register" then %><INPUT type="hidden" name="Email2" value="<% =RS("M_EMAIL") %>"><% end if
'###################################################################### %></font></td>to this:<%'######################## Email Validation Mod ########################
if strEmailVal = "0" or Request.QueryString("mode") <> "Register" then %><INPUT type="hidden" name="Email2" value="<% =RS("M_EMAIL") %>"><% end if
'###################################################################### %></font></td> Code in red is added.
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
|
|
|
DaMegz
Junior Member
126 Posts |
Posted - 24 July 2002 : 15:28:34
|
Davio...I think were getting there. Each time I get a little further. Thanks for your patience!
Here's the new error:
quote:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/register.asp, line 516
By the way, I have updated the txt files.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 July 2002 : 16:11:30
|
You need to be careful how you paste code into your files. Sometimes the code you paste needs to replace some code that is in your file. So when you copy and paste code into your files, you should double check to make sure you copied it correctly and to make sure it looks like the code that came with the mod.
Remove line 352 from your register.asp file:strSql = "INSERT INTO " & strMemberTablePrefix & "MEMBERS "
Also, you see those mods you installed into your MEMBERS table?
Like News Flash, Avatar Mod, and Active Users mod? You will need to add those fields to the MEMBERS_PENDING table.
To do that, just take the dbs files that came with those mods, change the table name MEMBERS to MEMBERS_PENDING then run each script from the mod setup file and it will install the fields to the table.
Then (more work), you will need to add those fields (just like you added them to the SQL statement for the MEMBERS table) to the first SQL statement in your register.asp file. Let me show you.
Line 78, you need to add the code in red:"M_SIG, M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_AVATAR_URL, M_LINK1, M_LINK2, M_AGE, " & _ Line 79, you will need to add the code in red:"M_MARSTATUS, M_SEX, M_OCCUPATION, M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_NF, M_AUHIDE" & _ Then after line 141 you will need to add the code in red:strsql = strsql & ", M_PHOTO_URL"
strsql = strsql & ", M_AVATAR_URL"
strsql = strsql & ", M_LINK1" After line 152 add the code in red:strSql = strSql & ", M_QUOTE"
strSql = strSql & ", M_NF"
strSql = strSql & ", M_AUHIDE"
strSql = strSql & ") " Finally after line 181, you need to add the code in red:strsql = strsql & ", '" & ChkString(rsKey("M_PHOTO_URL"),"") & "'"
strsql = strsql & ", '" & ChkString(rsKey("M_AVATAR_URL"),"") & "'"
strsql = strsql & ", '" & ChkString(rsKey("M_LINK1"),"") & "'"After line 192, you need to add the code in red:strSql = strSql & ", '" & ChkString(rsKey("M_QUOTE"),"message") & "'"
strSql = strSql & ", '" & ChkString(rsKey("M_NF"),"message") & "'"
strSql = strSql & ", '" & ChkString(rsKey("M_AUHIDE"),"message") & "'"
strSql = strSql & ")"This will make you other mods compatable with the email validation mod.
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
|
|
|
DaMegz
Junior Member
126 Posts |
Posted - 24 July 2002 : 16:46:55
|
Davio...Let me start by thanking you for your time, patience and knowledge.
I have done everything you mentioned in the last post. I am still getting this error, when hitting SUBMIT in the register page... quote:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/register.asp, line 522
I have updated the register txt file for your review. Thank again
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 July 2002 : 17:09:14
|
Before line 522, put this bit of code:Response.Write strSql That should output the sql statement along with the error. I need you to post that sql statement when you get that error again.
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
|
|
|
DaMegz
Junior Member
126 Posts |
Posted - 24 July 2002 : 17:11:31
|
INSERT INTO FORUM_MEMBERS_PENDING (M_NAME, M_PASSWORD, M_KEY, M_LEVEL, M_EMAIL, M_HIDE_EMAIL, M_DATE, M_COUNTRY, M_SIG, M_YAHOO, M_ICQ, M_AIM, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_LAST_IP, M_IP, M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_AVATAR_URL, M_LINK1, M_LINK2, M_AGE, M_MARSTATUS, M_SEX, M_OCCUPATION, M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_NF, M_AUHIDE) VALUES ('TEST', 'TEST', 'rm27y8q0zSVPRz3W', -1, 'louis..com', '0', '20020724170250', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20020724170250', 1, '192.58.253.5', '192.58.253.5', '', '', '', '', '', 'noavatar.gif', ' ', ' ', '', '', '', '', '', '', '', '', ' ', '1')
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/register.asp, line 522
Edited by - DaMegz on 24 July 2002 17:12:11 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 July 2002 : 17:24:23
|
If you turn off email validation, and try registering again, does it work? Are you sure you installed the database fields for each mod in the MEMBERS_PENDING table?
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
|
|
|
DaMegz
Junior Member
126 Posts |
Posted - 24 July 2002 : 17:31:11
|
OK heres what happened. I turned off email. Tried to register, but there is only 1 field for email (previously...there was a 2nd field for email confirmation)...so I get the error YOUR EMAILS DIDNT MATCH.
To answer your 2nd question, yes...I did add the fields. I ran the dbs for each mod (newsflash, Active Users and Avatar) but I replaced MEMBERS to MEMBERS_PENDING. If I understood you correctly, that was what I was supposed to do.
Sorry DAvio...when I turned off validation option, I got hte same error as before: quote:
INSERT INTO FORUM_MEMBERS (M_NAME, M_PASSWORD, M_KEY, M_EMAIL, M_HIDE_EMAIL, M_DATE, M_COUNTRY, M_SIG, M_YAHOO, M_ICQ, M_AIM, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_LAST_IP, M_IP, M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_AVATAR_URL, M_LINK1, M_LINK2, M_AGE, M_MARSTATUS, M_SEX, M_OCCUPATION, M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_NF, M_AUHIDE) VALUES ('test', 'test', 'txf1XcENUSE820IY', 'lou@house.com', '0', '20020724173758', ' ', ' ', ' ', ' ', ' ', 1, ' ', '20020724173758', 1, '192.58.253.5', '192.58.253.5', '', '', '', '', '', 'noavatar.gif', ' ', ' ', '', '', '', '', '', '', '', '', ' ', '1')
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/register.asp, line 522
Edited by - DaMegz on 24 July 2002 17:49:10 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 July 2002 : 05:59:35
|
Ok, I am guessing it has something to do with one of the new fields for the mods you added that is giving that problem. I tried to see if this was a known problem with one of the other mods you installed, it seems other users have had the problem with a few of each mod you have installed but no good fix on it. So keep your fingers crossed. Maybe we can fix it this time.
I have 2 things in mind to try and fix it. Lets try my first suspicion. Move the code on lines 401 and 402 and move it after line 396:strSql = strSql & ", M_OCCUPATION"
strSql = strSql & ", M_NF"
strSql = strSql & ", M_AUHIDE"
strSql = strSql & ", M_BIO" Then move lines 511 - 518 after line 490:if strOccupation = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Occupation"),"") & "'"
else
strSql = strSql & ", ''"
end if
if strNewsFlash = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("NFPred"),"") & "'"
end if
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
if strBio = "1" then This is in your register.asp file. You will also need to do the same with the first sql statement in your register.asp file. You think you can do that?
If you don't, don't worry about it. Keeping the email validation off, try registering again and see if the same error occurs. Don't need to post the sql statement that comes up. Actually you can remove that Response.Write code I asked you to add.
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
|
|
|
DaMegz
Junior Member
126 Posts |
Posted - 25 July 2002 : 10:44:50
|
Davio,
Made the recommended changes (with the exception of "You will also need to do the same with the first sql statement in your register.asp file"sinc I dont know how  )
Got the same error-datatype mismatch..blah blah blah.
I have updated the text file.
Here are the fields in the members_pending table in case you need them:
MEMBER_ID
M_STATUS
M_NAME
M_USERNAME
M_PASSWORD
M_EMAIL
M_COUNTRY
M_HOMEPAGE
M_SIG
M_DEFAULT_VIEW
M_LEVEL
M_AIM
M_ICQ
M_YAHOO
M_POSTS
M_DATE
M_LASTHEREDATE
M_LASTPOSTDATE
M_TITLE
M_SUBSCRIPTION
M_HIDE_EMAIL
M_RECEIVE_EMAIL
M_LAST_IP
M_IP
M_FIRSTNAME
M_LASTNAME
M_OCCUPATION
M_SEX
M_AGE
M_HOBBIES
M_LNEWS
M_QUOTE
M_BIO
M_MARSTATUS
M_LINK1
M_LINK2
M_CITY
M_STATE
M_PHOTO_URL
M_KEY
M_NEWEMAIL
M_NF
M_NF_READ
M_AVATAR_URL
M_AUHIDE
Edited by - DaMegz on 25 July 2002 10:48:46 |
|
|
| |
Topic |
|
|
|
Topic Locked
