| Author |
 Topic  |
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
 Posted - 30 November 2002 : 08:55:57
|
Alright there,
I'm not too sure but I think this has occurred since installing the Avatart mod, when I turn on email validation and someone tries to sign up they get the following error message:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'M_AVATAR_URL WHERE M_KEY = 'hjc5kpe085mtz5d0uupvuqbbx55fv1k0''.
/forum/register.asp, line 90
Here is line 90 from register.asp (in red) and a little surrounding sode:
" WHERE M_KEY = '" & key & "'"
set rsKey = my_Conn.Execute (strSql)
if rsKey.EOF or rsKey.BOF then '## activation key not found
'Error message to user
Any ideas anyone?
Thanks, Robin. |
http://www.carp-uk.net |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 30 November 2002 : 09:06:40
|
Can you change this line to
response.write strSql
response.end
set rsKey = my_Conn.Execute (strSql)
And post the resulting text, and also provide a link to a text version of your register.asp file please.
Also make sure the code in you register.asp around line 90 looks something like this
'###Forum_SQL
strSql = "SELECT M_NAME, M_USERNAME, M_PASSWORD, M_KEY, M_LEVEL, 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_SHA256, M_AVATAR_URL" & _
" FROM " & strMemberTablePrefix & "MEMBERS_PENDING" & _
" WHERE M_KEY = '" & key & "'"
set rsKey = my_Conn.Execute (strSql)
One last thing do you have any other mods installed? |
 |
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 30 November 2002 : 09:54:17
|
Alright there,
I tried what you suggest (if I did it right) and it gives a strange result when your try to register which is this (this is how you see the page on registration):
All Forums
Registration Rules and Policies Agreement
Registration Form for
SELECT M_NAME, M_USERNAME, M_PASSWORD, M_KEY, M_LEVEL, 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_SHA256, M_AVATAR_URL WHERE M_KEY = 'hjc5kpe085mtz5d0uupvuqbbx55fv1k0'
{{{ Text version of register.asp }}}
Thanks, Robin.
P.S. All my mods are in my signature. |
http://www.carp-uk.net |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 01 December 2002 : 09:20:15
|
| no clues? |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 01 December 2002 : 09:36:57
|
Cant seem to get to your .txt file, but looking at the output you are missing the FROM clause specified in this line
" FROM " & strMemberTablePrefix & "MEMBERS_PENDING" & _
Check to see if it appears in your file, look for the sql block I posted above... |
Edited by - Hamlin on 01 December 2002 09:38:20 |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 01 December 2002 : 10:55:41
|
Alright there,
The line you mention above is not in my register.asp, do you know where it should appear?
Thanks, Robin. |
Edited by - Doughnut on 01 December 2002 10:56:30 |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 01 December 2002 : 11:26:07
|
The code you had to edit for the avatar mod around line 90
'###Forum_SQL
strSql = "SELECT M_NAME, M_USERNAME, M_PASSWORD, M_KEY, M_LEVEL, 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_SHA256, M_AVATAR_URL" & _
" FROM " & strMemberTablePrefix & "MEMBERS_PENDING" & _
" WHERE M_KEY = '" & key & "'"
set rsKey = my_Conn.Execute (strSql)
You altered the line in green, and I think you accidentally deleted the line in red. Just shove the red line back in and it should all work 
As I said before I get a 404 not found error when I try and look at your register.txt file, but the code is near the top.
EDIT - I cant get to it now so this code line 83-88, add the new red line.
'###Forum_SQL
strSql = "SELECT M_NAME, M_USERNAME, M_PASSWORD, M_KEY, M_LEVEL, 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_SHA256, M_AVATAR_URL" & _
" FROM " & strMemberTablePrefix & "MEMBERS_PENDING" & _
" WHERE M_KEY = '" & key & "'"
|
Edited by - Hamlin on 01 December 2002 11:28:50 |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 01 December 2002 : 14:09:36
|
God know how I deleted that line 
Right, I replaced that line but it's thrown up another error:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forum/register.asp, line 185
Heres the line (in green) and some surrounding code:
strSql = strSql & ", '" & chkString(rsKey("M_OCCUPATION"),"SQLString") & "'"
strSql = strSql & ", '" & chkString(rsKey("M_BIO"),"message") & "'"
strSql = strSql & ", '" & chkString(rsKey("M_HOBBIES"),"message") & "'"
strSql = strSql & ", '" & chkString(rsKey("M_LNEWS"),"message") & "'"
strSql = strSql & ", '" & chkString(rsKey("M_QUOTE"),"message") & "'"
strSql = strSql & ", '" & chkString(rsKey("M_AUHIDE"),"SQLString") & "'"
strSql = strSql & ", 1"
strSql = strSql & ", '" & chkString(rsKey("M_AVATAR_URL"),"SqlString") & "'"
strSql = strSql & ")"
I'm gonna have a good check through my code for this page but I'll look back in case you get any ideas in the meantime!
Thanks very much so far, Robin.
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 01 December 2002 : 14:15:47
|
The line we added for the avatar mod this line
", M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_SHA256, M_AVATAR_URL" & _
Will need to have the red code added to it. Its in the same block of code we just changed around line 90.
", M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_SHA256, M_AUHIDE, M_AVATAR_URL" & _
That would have been deleted when you made the changes in the avatar readme |
Edited by - Hamlin on 01 December 2002 14:16:29 |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 01 December 2002 : 17:29:48
|
Hamlin you genius!
Well spotted dude, thanks very much........sorted  |
|
|
|
ahdkaw
Starting Member
United Kingdom
13 Posts |
Posted - 10 January 2003 : 11:39:22
|
I hope this is the correct thread...
I have just installed this mod to my forum, however after setting up the forum to require email validation, and then attempting to register, the 'Confirm Email' field is not visible, so of course the registration fails every time due to non-matching email addresses.
I've looked in inc_profile.asp and this is the line cause ths problem (I think):
<% '########################## Email Validation Mod ##########################
if (strEmailVal = "1" and lcase(strEmail) = "1") and Request.QueryString("mode") = "Register" then %>
<tr>
<td bgColor=<% =strPopUpTableColor %> align=right width="10%" nowrap><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><FONT color=#ff0000>*</FONT>Confirm Email: </font></b></td>
<td bgColor=<% =strPopUpTableColor %>><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><INPUT name="Email2" size="25" value=""></font></td>
</tr>
<% end if
'#########################################################################
%>
Should this be changed:
lcase(strEmail) = "1"
to this?
lcase(strEmailVal) = "1"
TIA |
|
|
|
ahdkaw
Starting Member
United Kingdom
13 Posts |
Posted - 10 January 2003 : 13:23:54
|
Sorry, folks ignore my last post, I've sussed the problem (I didn't have a certain setting enabled).
However, one question I do have is:
I have M_AVATAR_URL and M_AUHIDE in the MEMBERS table but not in the MEMBERS_PENDING table, how would I add these fields to the PENDING table? I have tried using Access 2000 but it won't let me add fields, does anyone have a piece of code I could run to add these fields to the table?
Once again, thanks in advance. :) |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 10 January 2003 : 16:27:15
|
| You would probably get more help if you started a new topic instead of attaching to this old topic. |
Support Snitz Forums
|
|
|
| |
Topic |
|
|
|
Topic Locked
