| Author |
 Topic  |
|
trazman
New Member
Sweden
79 Posts |
 Posted - 12 August 2002 : 13:18:04
|
Ok. It seems as you are close to a solution...
/Roger |
 |
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 12 August 2002 : 13:47:19
|
Ok. Now it works with no reply
Something strange is happing when I reply topic.
Instead of see one reply I see 15 replies
Yes its on a windows 2000 machine and thats why i need to use a DSN. My host is www.space2u.com
and I have spoken with them (good guis) several times about this problem. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 August 2002 : 13:59:23
|
Yeah, I've been at your forum and I've seen it. That completely puzzles me. I can only suspect that something is wrong with either the drivers or Chili itself. I have the exact same code running in my Windows test site and it works perfectly OK. This is so weird.
Can I have FTP access to your site, so that I can try to figure out why that happens? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 12 August 2002 : 14:03:59
|
Why can I see the replies under the message box
when I click on "reply to topic"?
There are the replies only one at a time.
/Roger |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 12 August 2002 : 15:34:16
|
I have sent a mail to you with my ftp account.
/Roger |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 August 2002 : 20:49:39
|
Roger,
I think that is fixed now. I've uploaded a new topic.zip to my site, but your site is already fixed and working.
I'd also like to point out that I got a remarkable help from another Snitzer, Nikkol, who gave that final precious little hint that got it working, besides standing beside me on MSN, while I tried several solutions to the problem.
I think members.asp will need a similar change. Do you feel up to it? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 August 2002 : 23:27:22
|
Well, after having all this work, Sun One's support informed me that since the recordset being paged uses memo fields, it needs to be opened as a forward only recordset. I did that and added a movefirst before recordset navigation and that did fix the problem.
This second movefirst is necessary. Don't know if the first (already existing before my changes) is also necessary and I can't test it because I cannot change page size to make sure paging will work without it.
Ok, so here are the changes to a normal topic.asp to have it working:
1. change line 273 from
rsReplies.open strSql, my_Conn, 3
to
rsReplies.open strSql, my_Conn, 0
2. before line 359, add the green line:
rsReplies.MoveFirst
do until rsReplies.EOF or (mypage = 1 and rec > CInt(strPageSize)) or (mypage > 1 and rec > CInt(strPageSize)) '**
This should fix a normal topic.asp.
Roger, your forum already has this fix.
I just wish SUN One had our response times. I would have spared myself a few ours work on this...
Oh well, never mind, it was fun "inventing" my own SQL only paging strategy 
Roger, I guess this makes it easier to fix members.asp, huh? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 13 August 2002 : 04:00:28
|
Thanks for all the time that you spent on hacking snitz. Is this good stuff that you can implement
in version 4? And thanks to you to Nikkol donīt like the penguin
? hope you can sleep at nights without dreaming about jumping penguins.
Ruirib I understand that you uploaded the topic.asp but do I need to do some changes to
Members.asp, line 273 and 359?
And again THANKS for all the help
With regards
Roger
|
|
|
|
jynne
Starting Member
Sweden
10 Posts |
Posted - 13 August 2002 : 04:18:06
|
Back from vacation I must say that I am impressed by your work! It works perfectly fine in our forum to (using the same ISP as Roger).
Thanks all!!
/Jynne |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 13 August 2002 : 06:45:50
|
Roger in members.asp the changes are in different lines.
1. The first change should be on line 235:
rs.open strSql, my_conn, 3 0
2. The insertion of the other line should occur before line 354:
rs.MoveFirst
do until rs.Eof or rec = (strPageSize + 1)
I haven't tested this one. You'll only be able to test it when you have enough members to have more pages, or you can just temporarily change the page size at the Features Configuration in Admin Options.
Let me know how it goes.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 13 August 2002 : 06:47:10
|
quote:
Originally posted by jynne
Back from vacation I must say that I am impressed by your work! It works perfectly fine in our forum to (using the same ISP as Roger).
Thanks all!!
/Jynne
Jynne,
Glad it's working. Be sure to add the changes to members.asp too. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 21 August 2002 : 05:51:11
|
ruirib.. do you think that I can get some trouble if I upgrade to 3.4
or am I lost with this version 3.3.5 forever
I understand that I canīt replays topic.asp and members.asp from 3.3.5
To 3.4...right? Can I upload the forum and test it with the same database(mdb)
Or do I have to upgrade that one to?
With regards
Roger
|
|
|
|
Topic |
|
Topic Locked
