I think its the avatar mod and you either missed something or have something in the wrong spot. The row sequence is out of order.
In "topic.asp" look at this part of the code around line 300 and make sure you added the avatar changes in the right place (I think its after "M.M_COUNTRY").
'## Forum_SQL
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO"
strSql = strSql & ", M.M_TITLE, M.MEMBER_ID, M.M_HOMEPAGE, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY, M.M_AVATAR_URL"
strSql = strSql & ", R.REPLY_ID, R.FORUM_ID, R.R_AUTHOR, R.TOPIC_ID, R.R_MESSAGE, R.R_LAST_EDIT"
strSql = strSql & ", R.R_LAST_EDITBY, R.R_SIG, R.R_STATUS, R.R_DATE"
Now look at the changes you made here around line 523. The avatar code needs to be added in the same place you added it above Again I think its after the country. All those numbers have to be in sequence. rM_NAME = 0
rM_RECEIVE_EMAIL = 1
rM_AIM = 2
rM_ICQ = 3
rM_MSN = 4
rM_YAHOO = 5
rM_TITLE = 6
rMEMBER_ID = 7
rM_HOMEPAGE = 8
rM_LEVEL = 9
rM_POSTS = 10
rM_COUNTRY = 11
rM_AVATAR = 12'increase all the numbers after this by 1, so they are in sequence
rREPLY_ID = 12
rFORUM_ID = 13
rR_AUTHOR = 14
rTOPIC_ID = 15
rR_MESSAGE = 16
rR_LAST_EDIT = 17
rR_LAST_EDITBY = 18
rR_SIG = 19
rR_STATUS = 20
rR_DATE = 21
In other words, it doesn't matter where you add it. The order just has to be consistent.
ps - I don't have a copy ot the avatar mod handy, so I don't know if rM_AVATAR or M.M_AVATAR_URL are spelled correctly, so refer to the installation instructions.
Topic Locked
Posted - 24 April 2008 : 13:37:15
