| Author |
 Topic  |
|
|
sam_i_am003
New Member
50 Posts |
 Posted - 17 October 2003 : 15:09:15
|
i got an avatar mod from snitzbitz, the most current version. I tried installing it yesterday, and no luck. well, i tired again today, and had my friend check after each file i modified. everything was going fine until i modified the last file, topic.asp. now, the avatars are not showing, and the original post has no avatar at all. But heres the thing, all the replies, are just topic numbers. like the reply would have the spot where the avatar is with a little x as the picture, like it cannot find it. and then it would have 3085, or the topic number as the whole post. And, when i click on a topic with multiple pages, i get an error:
Technical Information (for support personnel)
Error Type:
Microsoft VBScript runtime (0x800A0006)
Overflow: 'cLng'
/internet/nexus/forum/inc_func_secure.asp, line 50
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Page:
GET /internet/nexus/forum/topic.asp
but when i click on the page number itself, it comes up, but with all the replies being the topic number over and over again.
I followed instructions, i know i did. and on the last instruction where i copy and paste the stuff for my version... i know i have the right version copied. please help me. I've been trying to do this for 3 days now at no avail.
Here is the address to the forum.
http://65.174.230.76/internet/nexus/forum/default.asp
any help on this would be greatly appreciated.
by the way, i am using version 3.4.03. |
Edited by - sam_i_am003 on 18 October 2003 13:04:03 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 17 October 2003 : 17:17:14
|
most likely the problem lies in this section:
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
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
if CanShowSignature = 1 then
rM_SIG = 22
end if those have to be in the exact order that you have them listed here: '## 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"
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"
if CanShowSignature = 1 then
strSql = strSql & ", M.M_SIG"
end if
strSql2 = " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "REPLY R "
strSql3 = " WHERE M.MEMBER_ID = R.R_AUTHOR "
strSql3 = strSql3 & " AND R.TOPIC_ID = " & Topic_ID & " "
If the order gets messed up, then there is going to be problems.
If you had other MODS added before you attempted the Avatar MOD, then that section you modified had probably already been modified before, so the numbering may be different from what the Avatar MOD intructions show. |
 |
|
|
sam_i_am003
New Member
50 Posts |
Posted - 17 October 2003 : 17:33:49
|
okay, well this is what i have, and i cannot tell if they are in order, bt i followed the directions.
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
rREPLY_ID = 13
rFORUM_ID = 14
rR_AUTHOR = 15
rTOPIC_ID = 16
rR_MESSAGE = 17
rR_LAST_EDIT = 18
rR_LAST_EDITBY = 19
rR_SIG = 20
rR_STATUS = 21
rR_DATE = 22
if CanShowSignature = 1 then
rM_SIG = 23
end if
and the other one is :
'## Forum_SQL
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO, M.M_PMRECEIVE"
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"
if CanShowSignature = 1 then
strSql = strSql & ", M.M_SIG"
end if
strSql2 = " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "REPLY R "
strSql3 = " WHERE M.MEMBER_ID = R.R_AUTHOR "
strSql3 = strSql3 & " AND R.TOPIC_ID = " & Topic_ID & " "
are these in wrong order? and if so, then why do the instructions say they need to go in this order?
Also, thank you soooooo much for helping me out with this. this is my very first mod, and i am pulling my hair out. is it true that the avatar mod is the hardest mod? geez i hope so.
also, this "M.M_PMRECEIVE" is not even in the first sectio thingy... do i need to add it, and how do i do that? |
Edited by - sam_i_am003 on 17 October 2003 17:38:27 |
|
|
|
sam_i_am003
New Member
50 Posts |
Posted - 17 October 2003 : 18:13:43
|
OMG... YOU ARE MY HERO!!!! i added the one thing "M.M_PMRECEIVE", and put the order back correctly... and it worked... the replies are showing up and everything! also, is the "no avatar" avatar supposed to show up in all posts yet? cuz it isn't. just wanna make sure this is normal.
Also, thank you soooooooo much for helping me!!!!! |
Edited by - sam_i_am003 on 17 October 2003 18:14:20 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 17 October 2003 : 18:16:32
|
yep, that M.M_PMRECEIVE is probably what's throwing it off, change that first section to this:
rM_NAME = 0
rM_RECEIVE_EMAIL = 1
rM_AIM = 2
rM_ICQ = 3
rM_MSN = 4
rM_YAHOO = 5
rM_PMRECEIVE = 6
rM_TITLE = 7
rMEMBER_ID = 8
rM_HOMEPAGE = 9
rM_LEVEL = 10
rM_POSTS = 11
rM_COUNTRY = 12
rM_AVATAR = 13
rREPLY_ID = 14
rFORUM_ID = 15
rR_AUTHOR = 16
rTOPIC_ID = 17
rR_MESSAGE = 18
rR_LAST_EDIT = 19
rR_LAST_EDITBY = 20
rR_SIG = 21
rR_STATUS = 22
rR_DATE = 23
if CanShowSignature = 1 then
rM_SIG = 24
end if |
|
|
|
sam_i_am003
New Member
50 Posts |
Posted - 17 October 2003 : 19:06:32
|
| yes, i did that, thank you for explaining it to me. one more question... is the "no avatar" avatar supposed to show up on all the posts yet? because it isn't, and i was wondering if there was a way i could get it do that. thank you very much for the help you have already given me. you have no idea how releived i am. |
|
|
|
sam_i_am003
New Member
50 Posts |
Posted - 18 October 2003 : 12:48:24
|
okay, new problem, when i got to mass avatar add, i get this error:
Error Type:
Microsoft VBScript runtime (0x800A004C)
Path not found
/internet/nexus/forum/admin_avatar_mass_add.asp, line 88
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Page:
POST 86 bytes to /internet/nexus/forum/admin_avatar_mass_add.asp
POST Data:
Mode=addThemNow&AvatarFolderNew=avatars1%2F&AvatarFolderMain=Avatars%2F&submit1=Submit
Time:
Saturday, October 18, 2003, 12:27:35 PM
More information:
Microsoft Support
what did i do wrong now???
when i opened the file and looked around line 88, this was there:
newAvatarFolder = Server.MapPath(Request.Form("avatarFolderNew"))
Set imagesFolder = filesys.GetFolder(newAvatarFolder)
set filesObj = imagesFolder.Files
For Each file in filesObj
Is that wrong? or do my folders need to be a specific name? My avatar folder (named "Avatars"), is in with the forum files, and inside the main avatar folder is the folder (named "Avatars1"), with all my new avatars. Help.... pleez |
Edited by - sam_i_am003 on 18 October 2003 12:52:42 |
|
|
|
sam_i_am003
New Member
50 Posts |
Posted - 18 October 2003 : 13:03:45
|
also, i find when i leave out the main folder name and leave the new avatar in the main forum folder as the author suggests, they do upload, but the images do not show up... they are a box with an x in it. 
Okay... i edited this in as to not start another post, but everytime i try to add... all i get is "Congratulations, Back To Admin Home". Grrrrrrr... and none of them are uploading...this is making me angry  |
Edited by - sam_i_am003 on 18 October 2003 13:39:10 |
|
|
|
sam_i_am003
New Member
50 Posts |
Posted - 18 October 2003 : 14:14:15
|
| update... well... it seemed like even if i out in the folder name... it would still assume that the avatars were in the main forum folder... so, i said skrew it, and put them all in the main forum folder. oh well, they work, and i am grateful enough for that. thanx again for helping me. |
|
|
| |
Topic |
|
|
|
Topic Locked
