Im having some issues trying to get my forum to work.

I had the previous version 6.34 I think and I tried upgrading today and have been semi successful. What I havent been able to do is figure out why certain things under my admin menu are not working. I cannot set up my email notification and I cant administer any of the forums. I get error messages when I try

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forum/admin/forum_details.asp, line 163

I tried looking it up in help but that just confused me a little more.

I also cant make any new posts. I get this error

Microsoft JET Database Engine error '80040e21'

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

/forum/post_message.asp, line 749

The forum is located at http://www.yea.org/forum - www.yea.org/forum Thank you

Either you have corrupted files, reupload all the files again.

Or your database has become corrupted, download your access database, oepn in MS Access and select 'Compact and Reapair Database' from the tools menu, then reupload the database.

These are database errors suggesting problems with your database.

If you have used the migration tool to upgarde then tehse errors probally mean the process didn't go to plan, in which case do the migartion process again but make sure that you compact and repair the databases in access befire and after the migartion process.

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forum/admin/forum_details.asp, line 114

error when I tried to add any forums.

I was reuploading everything Im still having problems and I dont know what to do the only difference between what was in the zip folder now and what I put up there was the edited common.asp where I pointed it to the database in our database directory

End If

'Read in the forum details from the recordset
If NOT rsForum.EOF Then
 
 'Read in the forums from the recordset
 intCatID = CInt(rsForum("Cat_ID"))
 strForumName = rsForum("Forum_name")
 strForumDescription = rsForum("Forum_description")
 intForumID = CInt(rsForum("Forum_ID"))
 strForumPassword = rsForum("Password")
 intGuest = CInt(rsForum("Guest"))
 intStandard = CInt(rsForum("Standard"))
 intSuper = CInt(rsForum("Super"))
 intPower = CInt(rsForum("Power"))
End If

The error is being traced back to this part of the forum_details.asp...

I really have no idea whats wrong with it I guess Im not as good at asp as I thought I may have been. I tried redownloading it with no luck. I also still cant get to all of the admin features without errors.

The problem there is that the code is for version 6.34 not for version 7.

It looks like you have mixed up some of the old forum files with the new forum files.

Redownload version 7.01 from this web site and upload all the files again, making sure you have also uploaded all the new files in the admin section. 

Ok new problem sort of I can set permissions and all of that stuff but now I cant make any posts without getting the microsoft jet error

Microsoft JET Database Engine error '80040e21'

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

/forum/post_message.asp, line 749

I tried downloading the database and doing the repair/compact to no avail. Any other ideas?

Steve

When you convert the database, you need to do a Compact and Repair both before AND after converting it. Not doing so is usually the cause of this problem, so hopefully reconverting it and ensuring you do should fix it.

Blair