I have had two distinct problems with activating pending accounts.
in the first one, users were getting an error about M_USERNAME could not be a 0 length field or something like that. Since this field is normally only used for NT authentication, I went ahead and changed the property of the field in the database. I was then able to activate the account of the girl who encountered it. I also have three other acount waiting to be activated, but when I click on the link in admin_accounts_pending.asp I get the following error:
Error Type:
Microsoft VBScript runtime (0x800A005E)
Invalid use of Null: 'Replace'
/iceforums/inc_func_common.asp, line 457
Line 457 contains the following code
Case "SQLString"
fString = Replace(fString, "'", "''")
if strDBType = "mysql" then
fString = Replace(fString, "\0", "\\0")
fString = Replace(fString, "\'", "\\'")
fString = Replace(fString, "\""", "\\""")
fString = Replace(fString, "\b", "\\b")
fString = Replace(fString, "\n", "\\n")
fString = Replace(fString, "\r", "\\r")
fString = Replace(fString, "\t", "\\t")
fString = Replace(fString, "\z", "\\z")
fString = Replace(fString, "\%", "\\%")
fString = Replace(fString, "\_", "\\_")
end if
fString = HTMLEncode(fString)
chkString = fString
exit function
Any help will be appreciated..