| Author |
 Topic  |
|
shaneb
Junior Member
USA
319 Posts |
 Posted - 02 January 2001 : 03:19:40
|
<b> Need Some Help Please.</b>
I got the MOD Commander working and the Slash MOD shows up in the Admin Section. But when I click on the go link to go to /forum/mods/slash_admin.asp I get a HTTP 500 - Internal server error.
I am using ver 3.1 SR4 (newest Snitz Forum Ver) and I am on a Win2K Server using IIS 5.0 ASP 3.0.
I am also using MOD Commander ver 1.05 and
Slash Mod ver 2.00
Anybody else having this problem? Did I leave something out?
Thanks in advance!
Shane B.
Edited by - shaneb on 02 January 2001 03:24:16 |
 |
|
|
evehawk
New Member
Australia
65 Posts |
Posted - 03 January 2001 : 08:46:20
|
animedj, Thanks for the great mode :) I get it working fine but have a small question: How can i block out Posts from the test section of my forum ?
Thanks
PS: if you read this richard may be you can help :)
|
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 03 January 2001 : 10:37:15
|
Hello everybody.. well.. evehawk.. you can do the following.. first get the number of your FORUMID for the forum that you don't to show and then in the strSQL stament do the following :
strSQL = "SELECT TOP " & slPosts & " FORUM_TOPICS.TOPIC_ID, " & _
...
"WHERE FORUM_FORUM.F_PRIVATEFORUMS = 0 AND " & _
"FORUM_TOPICS.FORUM_ID = FORUM_FORUM.FORUM_ID AND " & _
"FORUM_TOPICS.T_AUTHOR = FORUM_MEMBERS.MEMBER_ID AND " & _ 'this line changes
"FORUM_FORUM.FORUM_ID <> [your forum id]" 'new line added
and frankie.. can you do this.. before this line..
set objRec = my_Conn.Execute(strSql)
add this line :
response.write "strSQL = " & strSQL
and post it here..because it seems that there is a problem with you sql stament
---
Johann Reyes
http://animedj.com |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 03 January 2001 : 10:39:09
|
ohh yeah and shaneb.. I'm not quite sure about the problem that you are getting... anyone else getting this problem.. or anyone else running the slash mod in ASP 3?? it might related to ASP3 but i can't tell now as this is the first time that i encounter a problem like this.
---
Johann Reyes
http://animedj.com |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 03 January 2001 : 14:09:27
|
animedj, I did and that's what I got when I ran slash.asp
<pre id=code><font face=courier size=2 id=code>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/forums/mods/slash.asp, line 13</font id=code></pre id=code>
I'm pretty sure my db connection is setup right cos the rest of the forum is working fine!
thoughts? Thank you
ô¿~ |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 03 January 2001 : 16:12:09
|
hmm .. can you check that in the page that you are using the slash.asp you also included these 2 files :
<!--#INCLUDE FILE="config.asp" -->
<!--#INCLUDE FILE="inc_functions.asp" -->
( need to point you your config.asp and inc_functions.asp in your forusm directory)
---
Johann Reyes
http://animedj.com |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 03 January 2001 : 17:30:44
|
animedj,
Thanks for your concerns. I had to add <font color=red>Response.end</font id=red> right after that <pre id=code><font face=courier size=2 id=code>Response.Write</font id=code></pre id=code> statement of yours and this is what I got
<pre id=code><font face=courier size=2 id=code><font color=blue>strSQL = SELECT <font color=red>TOP 0</font id=red> FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_SUBJECT, FORUM_TOPICS.T_AUTHOR, FORUM_MEMBERS.M_NAME, FORUM_TOPICS.T_REPLIES, FORUM_TOPICS.T_DATE, FORUM_TOPICS.T_MESSAGE FROM FORUM_TOPICS, FORUM_FORUM, FORUM_MEMBERS WHERE FORUM_FORUM.F_PRIVATEFORUMS = 0 AND FORUM_TOPICS.FORUM_ID = FORUM_FORUM.FORUM_ID AND FORUM_TOPICS.T_AUTHOR = FORUM_MEMBERS.MEMBER_ID ORDER BY FORUM_TOPICS.TOPIC_ID DESC;</font id=blue></font id=code></pre id=code>
Thoughts about that 0 (one in red) and the FORUM_FORUM.... stuff?!!
ô¿~
Edited by - frankie on 03 January 2001 17:36:43 |
|
|
|
evehawk
New Member
Australia
65 Posts |
Posted - 03 January 2001 : 21:45:29
|
Thanks animedj, the querry work great.. now i have topics on my frontpage :)
btw if i want select/de-select extra forum in the future ?(like test2 etc.) can i add extra line that point to the forum_id after the line you told me to ?
Thanks again
|
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 04 January 2001 : 13:53:07
|
yep evehack, and Frankie.. the last error that you got it's related with your connection.. the strSQL seems fine.. do this :
before this line (13) :
my_Conn.Open strConnString
add this these 2 lines :
response.write "Your connection is - " & strConnString
response.end
don't post it here... that's your connection.. check it's alright.. or if it isn't throwing anything..
---
Johann Reyes
http://animedj.com |
|
|
|
paulj
Starting Member
6 Posts |
Posted - 04 January 2001 : 20:04:05
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
ohh yeah and shaneb.. I'm not quite sure about the problem that you are getting... anyone else getting this problem.. or anyone else running the slash mod in ASP 3?? it might related to ASP3 but i can't tell now as this is the first time that i encounter a problem like this.
---
Johann Reyes
http://animedj.com
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I am using version 3.1 Final. I installed the Mod in the MODS directory and since I don't have Mod Commander, I attempted to run slash_admin.asp. I was rediredted to,
setup.asp?RC=1&CC=1&strDBType=access&EC=-2147467259 which does not exist, and therefore got a 404 not found error. Is there supposed to be a setup.asp page in the Mods directory?
Thanks,
Paul
|
|
|
|
bugfix
Starting Member
Singapore
47 Posts |
Posted - 05 January 2001 : 00:32:53
|
Hi,
I downloaded slash 2.0 and modified it a bit to place it on my main page.
http://www.hardwarezoom.com/sg
I encountered a bug or may be not a bug, when displaying the topic description, if there are image links in it, the HTML tag will be shown on the description.
Just check out the bottom of the main page, under 'Latest Forum Post'.
Thanks in advance.
|
|
|
|
evehawk
New Member
Australia
65 Posts |
Posted - 05 January 2001 : 09:52:57
|
Bugfix, if you look at slash.asp there is a HTMLEncode() check. to get rid of what you have on your forum i use the CleanCode() from inc_function.asp. You may have to modi the CleanCode() a bit as in my case ( i modify it and called it something myclean().
Hope it help
|
|
|
|
bugfix
Starting Member
Singapore
47 Posts |
Posted - 05 January 2001 : 10:22:51
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Bugfix, if you look at slash.asp there is a HTMLEncode() check. to get rid of what you have on your forum i use the CleanCode() from inc_function.asp. You may have to modi the CleanCode() a bit as in my case ( i modify it and called it something myclean().
Hope it help
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
i replaced HTMLEncode with CleanCode but it doesn't work properly.
I have check the CleanCode function in inc_functions.asp look ok to me. My forum allows post of image as well.
Please help. |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 05 January 2001 : 10:29:50
|
hmm i haven't tried what evehack wrote.. but I'll give it a try... the reason why is showing the html code of the image it's that in some cases when it trimmed the paragraph to the lenght specified some times would throw something like this in the code :
<img src=" (this is a case..)
so stuff like this can break down one's html layout .. so that's why i prefer to encode and not to show the graphic.
PaulJ... that's an error that has to do more with the config.asp than the mod.. somehow it can't find the ConfigLoaded application variable and that's why it's trying to redirect you to the setup file (in the root directory) .. a good step to do it's to check what's throwing the strCookieURL variable to see if it's been set up to the right path ..
---
Johann Reyes
http://animedj.com |
|
|
|
evehawk
New Member
Australia
65 Posts |
Posted - 05 January 2001 : 10:38:54
|
this is what i do:
take the cleancode()
what ever you dont want to show in your frontpage look at the part
fString = replace(fString, "<b>",<font color=red>"[b]"</font id=red>, 1, -1, 1)
replace the red part with ""
i left the portion:
fString= replace(fString, "<img src=icon_smile_angry.gif border=0 align=middle>", "<img src=icon_smile_angry.gif border=0 align=middle>", 1, -1, 1)
as i allow those icon show up.
after you finish replace those red part, paste the new cleancode() down with diff function name,i use myclean()
then replace HTMLencode() with your new function
note: at the end of the cleancode there is a line: CleanCode = fString
replace cleancode with with what ever your new function name is (myclean in my case)
Not an elegant fix but work for a asp newbie like me
Hope it help
|
|
|
|
Topic |
|
Topic Locked
