| Author |
 Topic  |
|
wolfman
Starting Member
44 Posts |
 Posted - 16 August 2004 : 11:07:33
|
Hello,
I have a head scratcher here (for me anyway ) My forum was working before I installed Active Users 4.0 (which is an awesome MOD BTW). After installation...
______________________________________________________________
Anyone that tries to register receives the follwoing error after clicking 'submit'
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/forum/register.asp, line 581
Line 581 in register.asp reads...
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
____________________________________________________________
NOW - I went into the admin panel to check all functions there and found that when I click on 'UserName Filter Configuration' I receive the following error...
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/forum/inc_header_short.asp, line 46
Line 46 reads...
my_Conn.Open strConnString
____________________________________________________________
I know the two are related, but I can't seem to figure out what it is looking for. The headscrating part is that I can't figure out which file I edited that would have caused these errors.
The forum is located at http://forums.uptempoair.com/forum/
Thanks in advance - AGAIN.
WOLF
|
|
|
wolfman
Starting Member
44 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 16 August 2004 : 11:24:41
|
On line 570 of register.asp find the following:if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end ifand move it up 3 lines so it is between end if and if strQuote = "1" then.
Can you post a *.txt of inc_header_short.asp? Have you made any changes to it recently?
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
wolfman
Starting Member
44 Posts |
|
|
wolfman
Starting Member
44 Posts |
Posted - 16 August 2004 : 12:33:09
|
I moved the code up as indicated and I still receive the same error.
New txt - http://forums.uptempoair.com/register.txt
Is this becuase I still have not fixed the inc_header_short.asp?
Thanks!
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 17 August 2004 : 05:07:33
|
Feck! Forgot to edit that last post; I should have told you to move that if statement down 2 lines from where you originally had it (or 5 lines down from where it is now); it should be between end if and strSql = strSql & ", 1". If you still get an error, do a response.write on strsql and post the results here.
As for the other problem, it looks like the error might be in admin_config_namefilter.asp, can you post a *.txt of that?
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
wolfman
Starting Member
44 Posts |
Posted - 17 August 2004 : 08:35:32
|
LOL Shaggy -
I have 'what I think' to be a correctly eddited register.asp - please see the new one at http://forums.uptempoair.com/register.txt
The admin_config_namefilter.asp is located at http://forums.uptempoair.com/admin_config_namefilter.txt
I have changed the register.asp - the original error still shows up - now forgive this newbie, but I don't know what you mean when you said "If you still get an error, do a response.write on strsql and post the results here."
I can't wait to piece this all together to know what is happening - LOL
Thanks again for your help AND your patience Shaggy.
WOLF
|
Edited by - wolfman on 17 August 2004 10:58:14 |
|
|
|
wolfman
Starting Member
44 Posts |
Posted - 17 August 2004 : 13:30:58
|
Shaggy - Did I loose you? LOL
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 18 August 2004 : 07:38:02
|
I got distracted by real work! 
For your problem with admin_config_namefilter.asp, you've removed the include of config.asp from the top of the file. To rectify things, paste the following into the blank line immediately above the include of inc_sha256.asp:
<!--#INCLUDE FILE="config.asp" -->
As for register.asp, to write the sql statment to screen, add the following response.write to the blank line immediately above line 581 (which reads: my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords).
response.write strSql
Copy the string that's written to screen and paste it here. You can then comment out the response.write for the time being.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
wolfman
Starting Member
44 Posts |
Posted - 18 August 2004 : 09:23:34
|
Thanks Shaggy - Work does seem to get in the way doesn't it? LOL
I really appreciate your help in this - it's driving me crazy! Ok - so I changed the namefilter file and presto! kudos!
Here is the screen print of the register.asp
INSERT INTO FORUM_MEMBERS_PENDING (M_NAME, M_PASSWORD, M_KEY, M_LEVEL, M_APPROVE, 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 ('wolfswife', '1f16f12161372b07ccf64507a82a36ca084239a2d5d2a28a0af60441baada571', 'i3nr5p43n51c52y2sl5952d9divt10p1', -1, 1, 'barbara@larryandbarbara.com', '20040818080506', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20040818080506', 0, '1', '65.43.181.145', '65.43.181.145', ' ', 1, 1, ' ', ' ', '', '', ' ', ' ', ' ', '', '', '', '', '', '', '', '', ' ', 1, 'noavatar.gif')
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/forum/register.asp, line 581
~Bitting nails~
WOLF |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 18 August 2004 : 13:34:11
|
OK, I can see what's happening just - after the day we've had here - not why it's happening. What's happening is the value to be inserted into the M_AUHIDE field is not being added to the SQL string. I'll try looking at it with fresh eyes in the morning but I honestly can't see anything wrong with it.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
wolfman
Starting Member
44 Posts |
Posted - 18 August 2004 : 15:19:50
|
quote:
Originally posted by Shaggy
OK, I can see what's happening just - after the day we've had here - not why it's happening. What's happening is the value to be inserted into the M_AUHIDE field is not being added to the SQL string. I'll try looking at it with fresh eyes in the morning but I honestly can't see anything wrong with it.
thank you sir. - I will check back tomorrow. Have a better one! |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 19 August 2004 : 05:18:43
|
Gah! Can't for the life of me see what's wrong.  Gonna have to try and do this the long way. Can you temporarily replace the entire if statement we've been moving around with the following line:
strSql = strSql & ", '1'"
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
wolfman
Starting Member
44 Posts |
Posted - 19 August 2004 : 11:24:39
|
Replace if statement with strSql = strSql & ", '1'"
Still same message
I placed the current register.txt at http://forums.uptempoair.com/register.txt
INSERT INTO FORUM_MEMBERS_PENDING (M_NAME, M_PASSWORD, M_KEY, M_LEVEL, M_APPROVE, 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 ('wolfswife', '1f16f12161372b07ccf64507a82a36ca084239a2d5d2a28a0af60441baada571', '1mh4yv206xzmeo324xvg116w64m33rq1', -1, 1, 'barbara@larryandbarbara.com', '20040819101722', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20040819101722', 0, '1', '65.43.181.145', '65.43.181.145', ' ', 1, 1, ' ', ' ', '', '', ' ', ' ', ' ', '', '', '', '', '', '', '', '', ' ', 1, 'noavatar.gif')
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/forum/register.asp, line 577
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 19 August 2004 : 12:02:11
|
You need to move line 570 (the one you just put in) to line 572 (below the next end if).
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
wolfman
Starting Member
44 Posts |
Posted - 19 August 2004 : 15:30:49
|
http://forums.uptempoair.com/register.txt
If this is correct, then it doesn't seem to have changed anything
INSERT INTO FORUM_MEMBERS_PENDING (M_NAME, M_PASSWORD, M_KEY, M_LEVEL, M_APPROVE, 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 ('wolfswife', '1f16f12161372b07ccf64507a82a36ca084239a2d5d2a28a0af60441baada571', '5d5v0tb3lq5q2szvq0v4cccw1rqs25w6', -1, 1, 'barbara@larryandbarbara.com', '20040819142447', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20040819142447', 0, '1', '65.43.181.145', '65.43.181.145', ' ', 1, 1, ' ', ' ', '', '', ' ', ' ', ' ', '', '', '', '', '', '', '', '', ' ', 1, 'noavatar.gif')
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/forum/register.asp, line 577
|
Edited by - wolfman on 19 August 2004 15:31:16 |
|
|
|
Topic |
|
|
|
Topic Locked
