| Author |
 Topic  |
|
animedj
Junior Member
USA
190 Posts |
 Posted - 07 August 2000 : 17:53:27
|
hmm Are you sure it appears as <% categories %> ??? then that might be your problem because it should be <%= categories %>
|
 |
|
|
Lord Maverick
New Member
Norway
92 Posts |
Posted - 07 August 2000 : 20:18:09
|
Animedj,
I was using the right code - just did'nt type it right in my last post. I'm using <%= Categories %> and nothing shows for this value.
Looks like this variable does'nt have a value on my board. Strange...
|
|
|
|
nylemrak
Starting Member
USA
30 Posts |
Posted - 07 August 2000 : 21:11:54
|
error '80020009'
Exception occurred.
/forum/inc_functions.asp, line 538
got a clue what this error means? this only occurs when i change levels for users from regular to moderators after installing the statistics.asp
***********
kay bentain
Edited by - nylemrak on 07 August 2000 21:29:46
Edited by - nylemrak on 07 August 2000 21:39:26 |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 07 August 2000 : 21:29:52
|
Hey lord.. do you have this code in the statistics.asp file :
if strDBType = "access" then
strSQL = "SELECT count(FORUM_ID) AS [forums] "
else
strSQL = "SELECT count(FORUM_ID) forums "
end if
because if you do then it isn't <%= categories %> it should be <%= forums %>. Hope that helps. And Nylemrak, could you post line 535-540 from you inc_functions.asp file??
|
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 07 August 2000 : 21:33:31
|
ohh I know... I should have start adding version #s to the files. That was a bug that it had with only moderators, why.. I don't knwow.. anyways that is fixed so I would recommend you to d/l again the zip and install it again.
|
|
|
|
nylemrak
Starting Member
USA
30 Posts |
Posted - 07 August 2000 : 21:42:24
|
thanks i'm gonna try the new one
:)
***********
kay bentain
|
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 07 August 2000 : 22:07:24
|
Just downloaded and tested <img src=icon_smile_sad.gif border=0 align=middle>
(missing operator) in query expression 'FORUM_TOPICS.T_LAST_POST FORUM_FORUM.F_SUBJECT'.
/Windowsforums/statistics.asp, line 38
Did I miss something?
Thanks
Kal's Forums
http://vasserver.dyndns.org/Forums/default.asp |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 07 August 2000 : 22:13:13
|
I got the same error after reinstalling. I changed the code that <b>pier</b> mentioned in his post and it's working again. <b>pier's</b> post is back on page 1 of this topic.
|
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 07 August 2000 : 22:23:08
|
Sorry I thought I uploaded the fixed version to my server. Yep with the code from pier it should work as I forgot to add a <b>,</b> in the query after T_last_post. It shoul look like this:
strTablePrefix & "TOPICS.T_LAST_POST, " & _
|
|
|
|
Kal Corp
Average Member
USA
878 Posts |
|
|
Barry
Starting Member
13 Posts |
Posted - 08 August 2000 : 00:43:59
|
Hi,
I have installed the Statistics hack and am getting an error when editing ONLY the first message in a thread.
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/forum/post.asp, line 160
....which looks to be this code
if Request.QueryString("method") = "EditTopic" then
TxtMsg = rs("T_MESSAGE")
else
Can you help?
Thanks!
PS...I also had to alter the COLSPAN code so that it would show correctly in Netscape (IE is so much more forgiving!!!)...it was drawing an extra <td> that messed up the table.
Also animedj, I like the avatar hack and the extended profiles you have on your site...any chance of sharing the code on those?
Talk Soon,
Barry
|
|
|
|
Nathan L
New Member
USA
83 Posts |
Posted - 08 August 2000 : 02:25:14
|
Hmmm, not getting that error....
Response.Write ("The Reign of Nice") |
|
|
|
blkrogue
New Member
USA
79 Posts |
Posted - 08 August 2000 : 05:30:02
|
In order to make sure you can also add the stats maybe to the top of the page (just below the first table row and above the first category) you have to make sure you change the rs object used in the statistics.asp to a different name (either rsStats or something like that).
This way you aren't getting any conflicts with the rs objects used in the default.asp page.
Maybe it's an idea to change it to a different name all the same, just to prefend errors in the future animedj?
Blkrogue
In the darkness of my soul a sparkling light has appeared |
|
|
|
blkrogue
New Member
USA
79 Posts |
Posted - 08 August 2000 : 06:27:43
|
Oke, I have made some modifications to animedj's statistics.asp and to the default.asp. This way it also includes the 'You last visited - ' message and I have removed that line from the default.asp (and now have put the statistics box between the first table row and the first category.
You can download it at:
http://www.geocities.com/blkrogue99/forumhacks/newstats.zip
I haven't renamed the statistics.asp so back up animedj's one if you aren't sure you want this one, oke?
Blkrogue
In the darkness of my soul a sparkling light has appeared
Edited by - blkrogue on 08 August 2000 06:29:06 |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 08 August 2000 : 08:44:53
|
hmm, Barry I have checked and I can't get the error to work and it shouldn't be this hack related as it doesn't touch post.asp or inc_functions. what I would recommend maybe it's to restore inc_functions.asp from the original zip and see what happens. Also BlkRogue, there is no conflict in the rs object as where is located it's outside the rs.eof loop and so the rs is empty. The error I was able to trace it to inc_functions.asp when it does a level check and it gives a result for a moderator. why it messes up the variable users.. I can't quite figure that out yet...
|
|
|
|
Topic |
|
Topic Locked
