Web Wiz Forums - SQL Server Migration Issues

Print Page | Close Window

SQL Server Migration Issues

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

Topic: SQL Server Migration Issues

Posted By: Brolin99
Subject: SQL Server Migration Issues
Date Posted: 18 February 2006 at 7:16am

Hi there,

I have recently migrated my forums from one database to another. Everything is working perfectly, except when trying to add new topics. I have checked that the settings on the database tables are the same (i.e. what tables are identity and nulls etc.) but get this message (when trying to post with a poll):

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft>[ODBC SQL Server Driver>[SQL Server>Cannot insert the value NULL into column 'Votes', table 'sportsfreak-forum.dbo.tblForumPollChoice'; column does not allow nulls. INSERT fails.

/forum/post-message.asp, line 527

And this one with no poll:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft>[ODBC SQL Server Driver>[SQL Server>Cannot insert the value NULL into column 'Locked', table 'sportsfreak-forum.dbo.tblForumTopic'; column does not allow nulls. INSERT fails.

/forum/post-message.asp, line 578

Please help!!

Replies:

Posted By: WebWiz-Bruce
Date Posted: 20 February 2006 at 9:34am

Try giving these tables default values as it looks like you may not have imported the default values into the new database.

The column 'Votes' in the 'PollChoice' table should have the default value of '0' and the same for the 'Locked' column in the 'Topics' table.

-------------
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: Brolin99
Date Posted: 20 February 2006 at 6:58pm

Thanks Borg - it's now working perfectly.

Cheers