Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Admin Error When Modifying Member		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

bobby131313
Senior Member

USA
1163 Posts
Posted - 03 February 2005 :  13:34:42  Show Profile  Visit bobby131313's Homepage
I searched the boards and couldn't find a thread with this problem. I am running version 3.4.05 and have installed some MOD's. This error was detected after installing the MOD's yesterday. In trying to edit a members profile to assign Moderator status, this is the message I got when I submitted the change:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forums/pop_profile.asp, line 1567

The only MOD that I installed that called for changes in the pop-profile.asp file was the Avatar MOD (which works beautifully). I checked the code that was changed for the MOD and it all seems fine. Obviously, I'm missing something, but I'm just learning the .asp code. Any suggestions would be welcome.
Susan
Switch the order of your title tags
Edited by - ruirib on 04 February 2005 08:49:46

TStewartFan
Junior Member

190 Posts
Posted - 03 February 2005 :  14:48:01  Show Profile  Visit TStewartFan's Homepage
You may want to list the line of code (what is line 1567) as well. No promise I can fix it for you but I guarantee those that can will be asking for it here shortly...heh
If You Have to Ask, You Wouldn't Understand.
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 03 February 2005 :  20:26:54  Show Profile  Visit bobby131313's Homepage
Thanks so much for the reply. Here is the code from lines 1565-1567 (1566 is blank). 
strSql = strSql & " WHERE MEMBER_ID = " & cLng(Request.Form("MEMBER_ID"))

					my_Conn.Execute(strSql),,adCmdText + adExecuteNoRecords
Switch the order of your title tags
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 04 February 2005 :  05:08:03  Show Profile
On the blank line (1566), insert the following code and post back with the results and a *.txt copy of your pop_profile.asp file:

response.write strSql:response.end
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.”
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 04 February 2005 :  10:44:19  Show Profile  Visit bobby131313's Homepage
This is what was displayed when I submitted changes to a user's profile after adding the code:
UPDATE FORUM_MEMBERS SET M_NAME = 'bobby131313', 
M_NEWEMAIL = 'bobby131313@comcast.net', M_KEY = ' ', M_RECEIVE_EMAIL
 = 1 , M_TITLE = ' ', M_POSTS = 15 , M_COUNTRY = 'USA', M_AIM = ' ', 
M_ICQ = ' ', M_MSN = ' ', M_YAHOO = ' ', M_HOMEPAGE 
= 'http://www.bobby131313.com', M_SIG = ' ', M_LEVEL = 1, M_CITY 
= 'Medford', M_STATE = 'New Jersey', M_PHOTO_URL = ' ', M_AVATAR_RUL 
= ' ', M_LINK1 = ' ', M_LINK2 = ' ', M_DOB = '19631013', M_HOBBIES 
= ' ', M_QUOTE = ' ', M_BIO = ' ' WHERE MEMBER_ID = 2


There was no actual error message, just this display of code.

And here is the copy of the file with the new code inserted.
http://bobby131313-trading-assistant-sports-cards-us-coins.com/forums/images/pop_profile_copy.txt

Thanks so much for your help.
Susan
Switch the order of your title tags
Edited by - bobby131313 on 04 February 2005 12:24:02
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts
Posted - 04 February 2005 :  14:26:50  Show Profile  Visit modifichicci's Homepage
You have an error in your file:
M_AVATAR_RUL must be M_AVATAR_URL
search
if strPicture = "1" then
strsql = strsql & ", M_PHOTO_URL = '" & chkString(Trim(regPhoto_URL),"SQLString") & "'"
end if
strsql = strsql & ", M_AVATAR_RUL = '" & ChkString(Trim(regAvatar_Image),"SQLString") & "'"
if strFavLinks = "1" then
and change it
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 04 February 2005 :  16:37:55  Show Profile  Visit bobby131313's Homepage
DOH!

Well I might as well 'fess up now - I'm blonde.

Thanks so much for taking the time to help.

Susan
Switch the order of your title tags
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 04 February 2005 :  16:45:44  Show Profile  Visit bobby131313's Homepage
It's working great. I fixed my mistake and deleted the code I inserted at 1566. I'm trying to learn this code and I really appreciate the help you gave me. I'll keep that reveal code in case I need it again. I'd much rather figure this out on my own than bother you guys, but you've been great.

Susan
Switch the order of your title tags
Edited by - bobby131313 on 04 February 2005 16:50:12
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07