| Author |
 Topic  |
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
 Posted - 04 April 2001 : 00:08:07
|
Hi,
I have only just learned that at some stage, no one could register at my Forums because of the following error:
There Was A Problem With Your Details
Your Passwords didn't match
I have no idea when this happened, and as I have installed a number of mods lately, (user fields, avatar, ban ip) that required editing of register.asp, I have no idea where things have gone wrong.
Here is a link to my register.asp (in .txt format) - http://www.hisgrace.org.nz/forum/register_asp.txt
If you can see where the error lies, please let me know as soon as possible - I'll be putting people off registering!
*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind  * |
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
Posted - 04 April 2001 : 00:27:26
|
Okay - please ignore the above error message, although there is still an error. The above occurred when I browsed directly to register.asp instead of first viewing policy.asp. But, there is still a problem with my register.asp, and people still cannot Register. The correct Error is:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/forum/register.asp, line 301
Line 301 for me is:
my_Conn.Execute (strSql)
Any help greatly appreciated!!
*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind * |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 April 2001 : 06:38:14
|
on line 300 of your register.asp, place the following
response.write (strSQL)
this will then give you the SQL being issued, if you post that, I can tell you what is wrong
|
|
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
Posted - 04 April 2001 : 16:34:15
|
Oh, thank you so much Huw! I have been worrying about this half the night!
Here is what comes up now:
INSERT 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) VALUES ('m2m2m', '6clisham', 'm2m2m@hisgrace.org.nz', , '20010405084048', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20010405084048', 1, '210.54.12.64', '210.54.12.64', '', '', ' ', ' ', ' ', 'noavatar.gif', ' ', ' ', ' ', '', ' ', ' ', ' ', ' ', ' ', ' ')
Looking forward to an answer for this one 
*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind * |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 04 April 2001 : 16:49:12
|
| The problem looks to be with the M_HIDE_EMAIL field. In your inc_profile.asp did you add the code to display the option to your users? (or maybe the code got deleted?) I clicked on Register at your forum and didn't see it. |
|
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
Posted - 04 April 2001 : 17:15:26
|
Yes! Yes! Yes! That's done it! It looks like I done something wrong in inc_profile.asp when I installed Kerry's Email mod, and the hide email option got deleted. I re-inserted it, and was able to Register! Thank so VERY much! What a relief.....
*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind * |
|
|
| |
Topic |
|
|
|
Topic Locked
