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!

'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????

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)

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 http://www.tixe.com.ar - 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 http://www.tixe.com.ar/forum2/ - 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 )

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?

So has anyone not been able to see anything under the active topics section of their forums?

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.

But the thing is I never changed the LCID. It is still commented out like it was in the downloaded pack. Do I need to uncomment it?

You need to open the active users file, uncomment the LCID line, placing in the locale ID number for where your server is hosted:-

eg:-

UK:- 2057
US:- 1033

If your server is in the UK, which I think it is set it to 2057 in teh active users file.

Thanx for trying to assist me boRg but for some reason I still can't get it to work. I tried the uncomment of the LCID line in active_topics.asp and used 2057 for the UK since that's where my host server is but still no go.

It's just weird how it worked when i first installed V7.0 then last night I noticed it wasn't working. I also created another forum with V7.0 and it seems to be working. Did nothing different. Just plain weird!

It could be some corruption in the database, try downloading the database and compacting and repairing it in access (it's under the tools menu)

Also make sure that there is nothing in any edited header files that could course problems.

Whait whait ...

I tested comment into the file common.asp the line about LCID ( or rem as your like ). And nothing pass, I comment the some line into the active_topics.asp and the some thing, nothing pass.

I configured into the common.asp and active_topics.asp LCID session for Argentina ( my server is on this place and the regional options are configured to Sapnish Argentina ), and the some thing nothing pass, and all this test, I maked on ../furum2/ that this forum is a plain files as it on the download file from here.

Now .. Mr.  -boRg- do you know why happen it ?? Becose really I dont know

Ok ok .. right .. I tested this.

If I use the original data base that come whit the .zip file .. the active topics work good .. but if a use the migration tool from WWF 6.x to 7.0 is when start the problem.

Is posible that the problem start when one´s migrate old forum to new forum ??. becose really I don´t kwno what think

Doesn't work, I put LCID for the start, doesn't work! It worked a day, the day after not anymore.

I said It didn't work either with the version 6. NEVER! It's not question of database or migration, the filters are the problem. I don't know how it sould be... In a server it works, in another server (of the same host) doesn't work.

Can you find another solution for this filters???

I was start to re configure the forums access right´s ( on my migration the access rights does not transfer .. I don´t know why )

Re configure all access rights on my forum and re sync´the posts, and of one moment to other .. start to run good .. it is very crazy but is true ..

Hey tixe your right. I went to the administrator menu and under the http://www.hawaiiforums.net/HawaiiRiders/admin/view_forums.asp - Forum Administration  menu I didn't change any of my permissions but just hit submit and then re sync forum and boom, FiXeD!

Thanxs!!!!!

i have also this problem when i used the migration tool

i think this is the problem.

it says there that he changes from 634 to 7

and my old forum was 630

can it be the problem ?

I don't think it is the migrator tool because I used it and when I first checked the new forum the active topics worked. It was when I went into the group permissions or something that the active topics stopped working. But look at the following:

The way I did it was just create a new forum category call it Test or something. Then move all your forum topics into the Test catagory. After all are moved in the Test category then re-sync the forum in the admin menu. Now after that put all your forum topics back into their normal categories and re-sync again. Then the active topics will work. Don't know why, but it WORKS!

well i did as you said and it realy works...

i mean presing the submit at the administrator tool

but i have an other problem.

he gives me an eror when i'm sending a new post or reply.

he gets the data  to the accses but stil he gives an eror

what can i do ?

sorry about my english...

nothing.....

barmdbarmd

Are you saying that the  posting problem error you get occurs in the active topics listing? I don't quite understand what type of error you are getting. Sounds like something unassociated with the active topics problem that had been occuring.

Explain more if you could.

hi

its another problem.

i have no problem more with the active topics

but when i send a message i'm getting an eror.

its the 500. an Internal server error

I have do all you have said in all messages and my forum continues without tell active topic... i'm desesperate!!!! what can i do?

I have download de database and compact and repair, i have do the re-sync by all the ways...

Help, please

I'm from Spain, sorry for the English

P.D.- i have put the LCID in common and active into my country, where the server is place.

I have 3 different forums running on my site and I have noticed that on each forum after I used the migration tool and then got the forum up and running the active topics would not work.

To get it to work I had to go into the admin menu and move the forums from one Forum Category into another, Re-sync the forum Then move it back to the Forum Category I really want it in and Re-Sync the forum again.

So that's at least two Re-Sync's you must do.

Other than that, I don't know what to tell you RaToNaCo, but this should work!

Oh and the LCID I had tried before, but it didn't make the active topics work. My suggestion is to leave the LCID commented out.

808Rider wrote: So that's at least two Re-Sync's you must do.

I made not two, but 5,10 re-sync. NOTHING TO DO! active topics doesn't work. I have always the same errors I wrote in the first message. This damned filters!!!

Another thing: when i used the migration tool, didn't work. In the new db there is Guest registred and all the members are slided of one, so, once I tried to put a post, I had an error of duplicating some dates. I  must do everything manually (copying members and messages one by one). The migration doesn't matter. I don't know what matters, because the other forum with the same files it works (same LCID, same servers......)

808Rider wrote: Hey tixe your right. I went to the administrator menu and under the http://www.hawaiiforums.net/HawaiiRiders/admin/view_forums.asp - Forum Administration  menu I didn't change any of my permissions but just hit submit and then re sync forum and boom, FiXeD! Thanxs!!!!!

Ok I´m So happy for you

When a Recordset is filtered based on a field of some variant type (e.g., sql_variant), an error (DISP_E_TYPEMISMATCH or 80020005) will result if the subtypes of the field and filter values used in the criteria string do not match. For example, if a Recordset object (rs) contains a column (C) of the sql_variant type and a field of this column has been assigned a value of 1 of the I4 type, setting the criteria string of rs.Filter = "C='A'" on the field will produce the error at run time. However, rs.Filter = "C=2" applied on the same field will not produce any error although the field will be filtered out of the current record set.

See the http://msdn.microsoft.com/library/en-us/ado270/htm/mdapro01_8.asp - Bookmark property for an explanation of bookmark values from which you can build an array to use with the Filter property.

Only Filters in the form of Criteria Strings (e.g. OrderDate > '12/31/1999') affect the contents of a persisted Recordset. Filters created with an Array of Bookmarks or using a value from the FilterGroupEnum will not affect the contents of the persisted Recordset. These rules apply to Recordsets created with either client-side or server-side cursors.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdapro03_10.asp - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdapro03_10.asp

no database problem.......

Hey borg,

If permissions are set on the forum so guests can view then when members are logged in the Active Topics page doesnt worl because of the "tblForum.[Read] = 1" statment. Maybe that should be changed so members with access can view the active topics?

I run V7.01 SQL and have the same problem.

nothing in the active topics page.

I have tried all the fixes I can and it still doesnt work.

my forum is set so that guests cant view anything, they have to be registered.

I hope this is the same issue maddog is talkign about. Fingers crossed we can work out a fix for this problem. Glad I'm not alone on this lol.

Keep up the great work guys!

Kev

"tblForum.[Read] = 1"

I don't understand you MadDog... but i hope you encounter the solution...

any more updates on this?

I read earlier that borg had posted soemthing like "maybe this just doesnt work on your server"

fair answer but when I had 6.34 it always worked fine.

does anyone know how the two differ?

Do we think there will ever be a solution to this?

There is a difference between the Access and the MSSQL version of the query, which might explain why the MSSQL version doesn't work.

With Access the read permissions are checked with "tblForum.[read] = True" and with MSSQL with "tblForum.[read] = 1"

I could be mistaken but shouldn't the latter be "tblForum.[read] = True" or "tblForum.read = 1"

I was running 6.34 on SQL too so no difference there :)

