Print Page | Close Window

please help

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=5519
Printed Date: 03 April 2026 at 12:25am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: please help
Posted By: RUFreak
Subject: please help
Date Posted: 04 September 2003 at 10:25am

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




Replies:
Posted By: WebWiz-Bruce
Date Posted: 04 September 2003 at 10:52am

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.



-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: RUFreak
Date Posted: 04 September 2003 at 11:21am
Ive tried doing both but neither works. The Database is not in the same folder that the forum is in. I had to move it to our database folder so I tried to point the common.asp in the folders admin and the forum. Could this be a cause? I don't understand sorry


Posted By: WebWiz-Bruce
Date Posted: 04 September 2003 at 11:35am

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.



-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: RUFreak
Date Posted: 04 September 2003 at 12:01pm
Ok I don't think its a problem with the database only because I uploaded the empty database that came with the zip file and I still got the 

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.



Posted By: michael
Date Posted: 04 September 2003 at 12:18pm
It is not a problem with the database but your code trying to  query a database column that does not exist in the database. Did you install any mod that has an additional field or are you running a different version code then database?

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: RUFreak
Date Posted: 04 September 2003 at 12:56pm

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

 



Posted By: dead_angel
Date Posted: 04 September 2003 at 1:07pm
you say you had v6.34? did you migrate the database to version 7? or just upload the blank database? as there are extra tables in version 7 isn't there?


Posted By: WebWiz-Bruce
Date Posted: 04 September 2003 at 1:12pm
Try re-downloading the forum again and upload a clean install of the forum and see if that works, if it does then try your migrated database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: RUFreak
Date Posted: 04 September 2003 at 1:39pm

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.



Posted By: WebWiz-Bruce
Date Posted: 04 September 2003 at 1:45pm

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. 



-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: RUFreak
Date Posted: 04 September 2003 at 2:04pm
ok thanks lemme c


Posted By: RUFreak
Date Posted: 05 September 2003 at 9:44am

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



Posted By: b_bonnett
Date Posted: 05 September 2003 at 6:48pm

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



-------------
Webmaster, http://www.planegallery.net/ - The Plane Gallery
Greetings From Christchurch



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net