| Author |
 Topic  |
|
Rasyr
Junior Member
USA
199 Posts |
 Posted - 11 July 2002 : 11:50:29
|
Can somebody please help me? I have made numerous Mods to my fourms, but I have just realized that I have a problem. When I try to view an archived message I get a SQL error. I know what the problem is, but I have no idea on how to fix this.
The reason I am having this problem is because of code in inc_activeusers.asp (around line 95). During my mods, I have updated the database so that I am using all short URLs (no mor archive=true in the arguements on the URL). This is the cause of my problem.
I originally posted on this problem over in the General Forum, and then realized that it might be better to post it here. Here is the link to the original post, which includes the snippet of code that I need to get rewritten in order to make it all work properly.
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=30904
I know that I need to rewrite that particular Case Statement, and I am pretty sure of what I have to include, and how to change things after the SQL statement to get it to do what it is supposed to do, but I need help rewriting the SQL so that I am pulling information from two tables (with identical fields), so that I can check the T_STATUS field for a "0" or a "1", and then just run an IF statement off of that.... (atleast, I think that is the field I need to check)
Any help in rewriting this SQL would be greatly appreciated...
**TANSTAAFL** |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 July 2002 : 12:47:33
|
Your topic title is a bit misleading, I thought you meant you couldn't view archive posts, when in fact you mean your active users link is broken.
why did you change it to remove the archive = true ?
how does it know to look in the archive table ?
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 July 2002 : 13:02:19
|
I don't even understand why you decided to post this here. I told you at the other topic that I was looking into it. Now the other topic has been locked. Maybe I should give up on this too   .
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Rasyr
Junior Member
USA
199 Posts |
Posted - 11 July 2002 : 13:05:40
|
I posted over here, before yuo responded to the other topic. 
Also, the snippet of code in the other thread contains line 95 in the code snippet at the very top (it is the line that says "set rst =" and does the SQL statement.
Here is the entire line reproduced
set rst = my_conn.execute("SELECT FORUM_ID,TOPIC_ID, T_SUBJECT FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID = " & Request.Querystring("TOPIC_ID"))
Edited by - Rasyr on 11 July 2002 13:14:03 |
|
|
|
Rasyr
Junior Member
USA
199 Posts |
Posted - 11 July 2002 : 13:12:23
|
quote:
Your topic title is a bit misleading, I thought you meant you couldn't view archive posts, when in fact you mean your active users link is broken.
why did you change it to remove the archive = true ?
how does it know to look in the archive table ?
Actually, the Active User stuff works fine, but this one snippet of code is breaking when you do a search, and include archived topics. Thus when you click on one of the links returned, you get the error message, posted in the other thread, when trying to view the archived topic.
I had installed all the security patches, and also the mod for the shorter links (as I have a lot of folks who post links to other threads, and to one another off the forums) and wanted to keep the link length down a bit.
In the other topic on this, I posted the entire Case Select block where the error is being generated. I figure that if I can get a SQL statement that will look at both tables, and combine the results, then I will be able to fix the rest of it on my own. But, I am not that good at SQL yet, so I am looking for help please...
**TANSTAAFL** |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 July 2002 : 14:13:56
|
Ok, one minute.
What page are you actually having a problem with, archives, active users or searching ?
You would get much further if you are a little more precise.
|
|
|
|
Rasyr
Junior Member
USA
199 Posts |
Posted - 11 July 2002 : 15:01:36
|
ok, I go to my forums http://dugger.dynu.com/iceforums
I go to Search, and I check the box for searching archives
I get the list of topics returned.
I click on any of the links to an archived topic and I get the error
thus I cannot read archived topics.
Hmm.... now that I explain it a little better, I guess that could look to find out where the code that returns the search results is, and have it hardcode the "archive=true" back into the urls somehow...
**TANSTAAFL** |
|
|
|
Rasyr
Junior Member
USA
199 Posts |
Posted - 11 July 2002 : 21:35:20
|
Any ideas?
**TANSTAAFL** |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 July 2002 : 21:39:39
|
you must have removed the code that did this, otherwis it would still work, so what did you remove.
|
|
|
|
Rasyr
Junior Member
USA
199 Posts |
Posted - 11 July 2002 : 23:46:08
|
nothing that I know of. I did a file compare of search.asp against one from an un-modded copy of the forums, and they were identical.
The same goes for the inc_activeusers.asp file. It is currently identical to the original.
The mods I have installed are as follows:
Poll
Hide Email
Flood Control
Admin_Moderator
Active Users
post2
and the security updates.....
Now, I also remember making the required changes to use the short urls, but I cannot rememebr what they were......
**TANSTAAFL** |
|
|
|
Rasyr
Junior Member
USA
199 Posts |
Posted - 12 July 2002 : 18:43:07
|
any ideas on how to rewrite that SQL statement?
**TANSTAAFL** |
|
|
|
Digger
Starting Member
USA
22 Posts |
Posted - 24 July 2002 : 03:44:11
|
I have got the exact same problem...word for word.
I have yet to find the reason for this error searching this forum and a few others that handle snitz boards......if you guys know the answer let us know!
Thanks for a great forum either way!!
|
|
|
|
Rasyr
Junior Member
USA
199 Posts |
Posted - 24 July 2002 : 08:08:13
|
Yes, please help! I still have not been able to figure out a resolution to this..
**TANSTAAFL** |
|
|
|
Rasyr
Junior Member
USA
199 Posts |
Posted - 10 August 2002 : 15:34:18
|
Has anybody figured out a solution for this? I am still having this error and cannot figure a way around it...
Please HELP!!! |
**TANSTAAFL** |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Rasyr
Junior Member
USA
199 Posts |
Posted - 10 August 2002 : 21:14:23
|
| 3.5 I think, at least that is what the Mods I downloaded says. |
**TANSTAAFL** |
|
|
|
Topic |
|
Topic Locked