I will be eternally greatful if someone can make it work!!

PrimeraRacer wrote: I was running 6.34 on SQL too so no difference there :)

It's a bit unclear to me, did it work in 6.34 or not? Since in 6.34 there is no different query for MSSQL the problem shouldn't occur there.

Btw. because I don't have SQL server I can't check what I'm saying here

it worked fine on 6.34 on SQL

then I installed V 7.01 (fresh install) on SQL

doesnt work.

I was thinking the code would be the same too. its just that it seems lots of people have the same problem maybe there was actually a problem somewhere, or at least a work around!

Cheers

Kev

Bump!!

anyone had any joy in fixing it yet?

I take it that noone has or is going to fix it lol.

can anyone at least tell me the procedure it uses to display the active topics so I can go about trying to fix it myself!!

Cheers

Kev

I used 6.34 (access 2000) for awhile and loved it. I just upgraded to SQL 7.1 with a new clean database, spent 2 days building 33 forums with 8 User groups, set permissions for each and NOW I find that the Active Topics does not work and it seems that no one can fix it.

I have read every post I can find on this subject (about 2 hours worth of reading), and done everything suggested. The only thing I can do is call my web host and have them check their LCID setting. If that does not work, has there been new developments on this issue?

Check the LCID number with your host and change it in the active_topics.asp file.

