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
 User Fields Mod problem
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

dcwebman
Junior Member

USA
105 Posts

Posted - 19 April 2001 :  12:14:01  Show Profile  Visit dcwebman's Homepage
I'm trying to use Huwr's UserFields Mod. It was working perfectly but am now having problems. I installed only that Mod on 3.1SR4. I am using NT authentication and whenever somebody tries to register now, they get the error:

ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/Jellyfish/forum/inc_functions.asp, line 660

The problem appears to be the confusion between the M_NAME and M_USERNAME fields. The GetMemberID function is using username but the MOD is passing the name. Seems like it should pass Username somehow in order to work.

But then I noticed in the database that one users NT name is already in there with a M_STATUS of 0. So if that user registered again and the username was passed to GetMemberID, more than 1 record would be returned. Either the GetMemberID function needs to have something like "and M_STATUS=1" added or figure out what M_STATUS = 0 means.

Any fixes for this MOD?
Thanks.

-----------
Jeff

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 19 April 2001 :  13:10:59  Show Profile  Visit HuwR's Homepage
in the getmemberid function, change the SELECT query to this

strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & fUser_Name & "'"


Go to Top of Page

dcwebman
Junior Member

USA
105 Posts

Posted - 19 April 2001 :  17:02:22  Show Profile  Visit dcwebman's Homepage
Thanks - I knew I would get a quick reply. That didn't seem to work though. Since I have 15 minutes to get this working, I'm going to disable the Mod right now and work on it later. Thanks!

-----------
Jeff
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.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07