| Author |
 Topic Search  Topic Options
|
andrada 
Newbie
Joined: 23 April 2003
Location: Italy
Status: Offline
Points: 11
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Problem with active topics
Posted: 23 April 2003 at 3:24pm |
Hello!
I have 2 forums in two sites. One of this works good, but the other has problems with Active Topics.
I have this error:
Provider error '80020005'
Type mismatch.
/forum/active_topics.asp, line 276 (286 etc..)
If I search active topics from "yesterday" an so on it works..... I don't know why, in the other forum everything works....
Can somebodey help me?
Thanks!
|
 |
andrada
Newbie
Joined: 23 April 2003
Location: Italy
Status: Offline
Points: 11
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 April 2003 at 6:04pm |
'Initialse the string to display when active topics are shown since
Select Case intShowTopicsFrom
Case 1
'Filter the recorset to leave only active topics since last vists (Filter used for overcome incompatibilty problems between application and database)
rsForum.Filter = "Last_entry_date > #" & CDate(Session("dtmLastVisit")) & "#"
case 2
rsForum.Filter = "Last_entry_date > #" & DateAdd("n", 15, Now()) & "#"
case 3
rsForum.Filter = "Last_entry_date > #" & DateAdd("n", -30, Now()) & "#"
Case 4
rsForum.Filter = "Last_entry_date > #" & DateAdd("n", -45, Now()) & "#"
Case 5
rsForum.Filter = "Last_entry_date > #" & DateAdd("h", -1, Now()) & "#"
Case 6
rsForum.Filter = "Last_entry_date > #" & DateAdd("h", -2, Now()) & "#"
Case 7
rsForum.Filter = "Last_entry_date > #" & DateAdd("h", -4, Now()) & "#"
Case 8
rsForum.Filter = "Last_entry_date > #" & DateAdd("h", -6, Now()) & "#"
Case 9
rsForum.Filter = "Last_entry_date > #" & DateAdd("h", -8, Now()) & "#"
Case 10
rsForum.Filter = "Last_entry_date > #" & DateAdd("h", -12, Now()) & "#"
Case 11
rsForum.Filter = "Last_entry_date > #" & DateAdd("h", -16, Now()) & "#"
End Select
Nobody has an idea????
Edited by andrada
|
|
jabbasabba
Groupie
Joined: 11 April 2003
Location: Sweden
Status: Offline
Points: 103
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 April 2003 at 6:20pm |
|
What is your version of WWF?
|
|
andrada
Newbie
Joined: 23 April 2003
Location: Italy
Status: Offline
Points: 11
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 April 2003 at 3:51pm |
The last one..
But it didn't work with any version...... yesterday I installed the latest one and it worked, but tonight not anymore.....
(I didn't receive the notification of the replay )
|
|
tixe
Groupie
Joined: 19 July 2002
Location: Argentina
Status: Offline
Points: 76
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 April 2003 at 6:19pm |
I have the some problem .. but my problem is that, when I go to active topics, the forum not show nothing, ( I posted a new topic )
and it the some problem whit any user that i can be loged
Some one know why I have this problem ??
If you like try .. go to www.tixe.com.ar and use the user=test pass= test, try to post a new mesage and then go to active topic.
So sorry the above address ... is on spanish the forum, to can see it on english please use www.tixe.com.ar/forum2/
And ( sorry against I editing my own topic to many times ) the forum on forum2 is the plain files as it when ones dowload from here. ( no the database, it migrated from WWF 6.x )
Edited by tixe
|
|
|
|
808Rider
Senior Member
Vebro Solutions CEO http://www.vebro.net
Joined: 20 April 2003
Status: Offline
Points: 405
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 April 2003 at 9:59pm |
I think I am experiencing the same problem as stated above. When I go to active topics, the forum does not show anything. I have tried the LCID thing that Borg said and still no go.
Anyone have any ideas as to why this is not working?
|
|
|
|
808Rider
Senior Member
Vebro Solutions CEO http://www.vebro.net
Joined: 20 April 2003
Status: Offline
Points: 405
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 April 2003 at 12:26am |
So has anyone not been able to see anything under the active topics section of their forums?
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 April 2003 at 2:47am |
If you have changed the LCID for your forum in the common.asp or for your site somewhere, you need to change this back to your servers own LCID number for the active topics page.
I have to do this for this site, in the common.asp file I set the LCID to UK, but as this server is in the US I have to set the LCID back to the US locale in the active topics page inorder to get it to work correctly. Otherwise the server can't acurately calulate the date and times correctly.
|
|
|
|
