| Author |
 Topic  |
|
|
jspence
Starting Member
USA
4 Posts |
 Posted - 10 September 2003 : 12:42:10
|
Just setting up Snitz. I have set it up for NT access. But when someone who has not registered tries to access it, they get the message:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/register.asp, line 569
It appears line 569 is:
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
I do not know ASP yet, so could anyone give me a hand? |
Edited by - ruirib on 10 September 2003 17:02:26 |
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
|
|
jspence
Starting Member
USA
4 Posts |
Posted - 10 September 2003 : 15:17:15
|
Thanks! That helped... some.
I made changes as suggested by the link provided. Here's what I did:
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Find in register.asp the following:
strSql = strSql & ", '" & chkString(rsKey("M_RECEIVE_EMAIL"),"SQLString") & "'"
and change it to:
strSql = strSql & ", " & cLng(rsKey("M_RECEIVE_EMAIL")) & " "
Find the following:
strSql = strSql & ", '" & chkString(Request.Form("ReceiveEMail"),"SQLString") & "'"
and change it to:
strSql = strSql & ", " & cLng(Request.Form("ReceiveEMail")) & " "
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
and the first person that logged on worked great! The second person (and third) got the error:
"E-mail address is already in use."
I checked the database, and sure enough, the e-mail address of the first person was blank.
Any ideas?? |
 |
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 10 September 2003 : 16:55:42
|
I'm not too familiar with the codes in register.asp and hoped that topic would solve the problem. I'll ask if someone else can take a look at this problem, in the meantime it'd probably be best if you undo the changes since they don't work.
Sorry about that. |
|
|
|
jspence
Starting Member
USA
4 Posts |
Posted - 10 September 2003 : 17:04:10
|
Well, it does work. I mean at least they aren't locked out. We are not ready to use this in prime time, but at least I can have a few people test it.
Once you get that error, you click around until you get to the profile. Then you can add an e-mail address, and you're good to go.
It's kinda kludge, but it works... for now. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 September 2003 : 17:07:11
|
jspence,
Please add these lines just before line 569:
Response.Write strSql
Response.End
Tell me what is shown then if someone tries to register. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 10 September 2003 17:07:36 |
|
|
|
jspence
Starting Member
USA
4 Posts |
Posted - 11 September 2003 : 09:09:48
|
I already did.
M_NAME -> ' '
M_USERNAME -> '(UserName)'
M_PASSWORD -> '1234567890abcdef'
M_EMAIL -> ' '
M_DATE -> '20030910131252'
M_COUNTRY -> ' '
M_AIM -> ' '
M_ICQ -> ' '
M_MSN -> ' '
M_YAHOO -> ' '
M_POSTS -> 0
M_HOMEPAGE -> ' '
M_LASTHEREDATE -> '20030910131252'
M_STATUS -> 1
M_RECEIVE_EMAIL -> ' '
M_LAST_IP -> '10.1.1.1'
M_IP -> '10.1.1.1'
M_SIG -> ' '
M_VIEW_SIG -> 1
M_SIG_DEFAULT -> 0
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_SHA256 -> 1
That lead me to this: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=34873#176333
I made those changes. (If I read it correctly, it basically stops worrying about the e-mail address.) But when I run the script now, it registers person #1 great, but person #2 is using a duplicate e-mail address (blank).
I guess another way to solve this is to figure out what field in 2000 that field relates to. I figred it was the field "E-mail" on the "General" tab (duh), but it still did not work. (The e-mail field on the General tab IS blank for our users, but I added an e-mail address for a user, and had that user hit the forum web page for the first time. His e-mail address STILL does nto show up in the Response statement.) |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 September 2003 : 18:05:40
|
| Well that's because the email address is blank and you have the option to Require Unique Email, in Admin Options->Email Server Configuration set to On. If you set it to Off, the error message won't show up again. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
