Web Wiz Support and Community Forums : Upgrade Issue with MSSQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 03:29:13 +0000 Sun, 06 Aug 2006 20:12:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20931 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Upgrade Issue with MSSQL : I figured out the problem. What...]]> https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112230.html#112230 Author: imhotep
Subject: 20931
Posted: 06 August 2006 at 8:12pm

I figured out the problem. What happen was, I didn't set the datatype correctly when I first entered the field. I think I had it at interger or something. So it automatically placed NULL values in each row.

So when I switched the datatype to "bit" it still had the values already in the fields. So after much experimenting, I simply deleted the field and then recreated the field using the correct values (bit with default value of 0) and it works fine now.

But thanks.
]]> Sun, 06 Aug 2006 20:12:12 +0000 https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112230.html#112230 <![CDATA[Upgrade Issue with MSSQL : I added the field &#034;Hide&#034;...]]> https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112219.html#112219 Author: imhotep
Subject: 20931
Posted: 06 August 2006 at 3:13pm

I added the field "Hide" into the tblThreads post and set it's value to "o" (at least for testing. It is a "bit" field. At first I couldn't get into the hidden fields section because the field didn't exist. Now it shows up and it will say that there are no hidden post to view. So that works fine.

But when trying to view topics now, I am getting:

Quote

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CBool'

/forum_temp/forum_posts.asp, line 779


I know it has to deal with a boolean value, but what should I set the field values to to correct this?

This is the code the error is calling attention to
Quote blnHidePost = CBool(sarryPosts(5,intCurrentRecord))


In the documentation, the changes given to the database are:

Quote Changes to tblThread
New fields:-
1. Hide - data type = true/false - default value = false
2. File_uploads - data type = text 255 characters


But there is no "true/false" datatype in SQL Server. I saw in the "msSQL_server_update.asp" file what to set it as and I did, but I get this error trying to update the SQL Server field:

Quote 'tblThread' table
- Unable to modify table. 
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'Hide', table 'mocha_db.dbo.Tmp_tblThread'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.


Another thing I've noticed is that I can add new content to the database. I just can't pull up the old content when I click on a forum topic. So what I think it is is simply that it is not adding the default value to the tblThreads table in each field, but it is adding it to new post.

How can I give all of the fields the default value in the actual table?


Edited by imhotep - 06 August 2006 at 7:02pm]]> Sun, 06 Aug 2006 15:13:40 +0000 https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112219.html#112219 <![CDATA[Upgrade Issue with MSSQL : Also when I try to view a topic,...]]> https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112215.html#112215 Author: imhotep
Subject: 20931
Posted: 06 August 2006 at 2:40pm

Also when I try to view a topic, i get this error:

Server Error in Forum Application
An error has occured while executing SQL query on database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_get_topic_posts_data
File Name:- forum_posts.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid column name 'Hide'.




What could be the problem?
]]> Sun, 06 Aug 2006 14:40:58 +0000 https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112215.html#112215 <![CDATA[Upgrade Issue with MSSQL : There were no modifications to...]]> https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112213.html#112213 Author: imhotep
Subject: 20931
Posted: 06 August 2006 at 2:27pm

There were no modifications to the database: just the home page. The error I got during installation was this

rror Discription: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
SQL Server database is set up, but with Error!

I don't know why it says it doesn't exist, but did all of the other upgrades.

Should I have run the setup from the new board (to create the tables) and then do the upgrade? WHo should I set as the the database owner?
]]> Sun, 06 Aug 2006 14:27:33 +0000 https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112213.html#112213 <![CDATA[Upgrade Issue with MSSQL : It sounbds like you didn&#039;t...]]> https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112205.html#112205 Author: WebWiz-Bruce
Subject: 20931
Posted: 06 August 2006 at 11:28am

It sounbds like you didn't upgrade the database properly.

Do the upgrade tool show an error when doing the upgrade?
Did you modify your 7.x database that you performed the upgrade on?

If you did modify your 7.x database then you need to go back to your 7.x backup database, remove any modifications, then run the upgrade tool.
]]> Sun, 06 Aug 2006 11:28:26 +0000 https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112205.html#112205 <![CDATA[Upgrade Issue with MSSQL : I recently did the upgrade using...]]> https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112190.html#112190 Author: imhotep
Subject: 20931
Posted: 05 August 2006 at 11:41pm

I recently did the upgrade using the upgrade tool for MSSQL Server and everything shows up fine, but I am getting errors when trying to post new topics. I am getting this:

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_save_new_post_data
File Name:- new_post.asp

Error details:-
ADODB.Recordset
Item cannot be found in the collection corresponding to the requested name or ordinal.

Can anyone help me out with this? What is going wrong here?
]]> Sat, 05 Aug 2006 23:41:24 +0000 https://forums.webwiz.net/upgrade-issue-with-mssql_topic20931_post112190.html#112190