Web Wiz Support and Community Forums : Problem with Database https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 10:22:56 +0000 Wed, 31 Oct 2007 08:17:21 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24037 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Problem with Database : A number of users has issues because...]]> https://forums.webwiz.net/problem-with-database_topic24037_post128841.html#128841 Author: WebWiz-Bruce
Subject: 24037
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.
]]> Wed, 31 Oct 2007 08:17:21 +0000 https://forums.webwiz.net/problem-with-database_topic24037_post128841.html#128841 <![CDATA[Problem with Database : You haven&#039;t said whether...]]> https://forums.webwiz.net/problem-with-database_topic24037_post128828.html#128828 Author: stonecutter
Subject: 24037
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.


]]> Tue, 30 Oct 2007 22:09:27 +0000 https://forums.webwiz.net/problem-with-database_topic24037_post128828.html#128828 <![CDATA[Problem with Database : No, me and Webmasterff are co...]]> https://forums.webwiz.net/problem-with-database_topic24037_post128709.html#128709 Author: dreamboy3000
Subject: 24037
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:

 

Refresh the page.

 

Go back to the previous page.

 

More%20information More information

 
]]> Wed, 24 Oct 2007 14:11:22 +0000 https://forums.webwiz.net/problem-with-database_topic24037_post128709.html#128709 <![CDATA[Problem with Database : This is quite an old post you...]]> https://forums.webwiz.net/problem-with-database_topic24037_post128701.html#128701 Author: WebWiz-Bruce
Subject: 24037
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.]]> Wed, 24 Oct 2007 10:43:57 +0000 https://forums.webwiz.net/problem-with-database_topic24037_post128701.html#128701 <![CDATA[Problem with Database : We are still having this problem...]]> https://forums.webwiz.net/problem-with-database_topic24037_post128700.html#128700 Author: dreamboy3000
Subject: 24037
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?]]> Wed, 24 Oct 2007 10:32:33 +0000 https://forums.webwiz.net/problem-with-database_topic24037_post128700.html#128700 <![CDATA[Problem with Database : I used the upgrade tool and itsaid...]]> https://forums.webwiz.net/problem-with-database_topic24037_post125942.html#125942 Author: WebmasterFF
Subject: 24037
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!]]> Thu, 02 Aug 2007 17:21:35 +0000 https://forums.webwiz.net/problem-with-database_topic24037_post125942.html#125942 <![CDATA[Problem with Database : Are you sure you upgraded from...]]> https://forums.webwiz.net/problem-with-database_topic24037_post125926.html#125926 Author: WebWiz-Bruce
Subject: 24037
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.]]> Thu, 02 Aug 2007 14:40:12 +0000 https://forums.webwiz.net/problem-with-database_topic24037_post125926.html#125926 <![CDATA[Problem with Database : I uploaded all theasp againbut...]]> https://forums.webwiz.net/problem-with-database_topic24037_post125924.html#125924 Author: WebmasterFF
Subject: 24037
Posted: 02 August 2007 at 2:02pm

I uploaded all the asp again but still it still shows the same error]]> Thu, 02 Aug 2007 14:02:40 +0000 https://forums.webwiz.net/problem-with-database_topic24037_post125924.html#125924 <![CDATA[Problem with Database : There is no obvious reason for...]]> https://forums.webwiz.net/problem-with-database_topic24037_post125923.html#125923 Author: WebWiz-Bruce
Subject: 24037
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.
]]> Thu, 02 Aug 2007 13:47:36 +0000 https://forums.webwiz.net/problem-with-database_topic24037_post125923.html#125923 <![CDATA[Problem with Database : ADODB.Recordset error &#039;800a0cc1&#039;...]]> https://forums.webwiz.net/problem-with-database_topic24037_post125922.html#125922 Author: WebmasterFF
Subject: 24037
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

]]> Thu, 02 Aug 2007 13:41:11 +0000 https://forums.webwiz.net/problem-with-database_topic24037_post125922.html#125922