| Author |
 Topic  |
|
laser
Advanced Member
Australia
3859 Posts |
 Posted - 17 November 2003 : 16:55:48
|
ok, so now I get :
INSERT INTO FORUM_MEMBERS (M_NAME, M_PASSWORD, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, 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_AUHIDE, M_SHA256, M_AVATAR_URL) VALUES ('test', '8b7df143d91c716ecfa5fc1730022f6b421b05cedee8fd52b1fc65a96030ad52', 'test@v8central.com', '20031117154947', 'USA', 'aim', '60787125', 'laserracing@hotmail.com', 'cmcclellau', 0, ' ', '20031117154947', 1, '1', '144.132.131.66', '144.132.131.66', 'sig', 1, 1, 'first', 'sur', 'city', '', ' ', '', '', '99', '', '', 'Male', '', '', '', '', '', 1, 'avatars/xbox.gif'
so if I alter the last line ...
INSERT INTO FORUM_MEMBERS (M_NAME, M_PASSWORD, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, 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_AUHIDE, M_SHA256, M_AVATAR_URL) VALUES ('test', '8b7df143d91c716ecfa5fc1730022f6b421b05cedee8fd52b1fc65a96030ad52', 'test@v8central.com', '20031117154947', 'USA', 'aim', '60787125', 'laserracing@hotmail.com', 'cmcclellau', 0, ' ', '20031117154947', 1, '1', '144.132.131.66', '144.132.131.66', 'sig', 1, 1, 'first', 'sur', 'city', '', ' ', '', '', '99', '', '', 'Male', 'OCCUPATION', 'BIO', 'HOBBIES', 'LNEWS', 'QUOTE', 1, 'avatars/xbox.gif'
I don't know what the M_SHA256 field is ... should it or the M_AUHIDE field have a 0 value ? |
 |
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 17:01:12
|
quote:
Originally posted by laser
I don't know what the M_SHA256 field is ... should it or the M_AUHIDE field have a 0 value ?
I know its from the base snitz files ( inc_sha256.asp )
so it's not a mod I added.
As far as your question, I'm an ASP n00b! no doubt, so I
dont have a clue
I guess at the worst, I can just reupload the base register.asp
so these few can get registed, then maybe reinstall the
AU/Avatars mod all over again 
I do know that registering did work after these mods were installed,
I've also installed other mods since then which may somehow
be causing this (other mods had no change in register.asp though???)
Some others I've installed since then are: site integration mod,
spell check, smilies in topic titles, private messages etc.
|
my little forum playground
|
Edited by - xx ENIGMA xx on 17 November 2003 17:06:36 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 17:09:02
|
Can you update your txt copy ?
|
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 17:15:37
|
quote:
Originally posted by laser
Can you update your txt copy ?
just updated it
btw, I did upload my unmodded register.asp and got a registration
through just fine and then put my modded one back. I would like
to find a solution though if possible.
thanks for your time here laser 
|
my little forum playground
|
Edited by - xx ENIGMA xx on 17 November 2003 17:20:42 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 17:24:51
|
OK, I still think your error lies in the area lines 583-595.
See how you AU mod (lines 585-591) is within the IF for strQuote. I would cut lines 585-591 and paste them just after the strQuote END IF, so your code goes from this :
(lines 583-595)
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
'####################### ACTIVE USERS MOD #############################
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
'##################################################################
else
strSql = strSql & ", ''"
end if
strSql = strSql & ", 1"
to this ...
(line 583-595
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
strSql = strSql & ", ''"
end if
'####################### ACTIVE USERS MOD #############################
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
'##################################################################
strSql = strSql & ", 1"
|
Edited by - laser on 17 November 2003 17:25:48 |
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 17:32:13
|
ok, I replaced what I had with your suggestion
and logged out and attempted a new registration.
this is what it gave me:
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/bbs/register.asp, line 617
line 617 = my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
|
my little forum playground
|
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 17:34:33
|
Yes, but you've also changed some other lines  where has the
Response.Write strSql
gone ?
I still think the problem had got to do with the last few fields, but I don't have much time left at the moment to help you - do you have MSN or Yahoo ? |
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 17:39:29
|
I'm sorry, I just took that out because I was thinking
it shouldnt be there and I was to try your new set of
code. I will add it back and also update the .txt file
I have ICQ or AIM
icq: 133521674
aim: PsionicBisquit
===========================================
(Response.Write strSql) added back in produces:
INSERT INTO FORUM_MEMBERS (M_NAME, M_PASSWORD, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, 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_AUHIDE, M_SHA256, M_AVATAR_URL) VALUES ('Tester', '9bba5c53a0545e0c80184b946153c9f58387e3bd1d4ee35740f29ac2e718b019', 'test@test.com', '20031117163703', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20031117163703', 1, '1', '24.155.36.30', '24.155.36.30', ' ', 1, 1, ' ', ' ', ' ', '', ' ', '', '', ' ', '', '', ' ', '', '', '', '', '', '1', 'noavatar.gif'
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/bbs/register.asp, line 617
|
my little forum playground
|
Edited by - xx ENIGMA xx on 17 November 2003 17:42:17 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 17:44:28
|
You don't look like you're online on ICQ, but try this :
UNcomment line 607 ONLY! |
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 17:52:27
|
I am online on icq, I just appear invisible so it
looks to you as if I'm offline - send me a message
I made that change and registration was successful
but I got this which still indicates a problem?
INSERT INTO FORUM_MEMBERS (M_NAME, M_PASSWORD, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, 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_AUHIDE, M_SHA256, M_AVATAR_URL) VALUES ('Tester', '9bba5c53a0545e0c80184b946153c9f58387e3bd1d4ee35740f29ac2e718b019', 'test@test.com', '20031117164702', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20031117164702', 1, '1', '24.155.36.30', '24.155.36.30', ' ', 1, 1, ' ', ' ', ' ', '', ' ', '', '', ' ', '', '', ' ', '', '', '', '', '', '1', 1, 'noavatar.gif'
Your Registration Has Been Completed!
You may now begin posting using your new UserName and Password.
|
my little forum playground
|
Edited by - xx ENIGMA xx on 17 November 2003 17:56:35 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 17:56:32
|
PERFECT, NOW that it works, you just remove/comment line 614
I can only guess at what caused this problem, but I was helping someone else install a MOD the other day, the readme said "insert at line X", so they just shoved it in there without realising that other MODs had altered the line numbers. You might be able to see in your code that you only have the AU code if quote=1, but no AU stuff if Quote=0 (we have now fixed this). Anyway, glad it's working. You can find all my IM details in my profile, but I won't be here for at least the next 4+ hrs.
edit : you can remove the 'test' user as well |
Edited by - laser on 17 November 2003 17:58:13 |
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 18:02:06
|
yes, commenting out line 614 got rid of all that
mess 
thank you so much for your time today on this, it
is much appreciated!!!
how this happened I dont know, but it is odd
thanks again... |
my little forum playground
|
|
|
|
Topic |
|
|
|
Topic Locked
