| Author |
 Topic  |
|
|
DaMegz
Junior Member
126 Posts |
 Posted - 28 July 2002 : 20:44:20
|
After the user enters all his information to register...this error pops up... quote:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/register.asp, line 309
I have posted the register.txt file here.
Thanks for the help.
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 July 2002 : 21:06:15
|
Is this related to the install of a particular MOD?
Nikkol
~~~~~~~~~~~
Install Guide | MODs |
 |
|
|
DaMegz
Junior Member
126 Posts |
Posted - 28 July 2002 : 21:12:32
|
Im not really sure...I tried installing the email validation mod (unsuccessfully), and thought I put the original files back in place, but now Im getting this error. I made sure I backed up all the files before I made any changes. The only thing that has changed is the database. Is it possible that the changes made to the database has caused the problems?
|
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 July 2002 : 21:17:19
|
possibly ... did you delete any of the fields that the email validation mod created?
also, you can put response.write(strSql) right after line 309 and then post the results here. might help in troubleshooting.
Nikkol
~~~~~~~~~~~
Install Guide | MODs |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 July 2002 : 21:21:54
|
quote:
I have posted the register.txt file here.
quote:
How about you upload a .txt version of your register.asp and then post a link to it here?
Me thinks BananaMan has gone bananas.
Nikkol
~~~~~~~~~~~
Install Guide | MODs |
|
|
|
DaMegz
Junior Member
126 Posts |
Posted - 28 July 2002 : 21:30:45
|
Here's the text file
Here is the new error that Im getting quote:
NSERT INTO FORUM_MEMBERS (M_NAME, M_PASSWORD, 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', '123', 'test@?.com', '0', '20020728211837', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20020728211837', 1, '68.39.181.xxx', '68.39.181.xxx', '', '', '', '', '', 'noavatar.gif', ' ', ' ', '', '', '', '', '', '', '', '', ' ', '1')
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/register.asp, line 309
|
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
|
|
DaMegz
Junior Member
126 Posts |
Posted - 28 July 2002 : 21:41:30
|
This is the original...heres a link to that file if you want to see it.
|
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 28 July 2002 : 22:34:54
|
Well, I did some checking up and the only advice I can give you is to check your database for fields that aren't there, but which the register.asp file wants to write to.
I don't see the active users MOD on your front page, but you might have that hidden. If you don't have it installed, then that's giving the problem 'cause register.asp wants to write to a table called M_AUHIDE. The problem is that there's also no option to choose whether or not you want to be "anonymous" on the registration form.
Roland
http://www.frutzle.com
Snitz Exchange | Snitz Icons | Do's and Dont's |
|
|
| |
Topic |
|
|
|
Topic Locked
