Author |
Topic |
Nathan
Help Moderator
USA
7664 Posts |
Posted - 04 January 2002 : 09:51:25
|
The problem seems to be with "rs.absolutepage" I dont know a thing about MySQL so. . .
Nathan Bales - Romans 15:13 --------------------------------- Snitz Exchange | Mod Resource |
|
|
GhettoDalaiLama
Junior Member
212 Posts |
Posted - 05 January 2002 : 05:51:36
|
Has anyone here gotten this to work under MySQL??
I would really like to fix this error.
Thanks.
------------------------- OS: Win2000 Adv Server SP2 Webserver: IIS 5.0 Snitz: 3.3.03 MySQL: 3.23.40 ODBC Driver: MySQL v.2.50.37.00 - 20.Apr.01 |
|
|
MDGamezz
Junior Member
USA
100 Posts |
Posted - 06 January 2002 : 22:24:34
|
Has anyone tried this on Huwr version of the forum?
MDGamezz |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 06 January 2002 : 23:31:31
|
Dont install it on HuwR's, it makes a mess.
Nathan Bales - Romans 15:13 --------------------------------- Snitz Exchange | Mod Resource |
|
|
GhettoDalaiLama
Junior Member
212 Posts |
Posted - 10 January 2002 : 21:44:45
|
Nathan... I found a fix!
I just comment'ed out line 153 on active_users and everything works great!
haha! easy fix |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 10 January 2002 : 21:47:03
|
Sounds good. I wonder what that line does. . . .
Nathan Bales - Romans 15:13 --------------------------------- Snitz Exchange | Mod Resource |
|
|
diver44
Starting Member
1 Posts |
Posted - 11 January 2002 : 14:58:56
|
I have an interesting thing happening when I install this mod. Everything seems okay at first (first few clicks in forum enviro) but then I will click on a link (say to see a User's profile for instance) and the browser never gets there. It just sits there loading nothing. Anyone else have this side effect? I uninstall the mod and all works great again...
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 11 January 2002 : 17:14:24
|
QUESTION: What/where should I edit the code on the profile page to make the default selection for "Show on active user panel?" equal to yes. I want yes to be the default not no. Thanks.
Shannon
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 11 January 2002 : 18:46:05
|
Yes should be the default for new users to sign up. Origionaly the mod was supposed to make all the uses already registerd equal to one as well, but it caused a problem so I had to set them all to "null."
Nathan Bales - Romans 15:13 --------------------------------- Snitz Exchange | Mod Resource |
|
|
AnimeMetro
Starting Member
6 Posts |
Posted - 13 January 2002 : 19:04:54
|
Hello,
Everything seems to work ok with this mod except for the admin control panel. It seems to be having problems with keeping the settings. Any clue as to why they might not be updating?
Thanks
|
|
|
nomad_2k
Junior Member
United Kingdom
173 Posts |
Posted - 13 January 2002 : 19:16:11
|
quote:
Sounds good. I wonder what that line does. . . .
It's to do with the paging system. If there are more than 15 active users, the first 15 are shown and a link to the next page containing the rest of the active users or the next 15 and so on. The problem is mySQL doesn't support absolutepage.
I've found the solution, download this updated version of active_user.asp here - http://www27.brinkster.com/nomad2k/sf2k/active_user.txt
look for the two sections marked '#### mySQL Fix
Edited by - nomad_2k on 13 January 2002 19:17:57 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 13 January 2002 : 19:19:47
|
Anime, sounds like you missed some lines in config.asp
Nomad, thanks for the fix. I will include it in the next update.
Nathan Bales - Romans 15:13 --------------------------------- Snitz Exchange | Mod Resource |
|
|
nomad_2k
Junior Member
United Kingdom
173 Posts |
Posted - 13 January 2002 : 22:16:21
|
Here's a solution to the long forum/topic names, the following code changes will only show the first 25 characters of a forum/topic name and add ... to show it's not the full title.
Add the following code to inc_functions.asp
Function TrimString(ByVal fString, ByRef fLen) If fLen < 1 Then fLen = 30 End If fString = Replace(fString, vbCrLf, "", 1, -1, vbTextCompare)
If Len(fString) > fLen Then fString = Left(fString, fLen)
Dim aString, iWord aString = Split(fString, " ", -1, vbTextCompare) fString = ""
For iWord = 0 To UBound(aString) - 1 fString = fString & " " & aString(iWord) Next
fString = Trim(fString) & " ..." End If
TrimString = fString End Function
Then open up inc_activeusers.asp and make the following changes:
Line 84 Change from: strOnlineLocation = strOnlineLocation & Forum_Subject to: strOnlineLocation = strOnlineLocation & TrimString(Forum_Subject, 25)
Line 101 Change from: strOnlineLocation = strOnlineLocation & Topic_Subject to: strOnlineLocation = strOnlineLocation & TrimString(Topic_Subject, 25)
Line 114 Change from: strOnlineLocation = "Replying To Message: <a href=""link.asp?TOPIC_ID=" & Request.QueryString("TOPIC_ID") & """>" & Request.QueryString("Topic_Title") to: strOnlineLocation = "Replying To Message: <a href=""link.asp?TOPIC_ID=" & Request.QueryString("TOPIC_ID") & """>" & TrimString(Request.QueryString("Topic_Title"), 25)
Line 121 Change from: strOnlineLocation = "Posting New Topic in: <a href=""link.asp?FORUM_ID=" & Request.QueryString("FORUM_ID") & """>" & Request.QueryString("Forum_Title") to: strOnlineLocation = "Posting New Topic in: <a href=""link.asp?FORUM_ID=" & Request.QueryString("FORUM_ID") & """>" & TrimString(Request.QueryString("Forum_Title"), 25)
I hope this is helpful and it all makes sense.
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 13 January 2002 : 22:32:20
|
Yeah, looks great.
Nathan Bales - Romans 15:13 --------------------------------- Snitz Exchange | Mod Resource |
|
|
Reddneck
Starting Member
Canada
7 Posts |
Posted - 14 January 2002 : 02:47:26
|
Hey Nathan. I have done all the changes to the .asp pages as your install guide outlined and it seems to be in there, except when I set the options in the Admin section....It defaults back to off every single time I change it.....Have you ever heard of such a problem? I have installed the mod twice now and still no luck....I would have posted some code to check, but I have no idea where to start looking.
Thank you in advance for your assistance.
Scott
|
|
|
Topic |
|