| Author |
 Topic  |
|
|
KelleN
Starting Member
28 Posts |
 Posted - 25 July 2003 : 15:38:40
|
Hi, I added the AU4 mod last weekend. I didn't notice until I sent a massive email newsletter annoucing my "New and Improved" forum to my clients and associates, that no one can REGISTER! OUCH!! When I tried to register as a new member this is the error I get. Others apparently get nothihng (http://www.jmconsultingllc.com/aspforum)
Here's the error people get:
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/aspforum/register.asp, line 577
(When looking at this line in Dreamweaver, it's refering to SQL. I don't use SQL, I'm using Access. If this matters) Here's a snippet of code starting in Dreamweaver MX Line Code 559 ending on 585. 577 is in red.
if strLNews = "1" then
strsql = strsql & ", '" & ChkString(Request.Form("LNews"),"message") & "'"
else
strSql = strSql & ", ''"
end if
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
strSql = strSql & ", ''"
end if
strSql = strSql & ", 1"
strSql = strSql & ")"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
if strEmail = "1" and strEmailVal = "1" then
'Do Nothing
else
Call DoCount
end if
regHomepage = ""
Please and TIA for your Help
KelleN |
Edited by - KelleN on 25 July 2003 16:52:03 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
KelleN
Starting Member
28 Posts |
Posted - 25 July 2003 : 18:21:08
|
Ok.. that stinks, I made extra sure that I followed it to a T. Triple checking it for the right spot to enter and then checking it again after saving it by opening the closed the file.
I'll look over it and make sure it's still okay.
Thanks for your response!
|
 |
|
|
KelleN
Starting Member
28 Posts |
Posted - 25 July 2003 : 19:28:33
|
Ok, I checked it, found an error that I made while adding to the registry script. I fixed it and now the register.asp page won't show!!!!!! Http 500 error (internal server error I guess) I don't know why here's what I forgot to add in red, then I added it, published the file and now it won't work:
if strLNews = "1" then
strsql = strsql & ", '" & ChkString(Request.Form("LNews"),"message") & "'"
else
strSql = strSql & ", ''"
end if
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
strSql = strSql & ", ''"
end if
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
strSql = strSql & ", ''"
end if
strSql = strSql & ", 1"
strSql = strSql & ")"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
if strEmail = "1" and strEmailVal = "1" then
'Do Nothing
else
Call DoCount
end if
regHomepage = ""
Everything else seems to have checked out to be posted right.
Thanks,
KelleN |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
KelleN
Starting Member
28 Posts |
Posted - 25 July 2003 : 20:15:54
|
http://www.jmconsultingllc.com/aspforum
Thinking that it might be a cache error, I restarted the client pc that I am working on (modified the reg to clean pagefiles and cache upon shutdown) and that didn't work, I restarted the necessary services on the windows 2000 server, that didn't work, then I rebooted the server, and still Server 500 error on that. I'm not seeing anything in the Event Viewer on the server.
Thanks for your continued valuable help Nikkol |
Edited by - KelleN on 25 July 2003 20:27:22 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 25 July 2003 : 20:34:08
|
Here's your error:
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
/aspforum/register.asp, line 614
else
^
Turn off friendly error messages in your browser to see it. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
KelleN
Starting Member
28 Posts |
Posted - 25 July 2003 : 20:42:19
|
Ok, Did that, saw the error. I opened Dreamweaver MX (notepad ctrl+G for the go to line, is greyed out) and went to line 614 [highlighted in red below]:
if strAuthType="db" then
'################################### E-mail Validation Mod #################################
if strEmailVal = "1" then
strMessage = strMessage & "Please click on the link below to complete your registration." & vbNewline & vbNewLine
strMessage = strMessage & strForumURL & "register.asp?actkey=" & actkey & vbNewline & vbNewline
else
'######################################################################################
strMessage = strMessage & "Password: " & Request.Form("Password") & vbNewline & vbNewline
end if '<---- E-mail Validation Mod - 1 line #############
end if
strMessage = strMessage & "You can change your information at our website by selecting the ""Profile"" link." & vbNewline & vbNewline
strMessage = strMessage & "Happy Posting!"
%>
<!--#INCLUDE FILE="inc_mail.asp" -->
<%
end if
else
Response.Write " <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """ color=""" & strHiLiteFontColor & """>There Was A Problem With Your Details</font></p>" & vbNewLine & _
" <table align=""center"" border=""0"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHiLiteFontColor & """><ul>" & Err_Msg & "</ul></font></td>" & vbNewLine & _
" </tr>" & vbNewLine & _
" </table>" & vbNewLine & _
" <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><a href=""JavaScript:history.go(-1)"">Go Back To Enter Data</a></font></p>" & vbNewLine
WriteFooter
Response.End
end if
should I delete that statement and republish it?
Thanks again NikkoL
Okay, just deleted that "else" and republished it, then I get a similar error on line 667. I did not edit these before, I don't know why they are all messed up. |
Edited by - KelleN on 25 July 2003 20:46:33 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
KelleN
Starting Member
28 Posts |
Posted - 25 July 2003 : 22:46:32
|
thanks. I'll download the forum again.
Thanks for your help
KelleN |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 25 July 2003 : 23:14:44
|
Just a note. You should keep the original zip file. Also, keep a backup of any files before you modify them; that way, you can just restore it.
Also, just because you get an error on a line doesn't mean you should delete that line especially if it is original snitz code. An error like you got was an indication that you left out the beginning or end of an "if" block in the code that you added. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
KelleN
Starting Member
28 Posts |
Posted - 26 July 2003 : 10:47:35
|
Thanks Nikkol..
I was a little tired last night... I did have a backup copy of the files that I modified, I just didn't think about it last night when I wrote that last post. I kept the zip files for both AU and Forum. LOL.
I'm in the process of adding the AU to the register file.
I'll of course be posting back here either way.
Thanks for your continued help! |
|
|
|
KelleN
Starting Member
28 Posts |
Posted - 26 July 2003 : 11:47:02
|
ok, I think all works now.. except when I registered myself again, it didn't send an email.. I have IIS 5, I put my webmaster email address there and choose cdosys. At least I didn't get the registration error. Who knows..LOL.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 July 2003 : 15:12:57
|
| KelleN, again, start a new topic when you have a new issue. That will help get help fit to your new need. If you want, start the new topic and let me know there whether you have control of the IIS server or not. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
