| Author |
 Topic  |
|
|
Mr Pink
Junior Member
United Kingdom
387 Posts |
 Posted - 17 July 2002 : 14:01:32
|
I have installed the email validation mod and it is working for new members. However, when I click on a members name, I get the following error
quote:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'MEMBER_ID='.
/forum/pop_profile.asp, line 161
I've looked in my profile.asp and it is different from the one that comes with the mod, this is where it is different.
quote:
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE MEMBER_ID=" & ppMember_ID
set rs = my_Conn.Execute(strSql)
if rs.BOF or rs.EOF then
Err_Msg = "Invalid Member ID!"
Response.Write " <table width=""100%"" border=""0"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine & _
" <img src=""" & strImageUrl & "icon_folder_open.gif"" height=""15"" width=""15"" border=""0""> <a href=""default.asp"">All Forums</a><br>" & vbNewLine & _
" <img src=""" & strImageUrl & "icon_bar.gif"" height=""15"" width=""15"" border=""0""><img src=""" & strImageUrl & "icon_folder_open_topic.gif"" height=""15"" width=""15"" border=""0""> Member's Profile</font></td>" & vbNewLine & _
" </tr>" & vbNewLine & _
" </table>" & vbNewLine & _
" <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """ color=""red"">There Was A Problem!</font></p>" & vbNewLine & _
" <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""red"">" & Err_Msg & "</font></p>" & vbNewLine & _
" <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><a href=""JavaScript:history.go(-1)"">Back to Forum</a></font></p>" & vbNewLine & _
" <br>" & vbNewLine
if not(strUseExtendedProfile) then
WriteFooterShort
Response.End
else
WriteFooter
Response.End
end if
else
strMyHobbies = rs("M_HOBBIES")
The file that comes with the mod has this code
quote:
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE MEMBER_ID=" & ChkString(Request.QueryString("id"), "SQLString")
set rs = my_Conn.Execute(strSql)
strMyHobbies = rs("M_HOBBIES")
I would like to know what the correct code should be here.
and while I'm on the subject of editing files, is there a program for MODifying files that is better than wordpad/notepad?
Martin
Hugging the Pink |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 17 July 2002 : 16:00:56
|
Post a link to a txt version of your pop_profile.asp file.
Do you have any other mods installed?
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
 |
|
|
Mr Pink
Junior Member
United Kingdom
387 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 17 July 2002 : 18:26:35
|
Well, the ppMemberID is being used all over that file but it is not set in that file, but in another file. If you don't know of any mod that you installed that uses this variable ppMemberID then I guess you might have overwrite your files with a file from a mod and that variable is some code snippets that the mod author left in there.
Did you edit or overwrite your pop_profile.asp file to install any mods?
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
|
|
|
Mr Pink
Junior Member
United Kingdom
387 Posts |
Posted - 18 July 2002 : 02:32:26
|
quote:
Did you edit or overwrite your pop_profile.asp file to install any mods?
If I'm reading this right, you are saying that 'ppMemberID' shouldn't be in the file. It's in the original file that I downloaded from Snitz.
Martin
Hugging the Pink |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 18 July 2002 : 12:21:08
|
That cannot be. Not unless you downloaded it anywhere else other than here: http://forum.snitz.com/download.asp
I have a copy of the Snitz Forums latest version and that is not in the file for sure. And it's not used anywhere else in the Forum code. So it has to have been added by a mod or somewhere else.
If you haven't touched that file for it to have included that variable, then you can just overwrite your pop_profile.asp file with the one from the Email Validation mod.
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
|
|
|
Mr Pink
Junior Member
United Kingdom
387 Posts |
Posted - 18 July 2002 : 13:46:15
|
OK I'll try the one supplied with the MOD... I'll investigate where that file came from. I'm certain it came from this forum.
Martin
Hugging the Pink |
|
|
| |
Topic |
|
Topic Locked
