Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 jump to last post help...
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

RichLondoner
Starting Member

United Kingdom
43 Posts

Posted - 27 January 2004 :  10:49:59  Show Profile  Visit RichLondoner's Homepage
All, I've just noticed that the Jump to Last Post (Blue Arrow) isn't working properly...

It will work on Topics which are only 1 page long.
It will not work on Topics which are more than 1 page long.

When it fails to work it just goes to the top of the first page of the Topic which isn't jumping to the last post...

Just noticed that it isn't working from the front page as well in the Statistics section.

I can't remember changing anything recently, although saying that I may have at an earlier date and not noticed as my boards are quite new and only have a few multipage topics...

Any ideas?

Richard Mills
http://www.mysector.co.uk

Edited by - ruirib on 28 January 2004 05:39:22

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 27 January 2004 :  11:01:16  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
What Snitz version are you using?
Can you post a link to your forum or post the URL that is being displayed in the browser status bar when you hover the last post link?

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

RichLondoner
Starting Member

United Kingdom
43 Posts

Posted - 27 January 2004 :  11:20:48  Show Profile  Visit RichLondoner's Homepage
Latest version of snitz, on MS SQL... Intranet site so can't post link...

topic.asp?whichpage=-1&TOPIC_ID=49&REPLY_ID=366

Which should jump to the last post on a 3 page topic

Richard Mills
http://www.mysector.co.uk
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 27 January 2004 :  11:31:29  Show Profile  Send ruirib a Yahoo! Message
Make sure your site has the an MDAC later than 2.5 to have Jump To Last Post working.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

RichLondoner
Starting Member

United Kingdom
43 Posts

Posted - 27 January 2004 :  11:40:13  Show Profile  Visit RichLondoner's Homepage
I'm not sure about that, i'll have to speak to our network manager... Any other way you can find out what version it is? It's not in the server info in admin options that I can see...
Mind you if it works for 1 page topics, shouldn't it work for multipage topics?

Richard Mills
http://www.mysector.co.uk
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 27 January 2004 :  12:45:15  Show Profile  Send ruirib a Yahoo! Message
Check the value of OLEDB Version variable in Admin Options -> Server Information.

1 page topics are handled differently, because of a fall back condition in the code, if the code that finds the page where the reply is located fails.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

RichLondoner
Starting Member

United Kingdom
43 Posts

Posted - 28 January 2004 :  04:11:18  Show Profile  Visit RichLondoner's Homepage
OLE DB Version 02.00 according to Server Info, is that good or bad?

Richard Mills
http://www.mysector.co.uk
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 January 2004 :  05:38:59  Show Profile  Send ruirib a Yahoo! Message
Should be 2.5 or later, I think. You need to talk to your host about that. Ask them to install the latest MDAC from http://www.microsoft.com/data


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

i011877
Junior Member

Denmark
169 Posts

Posted - 28 January 2004 :  19:45:19  Show Profile  Visit i011877's Homepage
I installed the MDAC 2.8, restarted the server and checked...still 2.0 on the ODBC.
-and it still doesn't work to jump to the last post, if more than 1 page.


Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 January 2004 :  19:48:19  Show Profile  Send ruirib a Yahoo! Message
Are you using an OLEDB connection string? If you aren't you should.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

i011877
Junior Member

Denmark
169 Posts

Posted - 28 January 2004 :  20:02:00  Show Profile  Visit i011877's Homepage
Weeeeee....! It works now.
ODBC V2.7

I am a happy man


Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 January 2004 :  20:20:05  Show Profile  Send ruirib a Yahoo! Message
Good :).


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 22 June 2004 :  15:00:20  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Just incase anyone else is having this problem I was having the same thing and I installed 2.8 and everything started working just as a FYI that 2.8 also works.

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

aspwiz
Junior Member

250 Posts

Posted - 20 August 2004 :  06:57:58  Show Profile  Visit aspwiz's Homepage
Help!
My jump to last post icon is not working period. Doesnt matter if topic has one page, or ten, you still get redirected default.asp regardless.

This info is taken from the server info page in admin options:-
Provider Name sqloledb.dll
Provider Friendly Name Microsoft OLE DB Provider for SQL Server
OLE DB Version 02.70
Provider Version 08.10.9042


Any ideas?

Edited by - aspwiz on 20 August 2004 06:58:49
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 August 2004 :  08:09:14  Show Profile  Send ruirib a Yahoo! Message
Well ask your host to install MDAC 2.8. With SQL Server, however, I've seen circunstances where it has been impossible to fix it. Can't understand why, but happens.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

aspwiz
Junior Member

250 Posts

Posted - 21 August 2004 :  09:10:52  Show Profile  Visit aspwiz's Homepage
Ruirib .... I dont think this is an MDAC issue....
it is not going to the first post like the other issue mentioned above... the topic is not displayed at all... it just redirects to the home page.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07