| Author |
 Topic  |
|
|
Ferd
Starting Member
United Kingdom
3 Posts |
 Posted - 06 September 2000 : 07:09:07
|
Hi,
Just installed and got v3.1b3 up and running and I decided to switch from DB authentication to NT.
The forum has now linked my NT account to the forum Admin account meaning that I'm the admin, and cannot have a separate profile.
Can anyone shed any light on this ?
Amendments:
OK, so I was a bit confused and realised that when logged in as admin you can use the "Members" option to change the details. However, in NT authentication mode, the "Modify User Profiles" fails to read in the value for the account name. I've tracked the problem to the code in pop_profile.asp below:
<%
case "goModify"
mLev = cint(ChkUser2(Request.Form("User"), Request.Form("Pass")))
if mLev > 0 then '## is Member
if mLev = 4 then
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " <font color=red>& strMemberTablePrefix & "MEMBERS.M_USERNAME, "</font id=red> & strMemberTablePrefix & "MEMBERS.M_PASSWORD, " & strMemberTablePrefix & "MEMBERS.M_EMAIL, " & strMemberTablePrefix & "MEMBERS.M_TITLE, "
strSql = strSQL & strMemberTablePrefix & "MEMBERS.M_POSTS, " & strMemberTablePrefix & "MEMBERS.M_ICQ, " & strMemberTablePrefix & "MEMBERS.M_YAHOO, " & strMemberTablePrefix & "MEMBERS.M_AIM, " & strMemberTablePrefix & "MEMBERS.M_HOMEPAGE, "
strSql = strSQL & strMemberTablePrefix & "MEMBERS.M_COUNTRY, " & strMemberTablePrefix & "MEMBERS.M_SIG, " & strMemberTablePrefix & "MEMBERS.M_LEVEL"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE MEMBER_ID = " & Request.Form("MEMBER_ID")
'strSql = "SELECT * FROM " & strMemberTablePrefix & "MEMBERS "
'strSql = strSql & " WHERE MEMBER_ID = " & Request.Form("MEMBER_ID")
set rs = my_Conn.Execute(strSql)
'## Display Edit Profile Page
%>
The built select statement was missing the "MEMBERS.M_USERNAME" bit.
Regards,
Ferd
Edited by - Ferd on 06 September 2000 08:59:38
Edited by - Ferd on 06 September 2000 09:01:42 |
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 06 September 2000 : 18:16:10
|
Can you get into the database?
Check the M_UserName for the admin account. remove your NT account from it. This is the admin account set it to something. Use it ONLY in DB mode.
Logon as you. Create a new profile. Go into the database and set your self to level 3.
You are now the admin with all the rights.
Thanks for the Bug update, this was removing the M_Username from the database when you updated the profile <img src=icon_smile_shock.gif border=0 align=middle>.
With this update does it set it correctly?
Edited by - kal corp on 06 September 2000 18:16:36 |
 |
