| Author |
 Topic  |
|
|
osdd
New Member
Canada
54 Posts |
 Posted - 02 September 2002 : 14:53:30
|
Hi
i have install the avatar mod but i'm get an error everytime i try to add an avatar the error is as follows:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/forum/admin_add_avatar.asp, line 100
i looked at line100 and this is what is says
my_Conn.Execute (strSql)
i'm using (access) on our forum is there anything i need to do to correct this error cause our members are screaming to have this.also where it says Avatar Display Name:what should we put as the ID for it.
We are also getting errors when trying to view members profiles either in memebers.asp or pop_profile.asp the error is page can't be displayed
We are also using snitz version 3.4.02
OSDD Staff
|
"Because I said so."
 |
Edited by - osdd on 02 September 2002 19:59:45 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 02 September 2002 : 20:07:20
|
"Could not find output table 'FORUM_AVATAR'."
Means: "Hey, I could not find the FORUM_AVATAR table in the database"
[ODBC Microsoft Access Driver] = you are going to have many, many problems installing MODS.
try reading this:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=26081 |
 |
|
|
osdd
New Member
Canada
54 Posts |
Posted - 02 September 2002 : 21:54:38
|
Thanks Richard
the problem is that we have to use a DSN_name to get the forums to work on our host server. i'll see if they support anything else now. |
"Because I said so."
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 02 September 2002 : 22:19:26
|
you can try using the following in the "Alternative MOD Setup" (there is a link to this right next to the MOD Setup link in the Admin Options:
Avatar Mod for 3.4
[CREATE]
AVATAR
A_ID
A_URL#varchar (255)#NULL#
A_NAME#varchar (50)#NULL#
A_MEMBER_ID#int#NULL#
[END]
just copy and then paste the above into the textarea and click on the submit button. This will add the FORUM_AVATAR table to your database. |
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 02 September 2002 : 22:58:45
|
Hi Richard
i try what you suggested above and got this
Avatar Mod for 3.4
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL )
Table already exists
--------------------------------------------------------------------------------
and still have the orginal problem and i even tried your fist suggestion but got the same resualts
OSDD Staff |
"Because I said so."
|
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 02 September 2002 : 23:21:18
|
| i figured it out and finally got it to work thanks for the help richard |
"Because I said so."
|
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 02 September 2002 : 23:29:51
|
well i can add avatars without any problems now but now i can't view or change members profiles i get the error The page cannot be displayed every time is try it.
here is the link to my text version of pop_profile.asp: http://iafs.gameralliance.com/pop_profile.txt
hope this helps you help me some more.
i also just notice that when tring to view posts i get this error
Microsoft VBScript compilation error '800a0408'
Invalid character
/forum/topic.asp, line 586
" <p><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Reply_MemberCountry & "</small></font><br />" & vbNewLine & _Response.Write " </p>" & vbNewLine
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^
here is the link to my text version of topic.asp: http://iafs.gameralliance.com/topic.txt
luck this is our test forum |
"Because I said so."
|
Edited by - osdd on 02 September 2002 23:37:28 |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 03 September 2002 : 04:01:03
|
hi~ osdd,
i found some mistakes on your modded files..(i only check the Avatar Mod modified..). i guess you still not very familiar with this "mod" work...  yeah~ it's ok. and keep going! after you installed more Mods, i think you'll become "expert" about this "copy/paste" stuff...
in topic.asp
at line.585, line.586
(i think the instruction said you should replace this section..)
now you should delete line.585, and line.586 before Response.Write....
so after modified, this two lines would remain to this line
Response.Write " </p>" & vbNewLine
in line.790~line.793
(the mod code in Avatar readme.html show in a textarea, and i think u forgot scrolling the scroll bar... so u only copy/paste the half of code here..)
now in line.794, you should insert this missing part..
response.write " <p><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Member_Country & "</small></font><br />" & vbNewLine & _
and in pop_profile.asp
at line.306~line.312
(the same mistake.. u forgot scrolling the textarea... )
so you must add/insert these in line.313
else
Response.write "<tr>" & vbNewLine & _
" <td colspan=""2"" bgColor=""" & strCategoryCellColor & """ align=""center""><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strCategoryFontColor & """> Avatar </font></b></TD>" & vbNewLine & _
"</tr>" & vbNewLine & _
"<tr>" & vbNewLine & _
" <td bgColor=""" & strPopUpTableColor & """ align=""center"" colspan=""2""><img src=""" & ChkString(rs("M_AVATAR_URL"), "url") & """ width=""" & intAvatarWidth & """ height=""" & intAvatarHeight & """ border=""" & intAvatarBorder & """></td>" & vbNewLine & _
"</tr>"
end if
end if
i think these erro just due to the wrong code copy/paste. and if you recheck your Avatar Mod install again, you'll solve this problem..  |
~ . .. .. .~ .~~ |
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 03 September 2002 : 21:13:19
|
Ok i was able to fix the pop_profile.asp fine and it is work fine. But i was unable to fix the Topic.asp file and have brain freezes trying to fix it i copied everything fine but now i'm gett ing this error:
The page cannot be displayed
here is the link to my text version of topic.asp: http://iafs.gameralliance.com/topic.txt |
"Because I said so."
|
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 04 September 2002 : 00:24:05
|
hi~ osdd
the error in line.585,586 seem not fixed correctly.
now you need to DELETE this line.586
" <p><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Reply_MemberCountry & "</small></font><br />" & vbNewLine & _Response.Write " </p>" & vbNewLine
after delete this line, the code would look like this..
::
:
line.585 Response.Write " </p>" & vbNewLine <--- make sure here NO & _
line.586 if Reply_MemberAvatar <> "noavatar.gif" then
line.587 response.write" <img src=""" & Reply_MemberAvatar & """..............
::
and in line.793 ..... you still missing the half part of modded code..
try Insert the red color code between line.793 & line.794
::
:
line.793 end if
response.write " <p><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Member_Country & "</small></font><br />" & vbNewLine & _
line.794 " <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Member_Posts & " Posts</small></font></p></td>" & vbNewLine & _
::
:
please try it again ~~~ 
i think you'd better to check/compare the original topic.asp and Avatar Mod readme file again. make sure you have the modified code correctly.
and maybe you should know this...the Response.Write code usually look like this..
Response.Write "xxxxxxxxx....." & vbNewLine & _
"xxxxxxxxxxx......" & _
"xxxxxxxxxxx......" & vbNewLine
Response.Write "xxxxxxx.....
so if you found this in your code..
& vbNewLine & _Response.Write ".....
or
Response.Write "xxxxxxxx..." & vbNewLine
"xxxxxxx...."
it should be a obvious code error.....
and do'nt feel discouraged about this... it's a learning process to "Snitz"... just keep going~~~ |
~......~.~~ |
Edited by - DoraMoon on 04 September 2002 00:27:49 |
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 04 September 2002 : 07:15:35
|
Ok i did all that. and double check to make sure but still getting the error:
The page cannot be displayed
not giving up just has to be something i missed or not seeing
here is the link to my text version of topic.asp: http://iafs.gameralliance.com/topic.txt
After atriple check i found the error and was able to fix it. for those that help me along thanks |
"Because I said so."
|
Edited by - osdd on 04 September 2002 07:29:38 |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 04 September 2002 : 13:22:53
|
hi~ osdd
i check your topic.txt, it seem no big problem with Avatar modded..
although you still missing something to print Reply_MemberCountry & Member_Country...
but it should not affect the topic.asp file work... so if you still got the error "can't display page.." i think it maybe some other problem not cause from topic.asp or Avatar mod.
can you select Avatar from Profile no problem ?? 
anyway, here is some modded files (a Clean Snitz v3.4.02 with Avatar Mod)
topic.asp.txt
pop_profile.asp.txt
i have tested that, it work fine! so if you ONLY install avatar mod, you can replace these two files. or you can try compare with your files again to see what's going wrong.
hope this time can solve your problem.... |
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 06 September 2002 : 19:23:56
|
Doramoon>>
I tried those two files you made but when they are changed to just asp format they don't work. my suggestion is that in future save the topic.asp as a zip file for people to download and use that just makes it easier on everyone.
thanks for your help. still got one minor bug to work out but everything is working fine |
"Because I said so."
|
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 06 September 2002 : 20:45:22
|
hi~ osdd,
we can't see source code of .asp files from browser...
that's why we need to link it as a plain txt file.
so you must "Save As" these .txt files on your computer first(right-click --> save as),
then change it back to .asp on your PC (just remove the .txt )
anyway, here is a zip file ... avatar34_modded.zip
i also including these fix in topic.asp
- (v3.4.02) BUG+FIX: topic.asp(in the Topic_nav Sub)
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=34308
and
- (v3.4.02) small design change for topic.asp
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=34280
hope this time can really help you. sorry for inconvenience... |
~......~.~~ |
|
|
| |
Topic |
|
Topic Locked
