| Author |
 Topic  |
|
|
akewlfish
Starting Member
USA
8 Posts |
 Posted - 17 January 2010 : 18:51:12
|
Hello
Starting yesterday I cannot activate any pending members. When I try to manually add them I get this error below now.
Sometime a few weeks ago instead of updating the forum I just did a clean install. I only added the Avatar Mod from SnitzBitz which on the register.asp page is line 185 and that was working.
I did notice when I peeked inside the Access database that the Pending member Id number is starting from scratch 1 while if they were a member they would be something like 200. Is this a mismatch or designed this way? Could this be a problem like there is no avatar at the moment, yet when I click the link to activate to pending member, it throws the error because it is looking for an avatar?
Yesterday, after shutting down the forum, I wound up manually adding a pending member to that table and deleting the row from the pending member table.
I am all ears for suggestions as well as accommodating a few headaches
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/tnpf/register.asp, line 185 |
|
|
Etymon
Advanced Member
United States
2396 Posts |
Posted - 17 January 2010 : 22:04:51
|
| Can you please post what the code says a few lines before that line as well as on that line? |
 |
|
|
akewlfish
Starting Member
USA
8 Posts |
Posted - 17 January 2010 : 22:43:07
|
I think I have fixed this. I found a snippet of code that was missing and put it back. I don't know how it changed but, it did. I uploaded the fixedpage to find out it still didn't work. So I logged out, closed Firefox, and cleaned the cache. Once Firefox was loaded and I logged back in the problem was solved. Once another new member joins, I will let you if the problem arises again.
The error was on line 87
'###Forum_SQL
strSql = "SELECT M_NAME, M_USERNAME, M_PASSWORD, M_KEY, M_LEVEL, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO" & _
", M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT" & _
", M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_LINK1, M_LINK2, M_AGE, M_DOB, M_MARSTATUS, M_SEX, M_OCCUPATION" & _
", M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_SHA256, M_AVATAR_URL" & _
" FROM " & strMemberTablePrefix & "MEMBERS_PENDING" & _
" WHERE M_KEY = '" & key & "'"
|
|
|
| |
Topic |
|
|
|
Topic Locked
