Problem with Database

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=24037
Printed Date: 06 April 2026 at 10:20am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Problem with Database

Posted By: WebmasterFF
Subject: Problem with Database
Date Posted: 02 August 2007 at 1:35pm

I upgraded the forum (version 8 to version to version 9) and am now having problems with it.

Although the forum looks ok, I can't look at another member's profile without an error "http 500" page appearing. It says:

"Most likely causes:

The website is under maintenance.
The website has a programming error"

any ideas?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 02 August 2007 at 1:38pm

First you need to:-

http://www.webwiz.net/kb/asp_knowledgebase/friendly_HTTP_error_messages.asp - How to Turn Off Friendly HTTP Error Messages in Internet Explorer

Then you need to post what the error is, this will tell what is wrong.

-------------
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: WebmasterFF
Date Posted: 02 August 2007 at 1:41pm

ADODB.Recordset error '800a0cc1'

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

/forum/member_profile.asp, line 174

Posted By: WebWiz-Bruce
Date Posted: 02 August 2007 at 1:47pm

There is no obvious reason for this error, so it suggests a corrupted file during the FTP process, which is the most common problem.

Try reuploading the original ASP files again.

-------------
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: WebmasterFF
Date Posted: 02 August 2007 at 2:02pm

I uploaded all the asp again but still it still shows the same error

Posted By: WebWiz-Bruce
Date Posted: 02 August 2007 at 2:40pm

Are you sure you upgraded from version 8 to version 9, as the field in the database it is looking for is a field called banned which was bought in for version 8. If this field isn't in your database version 8 shouldn't have worked either.

-------------
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: WebmasterFF
Date Posted: 02 August 2007 at 5:21pm

I used the upgrade tool and it said it had upgraded successfully. Version 8 worked absolutely fine for me, which is why this has me a tiny bit confused!

Posted By: dreamboy3000
Date Posted: 24 October 2007 at 10:32am

We are still having this problem and their appears to be nothing wrong with the database. Any ideas?

Posted By: WebWiz-Bruce
Date Posted: 24 October 2007 at 10:43am

This is quite an old post you are dragging up from another user so you may not have the exact same issue, although the error message maybe similar. You would be best off starting a new topic for your issue and have as much details as possible such as error message, database type, version number, and what if any database upgrades you have done.

-------------
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: dreamboy3000
Date Posted: 24 October 2007 at 2:11pm

No, me and Webmasterff are co owners of the same website. We use 9.0 version and he does the technical side and cannot find a problem with our database. When clicking on a profile we get...........

The website cannot display the page

HTTP 500

Most likely causes:

The website is under maintenance.
The website has a programming error.

What you can try:

javascript:clickRefresh%28%29 - Refresh the page.

javascript:history.back%28%29; - Go back to the previous page.

res://ieframe.dll/http_500.htm#"> javascript:expandCollapse%28infoBlockID,%20true%29; - More information

Posted By: stonecutter
Date Posted: 30 October 2007 at 10:09pm

You haven't said whether you use the Access, MySql, or Sql version.
After a conversion to MySql from Access I had some database issues. I disabled "strict mode" in the my.ini file and a lot of the problems went away.
You may also want to make sure you have the latest version of MDAC installed on your system, assuming that you're a Microsoft user. Maybe a better fix could be suggested if we knew which OS, type or version of web server, and forum type you were using.

Posted By: WebWiz-Bruce
Date Posted: 31 October 2007 at 8:17am

A number of users has issues because they upgraded to a beta 9 version, which were intended for testing purposes only, and/or they used third party mods which altered the database schema.

This meant when the final version 9 was released that they have ended up with incompatible databases with incorrect datatypes set, and missing database fields, coursing the issues that you have mentions.

The only thing you can do now is download the latest version and go through every table checking every field is there and set to the correct datatype.

And in future please stick to the official advice, which is do NOT use beta test versions on a live web site, and do not use 3rd party mods which change the database schema, unless these 3rd party mods follow official guide lines and prefix any database changes with the letters MOD.

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