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.
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!