| Author |
 Topic  |
|
|
Anders M
Junior Member
Sweden
117 Posts |
 Posted - 21 March 2001 : 09:40:51
|
Hi all,
When I look at a topic (topic.asp), I don't see the first reply to the topic. The other replies are shown okay.
However, when I reply to the topic (post.asp), the first reply, as well as all the other replies, are shown in the Topic Review.
Anyone had this problem before?
I run Snitz 3.1sr4 on a Linux server with Chili!Asp, while the access database is located on an NT server. I had to remove all .cachesize= in the code, since it doesn't work with Chili!Asp.
Regards,
-Anders M
Edited by - Anders M on 21 March 2001 10:51:49 |
|
|
Anders M
Junior Member
Sweden
117 Posts |
Posted - 21 March 2001 : 15:40:03
|
Hi again,
I removed rs.absolutepage at line 290 in topic.asp. Now I see all replies, no problem!
Why? What's the problem with rs.absolutepage?
This seems to be an issue with ChiliAsp only, I've had no problems on pure Microsoft platforms.
-Anders M
|
 |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 21 March 2001 : 16:10:46
|
Anders,
First of all: not that we don't want to, but Access in combination with Chili!Asp isn't supported yet !
Main reason for that: we can't test it ourselves, so it is hard to make sure that it works.
I'm afraid that removing the rs.absolutepage isn't really going to fix anything.
Because without it, the paging in topic.asp probably won't work.
Try this by setting the number of topics per page (you'll find it in the Admin Options) to say 5 and make sure you've got 6 or more replies to the same topic. You should see pagenumbers 1 and 2. But without the rs.absolutepage when you click on page 2, you should still see the same as on page 1.
According to the Chili!Asp documentation it should support the .absolutepage property, but it might have problems with interpreting the mypage value.
Could you tryrs.absolutepage = CInt(mypage) instead of rs.absolutepage = mypage
Or Otherwise: rs.AbsolutePage = CInt(mypage)
Pierre |
|
|
|
Anders M
Junior Member
Sweden
117 Posts |
Posted - 22 March 2001 : 15:10:48
|
gor,
Thanks for the suggestions.
I'm aware that removing rs.absolutepage won't solve the problem when I have long threads, so I set the number of topics per page to a large number (temporary solves the problem).
I tried
rs.AbsolutePage = CInt(mypage)
but it didn't help. I put some trace lines in the code, and checked the return value of
rs.AbsolutePage
just after I set it to CInt(mypage). It returns -3. I checked CInt(mypage), and it is 1 allright. Weird! I found an interesting posting in the ChiliSoft support forum. That posting indicates exactly the same problem. I don't know what to do next. Speak with ChiliSoft maybe?
I'll get back when I know more.
-Anders M
P.S.
Is this the right forum for discussing ChiliSoft problems, or is there another more suitable forum here at Snitz? I have more problems than this one...
Edited by - Anders M on 22 March 2001 15:17:19 |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 22 March 2001 : 15:59:30
|
Anders,
I read the topic, and that is really bad news, because that would mean the only thing that can be done is hope that ChiliSoft releases a fix for this.
There wasn't any reply posted to the topic yet, so no workaround/fix yet there.
We don't have a ChiliSoft forum yet, officially we only support ChiliSoft + MySql and for that we have the MySql forum.
But you can always post the questions in the Help: General forums.
They'll be answered there anyway. This forum (the BUG forum) is for BUGS in the Snitz Forums code only.
Pierre |
|
|
|
Anders M
Junior Member
Sweden
117 Posts |
Posted - 09 May 2001 : 12:32:58
|
Just for information: Now it works!
I reported to my ISP that I had problems with rs.absolutepage. Maybe they fixed something, because now it works. I think thay have upgraded ChiliAsp to a later version, but I'm not really sure.
Another thing is that I have changed from Access to MySql. Maybe this has something to do with it?
Anyway, I am very happy with the combination Linux/ChiliAsp/MySql 
-Anders M
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 09 May 2001 : 13:18:09
|
So no things we can or should change in the code then ?
Would you mind asking your ISP what they changed ?
Pierre
Join the Snitz WebRing |
|
|
|
Anders M
Junior Member
Sweden
117 Posts |
Posted - 09 May 2001 : 19:08:13
|
quote:
So no things we can or should change in the code then ?
Not regarding rs.absolutepage (but I had to remove rs.cachesize).
quote:
Would you mind asking your ISP what they changed ?
Ok, I will investigate the matter. I will also try again with Access to see if that was the problem. Then maybe we can instruct others how to fix the problem with rs.absolutepage.
-Anders M
|
|
|
|
Anders M
Junior Member
Sweden
117 Posts |
Posted - 14 May 2001 : 17:06:37
|
Now I have tried ChiliAsp with both databases. rs.absolutepage works with MySql, but not with Access. So my ISP didn't solve it. MySql did it.
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 15 May 2001 : 02:05:17
|
quote:
Now I have tried ChiliAsp with both databases. rs.absolutepage works with MySql, but not with Access. So my ISP didn't solve it. MySql did it.
One last question: what version of MySql are they using ?
(since MySql is updated a lot, it is nice to know what version you at least know to be sure it works).
Thank you
Pierre
Join the Snitz WebRing |
|
|
|
Anders M
Junior Member
Sweden
117 Posts |
Posted - 16 May 2001 : 12:34:12
|
quote:
One last question: what version of MySql are they using ?
(since MySql is updated a lot, it is nice to know what version you at least know to be sure it works).
Right now my forum is running on ChiliAsp 3.6.0 and MySQL 3.23.37. Works fine.
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
|
| |
Topic |
|
Forum Locked
Topic Locked
