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



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