Author |
Topic Search Topic Options
|
kbannon
Groupie
Joined: 03 October 2002
Location: Ireland
Status: Offline
Points: 115
|
Post Options
Thanks(0)
Quote Reply
Topic: Active Topics not showing (again) Posted: 02 January 2005 at 4:40pm |
in the last 24 hours my sites active topics page is not loading if anything less than 'yesterday' is chosen (co-incidentally new years day!).
I know about setting the LCID which on mine is set to 2057 (UK) as the servers default is 1033 (USA). However, it has been running fine for several months now and just went belly up yesterday sometime. Any ideas?
|
I don't suffer from insanity, I enjoy every minute of it.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 January 2005 at 5:46am |
One solution is on the active topics page at the top of the file is to change the LCID back to that of the server.
I have to do the same thing on this site to get the active topics to run.
|
|
|
kbannon
Groupie
Joined: 03 October 2002
Location: Ireland
Status: Offline
Points: 115
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 January 2005 at 3:59pm |
changed it back to 1033 and still no joy.
Also when I try running it from the backup asp files on my pc (via http://localhost) which gets the threads etc. from a MS SQL database, the same problem exists indicating a database problem (possibly with the active topics stored procedure).
|
I don't suffer from insanity, I enjoy every minute of it.
|
|
kbannon
Groupie
Joined: 03 October 2002
Location: Ireland
Status: Offline
Points: 115
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 January 2005 at 4:38am |
Had a look at the database - the active topics procedure looks OK. Im stumped!
CREATE PROCEDURE [dbo].[wwfSpActiveTopics] ( @AuthorID int, @GroupID int, @GroupPerm int, @dblActiveFrom datetime ) AS SELECT tblForum.Forum_name, tblForum.Password, tblForum.Forum_code, tblTopic.* FROM tblCategory, tblForum, tblTopic WHERE ((tblCategory.Cat_ID = tblForum.Cat_ID AND tblForum.Forum_ID = tblTopic.Forum_ID) AND (tblTopic.Last_entry_date > GetDate() - @dblActiveFrom)) AND (tblForum.[Read] <= @GroupPerm OR (tblTopic.Forum_ID IN ( SELECT tblPermissions.Forum_ID FROM tblPermissions WHERE tblPermissions.Author_ID = @AuthorID OR tblPermissions.Group_ID = @GroupID AND tblPermissions.[Read]=1)) ) ORDER BY tblCategory.Cat_order ASC, tblForum.Forum_Order ASC, tblTopic.Last_entry_date DESC;
|
I don't suffer from insanity, I enjoy every minute of it.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 January 2005 at 4:50am |
|
|
|
kbannon
Groupie
Joined: 03 October 2002
Location: Ireland
Status: Offline
Points: 115
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 January 2005 at 5:31am |
Sorted using that mod - thanks boRg.
Very strange how it decided to suddenly not work as there were no code/database or web server modifications at the time.
|
I don't suffer from insanity, I enjoy every minute of it.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 January 2005 at 5:53am |
I've started working on a new system for version 8 that changes the way
dates etc. are stored in cookies and used in pages like the active
topics page, so hopefully it will eleminate the CDate error on all
servers.
|
|
|