| Author |
 Topic  |
|
sr_erick
Senior Member
USA
1318 Posts |
 Posted - 26 February 2001 : 17:25:28
|
How do I set up moderators for my forums? When I go to Admin Options I go to Moerators section but it only list Admin as an option there. Am I missing something here? Thanks!
Sr_Erick.. http://www.geocities.com/sr_erick |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 26 February 2001 : 17:44:02
|
Log in as Admin. Go to the Members page. Click on the  icon beside the name you want to make a moderator. When you reach the Edit Profile screen, there will be an option at the lower right hand section of the profile, to either make the user an Admin or a Moderator or a Normal User. Select which one you want, then click submit.
Then go back to the Admin options and go to Moderators to select a moderator to moderate a specific forum.
*----*----*----*----*----*----*----*----*
"It's not how long you live that counts,
But how well you live."
*----*----*----*----*----*----*----*----* |
 |
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 26 February 2001 : 17:54:30
|
When I select them to be a moderator and hit "submit" it sas this:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/pop_profile.asp, line 1118
What should I do?
Sr_Erick.. http://www.geocities.com/sr_erick |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 26 February 2001 : 18:12:09
|
| Can you post line 1118 and a few lines before that of your pop_profile.asp file? |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 26 February 2001 : 18:59:11
|
figures out how to find it:
strSql = strSql & ", M_TITLE = '" & ChkString(Request.Form("Title"),"") & "'"
strSql = strSql & ", M_POSTS = " & ChkString(Request.Form("Posts"),"") & " "
strSql = strSql & ", M_COUNTRY = '" & ChkString(Request.Form("Country"),"") & "'"
if strICQ = "1" then
strSql = strSql & ", M_ICQ = '" & ChkString(Request.Form("ICQ"),"") & "'"
end if
if strYAHOO = "1" then
strSql = strSql & ", M_YAHOO = '" & ChkString(Request.Form("YAHOO"),"") & "'"
end if
if strAIM = "1" then
strSql = strSql & ", M_AIM = '" & ChkString(Request.Form("AIM"),"name") & "'"
end if
if strHOMEPAGE = "1" then
strSql = strSql & ", M_HOMEPAGE = '" & ChkString(Request.Form("Homepage"),"" ) & "'"
end if
strSql = strSql & ", M_SIG = '" & ChkString(Request.Form("Sig"),"message") & "'"
strSql = strSql & ", M_LEVEL = " & ChkString(Request.Form("Level"),"")
if strfullName = "1" then
strSql = strSql & ", M_FIRSTNAME = '" & ChkString(Request.Form("FirstName"),"") & "'"
strSql = strSql & ", M_LASTNAME = '" & ChkString(Request.Form("LastName"),"") & "'"
end if
if strCity = "1" then
strsql = strsql & ", M_CITY = '" & ChkString(Request.Form("City"),"") & "'"
end if
if strState = "1" then
strsql = strsql & ", M_STATE = '" & ChkString(Request.Form("State"),"") & "'"
end if
'strsql = strsql & ", M_HIDE_EMAIL = '" & ChkString(Request.Form("HideMail"),"") & "'"
if strPicture = "1" then
strsql = strsql & ", M_PHOTO_URL = '" & ChkString(Request.Form("Photo_URL"),"") & "'"
end if
if strFavLinks = "1" then
strsql = strsql & ", M_LINK1 = '" & ChkString(Request.Form("LINK1"),"") & "'"
strSql = strSql & ", M_LINK2 = '" & ChkString(Request.Form("LINK2"),"") & "'"
end if
if strAge = "1" then
strSql = strsql & ", M_AGE = '" & ChkString(Request.Form("Age"),"") & "'"
end if
if strMarStauts = "1" then
strSql = strSql & ", M_MARSTATUS = '" & ChkString(Request.Form("MarStatus"),"") & "'"
This only makes a little sense to me?!?!?
Sr_Erick.. http://www.geocities.com/sr_erick |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 February 2001 : 00:38:21
|
hmmm, change this line:if strMarStauts = "1" then to this:if strMarStatus = "1" then Let me know if it works ok after that. This should be reported as a bug.
*----*----*----*----*----*----*----*----*
"It's not how long you live that counts,
But how well you live."
*----*----*----*----*----*----*----*----* |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 27 February 2001 : 18:38:50
|
I changed that and tried it but it didn't work. I refreshed the page a few times but still no luck. What now?
Sr_Erick.. http://www.geocities.com/sr_erick |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 February 2001 : 21:38:28
|
Ok, I am running out of ideas of what might be causing the error. If anyone else knows what might be causing the error please let us know.
The only thing I can think of is send me your inc_profile.asp and pop_profile.asp page let me take a look at them.
Are you using Access, SQL or MySql?
And what version of the forum are you using?
*----*----*----*----*----*----*----*----*
"It's not how long you live that counts,
But how well you live."
*----*----*----*----*----*----*----*----* |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 27 February 2001 : 22:23:42
|
I use access 2000 server, and I have the latest version I think cause I just instaled them last week. I will get you those files.
Sr_Erick.. http://www.geocities.com/sr_erick |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 28 February 2001 : 23:46:14
|
Whenever I also try to edit my regular user profile I also get an error message. ?????
Sr_Erick.. http://www.geocities.com/sr_erick |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 01 March 2001 : 00:55:57
|
What version of the forums is this ? Is this a plain Version 3.1 SR4 or one of the Modified versions from Huw or Richard, or did you add MODs yourself ?
If it is a plain version try to re-upload the pop_profile.asp and inc_profile.asp pages and see what happens.
This is an error that I haven't seen before and I really think it is specific to your installation.
Having said that, I still hope we can help you to get it running.
But first we'll need some info on the version etc.
btw, normally you don't (have to) count the linenumbers by hand. If you use an editor that supports line-numbers, like Visual InterDev (not free) of EditPad Lite (free: http://EditPadLite.com ) the linenumbers are shown in the statusbar. It might be best to do that first: download and install EditPad Lite or get hold of an editor with linenumbers.
Pierre |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 March 2001 : 07:59:16
|
Good questions gor.
Also, could you provide a url to your forums so we can take a look?
If you turn off the [b]Marriage Status/b] member feature does the error go away? (hoping you have it on in the first place.)
Your files look ok, except for some extra sql statements you have in there. I will send you back the pop_profile.asp file and see if the change I did will hopefully work. |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 March 2001 : 14:42:42
|
quote:
I use FrontPage 2000 to edit the files and if you right click you can select "goto" and go to any line you want.
Ok, that is one thing you shouldn't do. Don't use Frontpage to edit the forum files. FrontPage will mess up the files and change around the code to the way it wants it to be. Use some other editor to edit the forum files.
You would have to extract the files that you edited, from the snitz forums zip file and upload it to your server.
Of course you would have to add the mods again to the files, but don't use FrontPage editor to do it. If you don't have any other editor to use you can use notpad. Or there is a free editor called Arnnaee or something like that. I'll try and find thr link for you, unless someone else can post the link for it. |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
|
|
Topic |
|
Topic Locked