|
|
Ferd
Starting Member
United Kingdom
3 Posts |
Posted - 07 September 2000 : 04:12:37
|
Yes I was able to get into the database which is what tipped me off to the problem.
The addition of the M_USERNAME code fixes the problem and I could reassign the user accounts as necessary using the proper screen.
|
|
|
|
Jeepaholic
Average Member
USA
697 Posts |
Posted - 24 October 2000 : 20:50:13
|
Ok, I had the same problem...but was resolved by modifying the databases manually. My NT user account is now an admin, I seem to be able to do whatever I want in the admin portion of the forum.
I'm now trying to set up all the forums and am having trouble... I can set up Categories fine, but when trying to set up forums within those categories, I get this message:
<font color=red><b>There has been a problem!
Invalid Password or UserName</b></font id=red>
Running on Win2k Advanced Server...any thoughts?
Al Bsharah
Jeepaholics Anonymous |
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 24 October 2000 : 21:01:07
|
| currently working NT Issues, Update will be out ASAP |
|
|
|
Jeepaholic
Average Member
USA
697 Posts |
Posted - 11 November 2000 : 13:00:34
|
Not trying to be a pest, just wondering if there was any resolution for this? <img src=icon_smile.gif border=0 align=middle>
Al Bsharah
Jeepaholics Anonymous |
|
|
|
BasQue
Starting Member
Netherlands
21 Posts |
Posted - 15 November 2000 : 10:04:51
|
Same problem here,
When I change to nt-mode, I can create a new Category, but cannot create any FORUMS in it!
<center><font size=4><font color=blue>There has been a problem!</font id=blue>
<font color=red>Invalid Password or UserName
</font id=size4></center></font id=red>
Any updates yet?
Sorry, Somehow I did overlook Jeepaholics reply. I'm working with NT4.0...
<img src="http://www.casema.net/~basvl/basque.gif" border=0>
Edited by - BasQue on 15 November 2000 10:20:40 |
|
|
|
BasQue
Starting Member
Netherlands
21 Posts |
Posted - 27 November 2000 : 05:00:41
|
Hi, I think I found something:
First check the first 2 reply's in this topic and do exactly what Ferd and Kal Corp say.
After doing this, I found that the problem was not completely solved, because I use 2 different names for "UserName" and "User Account" within my profile.("username" works as an alias, and "account" is the NT account)
When you post a new forum, the account is validated by the alias name in stead of the NT account.
I did the following which seems to solve it:
<b><font color=red>NOTE thate I didn't completely test the application after the change!</b> To me it looks like it can have major impact on the entire app., but so far no strange things happened after the change</font id=red>
In the SUB "NTUser()" in the "inc_functions.asp"
change the following line:
Response.Cookies(strCookieURL & "User")("Name") = rs_chk("M_NAME")
into:
Response.Cookies(strCookieURL & "User")("Name") = rs_chk("<font color=red>M_USERNAME</font id=red>")
Maybe this will cause some other functions not to work, but I thing I at least found something to work on for the developers...<img src=icon_smile_approve.gif border=0 align=middle>
<img src="http://www.casema.net/~basvl/basque.gif" border=0> |
|
|
|
Jeepaholic
Average Member
USA
697 Posts |
Posted - 30 November 2000 : 02:14:00
|
This did the trick BasQue...finally got around to messing with it. I do notice that occasionally the "You are logged in as" will change.
For example, initially I'm:
Al Bsharah (absharah)
Then occasionally I'll see:
absharah (absharah)
Everything still seems to work fine though...sounds like there's still a cookiebug somewhere....anyway, thanks a ton!
Al Bsharah
Jeepaholics Anonymous |
|
|
|
BasQue
Starting Member
Netherlands
21 Posts |
Posted - 30 November 2000 : 04:03:25
|
Hmmm, I Never noticed this cookieproblem so far. Only the first time, right after making the change.
Closing and restarting the browser was sufficient to solve the problem.
Maybe it's somewhere in the browser's cache.
Have you tried to clean the temporary internet files?<img src=icon_smile_question.gif border=0 align=middle>
=============
Grtz,
Bas
<img src="http://www.casema.net/~basvl/basque.gif" border=0> |
|
|
|
Jeepaholic
Average Member
USA
697 Posts |
Posted - 30 November 2000 : 13:24:26
|
Just noticed another problem. I'm unable to delete my own messages because of the following error in the pop-up window:
No Permissions to Delete Reply
Go Back to Re-Authenticate (link doesn't help)
Maybe we should consolidate (or close one) of the two identical threads discussing this right now....?
Al Bsharah
Jeepaholics Anonymous |
|
|
|
Gossamer
Starting Member
USA
22 Posts |
Posted - 01 December 2000 : 17:05:26
|
I am having same error message/problem, however it is when I am trying to unlock a forum. It seems that any action that requires the admin to do is running into the permission problem. Anyone have a fix?
|
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 05 December 2000 : 00:13:01
|
Im not having any of these error :-(
But I also found these errors and updated them along time ago I think. Waiting for the next release to come out to post them
|
|
|
|
Jeepaholic
Average Member
USA
697 Posts |
Posted - 06 December 2000 : 15:51:25
|
Yet another error is that the Active Topics are not working. Doesn't seem to update automatically. Clicking on the "Mark all Topics Read" seems to work though, but only until for a short time (probably until it rechecks the cookie or database or whatever.) To be honest, I can't figure out WHAT date it keeps putting in there...just a date that's like a week old now.
Al Bsharah
Jeepaholics Anonymous
Edited by - jeepaholic on 06 December 2000 16:26:11 |
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 08 December 2000 : 22:19:06
|
I had these errors and updated my production server. I just did not write them down..
I was not going to go over the Errors until a new version came out. I want to add the Subcategories to it and clean up the code.
CYA then
|
|
|
|
BasQue
Starting Member
Netherlands
21 Posts |
Posted - 09 December 2000 : 06:05:01
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> #1
Just noticed another problem. I'm unable to delete my own messages because of the following error in the pop-up window:
No Permissions to Delete Reply
Go Back to Re-Authenticate (link doesn't help)
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> #2
I am having same error message/problem, however it is when I am trying to unlock a forum. It seems that any action that requires the admin to do is running into the permission problem. Anyone have a fix?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Unfortunately I did not record all my changes either <img src=icon_smile_sleepy.gif border=0 align=middle>(just like Kal Corp), but I had the same problems that you describe.
It was in the pop_delete.asp that I <b>changed the following lines:</b>
mLev = cint(ChkUser2(Request.Form("User"), Request.Form("Pass")))
<b>INTO:</b>
mLev = cint(ChkUser2(<font color=red>STRdbntUserName</font id=red>, Request.Form("Pass")))
Because these problems also occure with locking and unlocking topics as you describe, You can also change the same lines in pop_lock.asp and pop_open.asp.
In these files also change:
mLev = cint(ChkUser(Request.Form("User"), Request.Form("Pass")))
<b>INTO:</b>
mLev = cint(ChkUser(<font color=red>STRdbntUserName</font id=red>, Request.Form("Pass")))
Please try, and see if the problems are solved.
I did not have the problems with the non-working active topics (yet)
<img src="http://www.casema.net/~basvl/basque.gif" border=0>
Edited by - BasQue on 11 December 2000 02:46:59 |
|
|
| |
Topic |
|
Topic Locked