I have to do this on this site to get it to work on this server also.

My web host does not have a LCID setting. They do have a time zone setting which is set correctly.

We have isolated the problem to be within the code.

When a forum is set to All user access, the active topics works perfectly. When the forum is set to private groups it does not, since it works with one forum setting, it can be concluded that the server is set correctly.

This is a problem with the Forum itself.

I will have to hack out the active topic option.    

OK, I have setup an access version and the active topics works fine. I need advice. My forum is not a heavily used forum. Maybe a few hundred members with only 50 or so that post on any regular basis. What are the advantages of SQL over Access? Should I use the access version to use active topics or will I regret it later. I have the SQL version all ready to go.

Access was created as a desktop flat file database system and never intended as a web backend.

SQL Server is much faster and more scalable and can be used for databases on almost any size and no limit on the number of connections.

If you have SQL server available use that.

Also to correct your host all windows servers when being installed have to be set to a locale so there would be an LCID number for that locale.

I think I have this problem defined.

Any forum which is viewable to guest works in the active topic display. Any forum restricted to viewing by groups only, does not work. I think I remember reading somewhere that this issue is just the way it is. Correct?

My web host has his settings correct.

Question: If the mod that puts the latest post at the bottom of the page can sort recent post and filter viewing by group permission can function properly, why can't the active_topic.asp page?

Is this a problem that we can except to be solved in the future?

I know "What do want for FREE"

I will be donating tonight, because with all the mods and support from this site, I still think this is the best option for our group.

Thank you all for the mods. I think I have used them all.

IT WORKS!!!!!!

I think I read about this somewhere but it did not sink in, so I will say it for anyone who did what I did. YES, what I did to prevent active topics from working correctly.

Our forum is private, so I sent all forums (37 in all) with a default access setting to Private Groups only for everything.

Then I created groups and gave each group access as they are allowed. I did not create a "guest" permission group because the default forum settings would block their access.

It also blocks the active topics from working.

I set the default forum access controls to "All Users" for the forum access control. All the rest stayed at "group permission". I then created a group permission for "guest" in each forum, leaving all access options blank.

Funny I did not figure this out until after I Donated, 

Now I need to search again and see if I can stop guest from seeing the topic titles in active topic views. If not, I can live with it.

My webhost never did find a LCID setting. He has a locale setting which is set to United States, but the 1033 number is not shown in  the GUI.

Here is great link that will help.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iisref/htm/SettingtheLocaleIdentifierLCID.asp - http://msdn.microsoft.com/library/default.asp?url=/library/e n-us/iisref/htm/SettingtheLocaleIdentifierLCID.asp